How to hide column which have null values in gridview.

Question

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

Mohsin Arif · Answer

hi 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 } } }

Subin Thomas · Answer

still its not working mohsin null columns are also displayed

Mohsin Arif · Answer

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

Rajanikant Hawaldar · Answer

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()); }

Subin Thomas · Answer

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

Mohsin Arif · Answer

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?

Subin Thomas · Answer

ohh is it amit okay i will paste it in vs

Subin Thomas · Answer

my gridview name is ActiveGridView5 mohsin

Amit Kumar · Answer

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.

Mohsin Arif · Answer

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

Subin Thomas · Answer

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

Subin Thomas · Answer

its not working mohsin i tried the code you suggested

Amit Kumar · Answer

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 ;}

Subin Thomas · Answer

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

How to hide column which have null values in gridview.

Answers (14)