Hi nicholas.tan,
Refer below code.
HTML
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
<Columns>
<asp:BoundField DataField="Id" HeaderText="Id" />
<asp:BoundField DataField="Name" HeaderText="Name" />
<asp:BoundField DataField="Country" HeaderText="Country" />
</Columns>
</asp:GridView>
Code
C#
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[3] {
new DataColumn("Id"),
new DataColumn("Name"),
new DataColumn("Country")
});
dt.Rows.Add(1, "John Hammond", "United States");
dt.Rows.Add(2, "Mudassar Khan", "India");
dt.Rows.Add(3, "Suzanne Mathews", "France");
dt.Rows.Add(4, "Robert Schidner", "Russia");
GridView1.DataSource = dt;
GridView1.DataBind();
for (int column = 0; column < GridView1.Columns.Count; column++)
{
bool isEmpty = false;
for (int row = 0; row < GridView1.Rows.Count; row++)
{
string value = GridView1.Rows[row].Cells[column].Text.Trim();
if (string.IsNullOrEmpty(value) || value == " ")
{
isEmpty = true;
}
else
{
break;
}
}
if (isEmpty)
{
for (int row1 = 0; row1 < GridView1.Rows.Count; row1++)
{
GridView1.Rows[row1].Cells[column].Enabled = false;
}
}
}
}
}
VB.Net
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
If Not Me.IsPostBack Then
Dim dt As DataTable = New DataTable()
dt.Columns.AddRange(New DataColumn(2) {
New DataColumn("Id"),
New DataColumn("Name"),
New DataColumn("Country")})
dt.Rows.Add(1, "John Hammond", "United States")
dt.Rows.Add(2, "Mudassar Khan", "India")
dt.Rows.Add(3, "Suzanne Mathews", "France")
dt.Rows.Add(4, "Robert Schidner", "Russia")
GridView1.DataSource = dt
GridView1.DataBind()
For column As Integer = 0 To GridView1.Columns.Count - 1
Dim isEmpty As Boolean = False
For row As Integer = 0 To GridView1.Rows.Count - 1
Dim value As String = GridView1.Rows(row).Cells(column).Text.Trim()
If String.IsNullOrEmpty(value) OrElse value = " " Then
isEmpty = True
Else
Exit For
End If
Next
If isEmpty Then
For row1 As Integer = 0 To GridView1.Rows.Count - 1
GridView1.Rows(row1).Cells(column).Enabled = False
Next
End If
Next
End If
End Sub