Hi nagaraju60,
Refer the below sample.
HTML
<asp:GridView runat="server" ID="gvDetails" AutoGenerateColumns="false" OnDataBound="gvDetails_DataBound">
<Columns>
<asp:TemplateField HeaderText="Column1">
<ItemTemplate>
<asp:TextBox runat="server" ID="txtColumn1" Text='<%# Eval("Column1") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Column2">
<ItemTemplate>
<asp:TextBox runat="server" ID="txtColumn2" Text='<%# Eval("Column2") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Column3">
<ItemTemplate>
<asp:TextBox runat="server" ID="txtColumn3" Text='<%# Eval("Column3") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Column4">
<ItemTemplate>
<asp:TextBox runat="server" ID="txtColumn4" Text='<%# Eval("Column4") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Column5">
<ItemTemplate>
<asp:TextBox runat="server" ID="txtColumn5" Text='<%# Eval("Column5") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Column6">
<ItemTemplate>
<asp:TextBox runat="server" ID="txtColumn6" Text='<%# Eval("Column6") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Column7">
<ItemTemplate>
<asp:TextBox runat="server" ID="txtColumn7" Text='<%# Eval("Column7") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Column8">
<ItemTemplate>
<asp:TextBox runat="server" ID="txtColumn8" Text='<%# Eval("Column8") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Column9">
<ItemTemplate>
<asp:TextBox runat="server" ID="txtColumn9" Text='<%# Eval("Column9") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Column10">
<ItemTemplate>
<asp:TextBox runat="server" ID="txtColumn10" Text='<%# Eval("Column10") %>' />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
C#
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[10] {
new DataColumn("Column1", typeof(string)),
new DataColumn("Column2", typeof(string)),
new DataColumn("Column3",typeof(string)),
new DataColumn("Column4",typeof(string)),
new DataColumn("Column5",typeof(string)),
new DataColumn("Column6",typeof(string)),
new DataColumn("Column7",typeof(string)),
new DataColumn("Column8",typeof(string)),
new DataColumn("Column9",typeof(string)),
new DataColumn("Column10",typeof(string)) });
dt.Rows.Add("Regn. No:", "", "Regn. Date:", "", "Sample Name:", "", "NULL", "NULL", "NULL", "NULL");
dt.Rows.Add("Batch No.:", "", "Mfg. Dt.:", "", "Exp. Dt.:", "", "NULL", "NULL", "NULL", "NULL");
dt.Rows.Add("Sample Qty.:", "", "Analysis Started", "", "Completed On:", "", "NULL", "NULL", "NULL", "NULL");
gvDetails.DataSource = dt;
gvDetails.DataBind();
}
}
protected void gvDetails_DataBound(object sender, EventArgs e)
{
bool isColumn1Null = false, isColumn2Null = false, isColumn3Null = false, isColumn4Null = false, isColumn5Null = false;
bool isColumn6Null = false, isColumn7Null = false, isColumn8Null = false, isColumn9Null = false, isColumn10Null = false;
for (int i = 0; i < gvDetails.Rows.Count; i++)
{
if (!isColumn1Null) { isColumn1Null = (gvDetails.Rows[i].FindControl("txtColumn1") as TextBox).Text == "NULL" ? false : true; }
if (!isColumn2Null) { isColumn2Null = (gvDetails.Rows[i].FindControl("txtColumn2") as TextBox).Text == "NULL" ? false : true; }
if (!isColumn3Null) { isColumn3Null = (gvDetails.Rows[i].FindControl("txtColumn3") as TextBox).Text == "NULL" ? false : true; }
if (!isColumn4Null) { isColumn4Null = (gvDetails.Rows[i].FindControl("txtColumn4") as TextBox).Text == "NULL" ? false : true; }
if (!isColumn5Null) { isColumn5Null = (gvDetails.Rows[i].FindControl("txtColumn5") as TextBox).Text == "NULL" ? false : true; }
if (!isColumn6Null) { isColumn6Null = (gvDetails.Rows[i].FindControl("txtColumn6") as TextBox).Text == "NULL" ? false : true; }
if (!isColumn7Null) { isColumn7Null = (gvDetails.Rows[i].FindControl("txtColumn7") as TextBox).Text == "NULL" ? false : true; }
if (!isColumn8Null) { isColumn8Null = (gvDetails.Rows[i].FindControl("txtColumn8") as TextBox).Text == "NULL" ? false : true; }
if (!isColumn9Null) { isColumn9Null = (gvDetails.Rows[i].FindControl("txtColumn9") as TextBox).Text == "NULL" ? false : true; }
if (!isColumn10Null) { isColumn10Null = (gvDetails.Rows[i].FindControl("txtColumn10") as TextBox).Text == "NULL" ? false : true; }
}
if (!isColumn1Null) { gvDetails.Columns[0].Visible = false; }
if (!isColumn2Null) { gvDetails.Columns[1].Visible = false; }
if (!isColumn3Null) { gvDetails.Columns[2].Visible = false; }
if (!isColumn4Null) { gvDetails.Columns[3].Visible = false; }
if (!isColumn5Null) { gvDetails.Columns[4].Visible = false; }
if (!isColumn6Null) { gvDetails.Columns[5].Visible = false; }
if (!isColumn7Null) { gvDetails.Columns[6].Visible = false; }
if (!isColumn8Null) { gvDetails.Columns[7].Visible = false; }
if (!isColumn9Null) { gvDetails.Columns[8].Visible = false; }
if (!isColumn10Null) { gvDetails.Columns[9].Visible = false; }
}
VB.Net
Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
If Not IsPostBack Then
Dim dt As New DataTable()
dt.Columns.AddRange(New DataColumn(9) {
New DataColumn("Column1", GetType(String)), New DataColumn("Column2", GetType(String)), _
New DataColumn("Column3", GetType(String)), New DataColumn("Column4", GetType(String)), _
New DataColumn("Column5", GetType(String)), New DataColumn("Column6", GetType(String)), _
New DataColumn("Column7", GetType(String)), New DataColumn("Column8", GetType(String)), _
New DataColumn("Column9", GetType(String)), New DataColumn("Column10", GetType(String))})
dt.Rows.Add("Regn. No:", "", "Regn. Date:", "", "Sample Name:", "", "NULL", "NULL", "NULL", "NULL")
dt.Rows.Add("Batch No.:", "", "Mfg. Dt.:", "", "Exp. Dt.:", "", "NULL", "NULL", "NULL", "NULL")
dt.Rows.Add("Sample Qty.:", "", "Analysis Started", "", "Completed On:", "", "NULL", "NULL", "NULL", "NULL")
gvDetails.DataSource = dt
gvDetails.DataBind()
End If
End Sub
Protected Sub gvDetails_DataBound(sender As Object, e As EventArgs)
Dim isColumn1Null As Boolean = False, isColumn2Null As Boolean = False, isColumn3Null As Boolean = False, isColumn4Null As Boolean = False, isColumn5Null As Boolean = False
Dim isColumn6Null As Boolean = False, isColumn7Null As Boolean = False, isColumn8Null As Boolean = False, isColumn9Null As Boolean = False, isColumn10Null As Boolean = False
For i As Integer = 0 To gvDetails.Rows.Count - 1
If Not isColumn1Null Then
isColumn1Null = If(TryCast(gvDetails.Rows(i).FindControl("txtColumn1"), TextBox).Text = "NULL", False, True)
End If
If Not isColumn2Null Then
isColumn2Null = If(TryCast(gvDetails.Rows(i).FindControl("txtColumn2"), TextBox).Text = "NULL", False, True)
End If
If Not isColumn3Null Then
isColumn3Null = If(TryCast(gvDetails.Rows(i).FindControl("txtColumn3"), TextBox).Text = "NULL", False, True)
End If
If Not isColumn4Null Then
isColumn4Null = If(TryCast(gvDetails.Rows(i).FindControl("txtColumn4"), TextBox).Text = "NULL", False, True)
End If
If Not isColumn5Null Then
isColumn5Null = If(TryCast(gvDetails.Rows(i).FindControl("txtColumn5"), TextBox).Text = "NULL", False, True)
End If
If Not isColumn6Null Then
isColumn6Null = If(TryCast(gvDetails.Rows(i).FindControl("txtColumn6"), TextBox).Text = "NULL", False, True)
End If
If Not isColumn7Null Then
isColumn7Null = If(TryCast(gvDetails.Rows(i).FindControl("txtColumn7"), TextBox).Text = "NULL", False, True)
End If
If Not isColumn8Null Then
isColumn8Null = If(TryCast(gvDetails.Rows(i).FindControl("txtColumn8"), TextBox).Text = "NULL", False, True)
End If
If Not isColumn9Null Then
isColumn9Null = If(TryCast(gvDetails.Rows(i).FindControl("txtColumn9"), TextBox).Text = "NULL", False, True)
End If
If Not isColumn10Null Then
isColumn10Null = If(TryCast(gvDetails.Rows(i).FindControl("txtColumn10"), TextBox).Text = "NULL", False, True)
End If
Next
If Not isColumn1Null Then
gvDetails.Columns(0).Visible = False
End If
If Not isColumn2Null Then
gvDetails.Columns(1).Visible = False
End If
If Not isColumn3Null Then
gvDetails.Columns(2).Visible = False
End If
If Not isColumn4Null Then
gvDetails.Columns(3).Visible = False
End If
If Not isColumn5Null Then
gvDetails.Columns(4).Visible = False
End If
If Not isColumn6Null Then
gvDetails.Columns(5).Visible = False
End If
If Not isColumn7Null Then
gvDetails.Columns(6).Visible = False
End If
If Not isColumn8Null Then
gvDetails.Columns(7).Visible = False
End If
If Not isColumn9Null Then
gvDetails.Columns(8).Visible = False
End If
If Not isColumn10Null Then
gvDetails.Columns(9).Visible = False
End If
End Sub
Screenshot
