Hiding gridview column for particular condition

Question

Hiding gridview column for particular condition

Hello everyone, I need your appreciated help.

Between the columns of my GridView I have this field:

<asp:BoundField DataField="DIST-V" DataFormatString="{0:#,##0.###}"
HeaderText="Dist (n.)" />

I need see it only when the condition is verified in the my query Sql Server 2005.

If the column DIST-V is selected in my query I need see the value of recordset DIST-V else I don't see the column DIST-V in my Gridview.

Can you help me?
Thank you in advance.

Chevy

Dorababu Meka · Answer

Try this if (DataSet.Tables[0].Columns. Contains(DIST-V)) { visibilty to true } else { flase }

Dorababu Meka · Answer

Ok you are welcome

Chevy Mark Sunderland · Answer

I'm sorry my error in the copy/paste. Now working thank you very much! protected void GridView1_RowDataBound(object sender GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { if ( dset .Tables[0].Columns.Contains(DIST-V)) { GridView1.Columns[1].Visible = true; } else { GridView1.Columns[1].Visible = false; } } }

Chevy Mark Sunderland · Answer

Here: if (DataSet.Tables[0].Columns.Contains(DIST-V))

Dorababu Meka · Answer

where you are getting that error

Chevy Mark Sunderland · Answer

Thank you but I have new error in your last code. protected void GridView1_RowDataBound(object sender GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { if (DataSet.Tables[0].Columns.Contains(DIST-V)) { GridView1.Columns[0].Visible = true; } else { GridView1.Columns[0].Visible = false; } } } CS0120: An object reference is required for the nonstatic field method or property ''System.Data.DataSet.Tables.get' the error seems to be coming from the following lines of code;

Chevy Mark Sunderland · Answer

protected void GridView1_RowDataBound(object sender GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { if (DataSet.Tables(0).Columns.Contains(DIST-V)) { GridView1.Columns[1].Visible = false; } } } Compiler Error Message: CS1955 : Non-invocable member ' System . Data . DataSet . Tables ' cannot be used like a method

Dorababu Meka · Answer

Then there is no column with that name in your dataset can you paste your dataset values that you are getting . Try this if(DataSet.Tables(0).Columns.Contains( DIST-V )) { you code to hide the column }

Chevy Mark Sunderland · Answer

Here: if (e.Row.RowType == DataControlRowType.DataRow) { if (dset.Tables[0].Rows[0].Columns[DIST-V] == DIST-V) // Here { GridView1.Columns[0].Visible = false; } }

Dorababu Meka · Answer

Where you are getting that error exactly if (e.Row.RowType == DataControlRowType.DataRow) // Here { if (dset.Tables[0].Rows[0].Columns[DIST-V] == DIST-V) // Or here { GridView1.Columns[0].Visible = false; } }

Chevy Mark Sunderland · Answer

This is my code: Server Side Code: protected void Page_Load(object sender EventArgs e) { ConnSqlServer.Open(); if (!Page.IsPostBack) { //Run the sql query } } protected void GridView1_RowDataBound(object sender GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { if (dset.Tables[0].Rows[0].Columns[DIST-V] == DIST-V) { GridView1.Columns[0].Visible = false; } } } HTML Code in .aspx File PageSize=25 ShowHeader=true>

Dorababu Meka · Answer

Are you getting this error at your dataset statement  is it entering in to the loop?

Chevy Mark Sunderland · Answer

Thanks for help. I tried your suggestion but I have this error: Compiler Error Message: CS1061: 'System.Data.DataRow' does not contain a definition for ' Columns ' and no extension method ' Columns ' accepting a first argument of type 'System.Data.DataRow' could be found (are you missing a using directive or an assembly reference?) if (dset.Tables[0].Rows[0].Columns[DIST-V] == DIST-V) { GridView1.Columns[0].Visible = false; }

Dorababu Meka · Answer

If your dataset contains a result then you can write a condition some thing like GridView1_RowDataBound event you can write some thing like as follows if(ds.Tables[0].Rows[0].Columns[YourCoumnName]==YourDBColumn) { gridview1.Columns[0].Visible = false; // Here you have loop through your gridview rows and set particular column on all rows as false }