How to hide column which have null values in gridview.

i have a gridview with null columns i dont want to show null columns in my gridview

how to hide those

still its not working mohsin null columns are also displayed

protected void ActiveGridView5_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
for (int i = 0; i < ActiveGridView5.Rows.Count; i++)
{
string val = e.Row.Cells[i].ToString(); //check first cell value
if (string.IsNullorEmpty(val))
{
ActiveGridView5.Columns[i].Visible = false; //Hides First Column
}
}
}
}

Hi Subin

Check this example and try yourself.

If you want to hide all empty columns you could iterate through the DataSource collection to determine whether the corresponding property has been set for any dlgItem object:

public void HideEmptyColumns()
{
objGridView.DataSource = new BindingList();//binding to gridview
var t = new Task(() =>
{
...
});
t.Start();
t.ContinueWith(task =>
{
bool displayNameColumn = false;
bool displayFornameColumn = false;
bool displayCompanyColumn = false;
foreach (dlgItem item in (BindingList)objGridView.DataSource)
{
if (!string.IsNullOrEmpty(item.Name))
displayNameColumn = true;
if (!string.IsNullOrEmpty(item.Forname))
displayFornameColumn = true;
if (!string.IsNullOrEmpty(item.Compagny))
displayCompanyColumn = true;
}
objGridView.Columns[0].Visible = displayNameColumn;
objGridView.Columns[1].Visible = displayFornameColumn;
objGridView.Columns[2].Visible = displayCompanyColumn;
}, System.Threading.CancellationToken.None, TaskContinuationOptions.None, TaskScheduler.FromCurrentSynchronizationContext());
}

i tried the code mohsin but its not working the null columns are also visible in the gridview

protected void ActiveGridView5 _RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
string val = e.Row.Cells[0].ToString(); //check first cell value
if(string.IsNullorEmpty(val) )
{
ActiveGridView5 .Columns[0].Visible = false; //Hides First Column
}
}

}

sobin try this on roww bind event and tell me what the result are?

ohh is it amit okay i will paste it in vs

my gridview name is ActiveGridView5 mohsin

Sorry Dost, I m replying with mobile then so I can't do that , you can do one thing paste this code in Visual Studio then you can understand easily.

hi please tell me your gridview name or send me snapshot of your code

hey amit can you put the code in syntax highliter code so that i can understand lil easy

its not working mohsin i tried the code you suggested

Hi,

Use the below code . It will help you.

protected void dataGrid_DataBinding(object sender, EventArgs e)
{
int i = dataGrid.Items.Count;int j = 0;
foreach (DataGridItem item in dataGrid.Items)
{
string id = (item.Cells[2].FindControl("lblTableId") as Label).Text;
if (string.IsNullOrEmpty(id))
{j++;}}if (j == i)dataGrid.Columns[2].Visible = false;}

im getting exception on gvSearchEngine its saying the name does not exist in current context

try this one

protected void gridView_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
string val = e.Row.Cells[0].ToString(); //check first cell value
if(string.IsNullorEmpty(val) )
{
gvSearchEngine.Columns[0].Visible = false; //Hides First Column
}
}
}

14 Replies

Know the answer? Post it — somebody with the same question will find it here.

Subin Thomas7y ago
still its not working mohsin null columns are also displayed
+1
Mohsin Arif7y ago
1. protected void ActiveGridView5_RowDataBound(object sender, GridViewRowEventArgs e)
2. {
3. if (e.Row.RowType == DataControlRowType.DataRow)
4. {
5. for (int i = 0; i < ActiveGridView5.Rows.Count; i++)
6. {
7. string val = e.Row.Cells[i].ToString(); //check first cell value
8. if (string.IsNullorEmpty(val))
9. {
10. ActiveGridView5.Columns[i].Visible = false; //Hides First Column
11. }
12. }
14. }
15. }
try this please ??
+2