c# - How to hide a specific value(column) from the gridview? -

in gridview have following things shown in binding of sql gridview in page_load want load upon opening page.

sqlconnection conn = new sqlconnection();         conn.connectionstring = "data source = localhost; initial catalog = majorproject; integrated security= sspi";         conn.open();          dataset ds = new dataset();          sqldataadapter da = new sqldataadapter("select memberreportid, typeofcrime, crdatetime, address, detail, incidentdate, incidenttime, property, victim, suspect memberreport", conn);         da.fill(ds);          gwcase.datasource = ds;         gwcase.databind();          conn.close(); 

however, i'm trying prevent property, victim , suspect column appearing in gridview. used

visible = false; 

in gridview totally remove gridview( of course ).

i tried using boundfield shown below in gridview , set visibility false set column visiblity false

    <asp:gridview id="gwcase" runat="server" backcolor="#cccccc" bordercolor="#999999" borderstyle="solid" borderwidth="3px" cellpadding="4" cellspacing="2" forecolor="black" width="100%" autogenerateselectbutton="true" onselectedindexchanged="gwcase_selectedindexchanged">         <footerstyle backcolor="#cccccc" />         <headerstyle backcolor="black" font-bold="true" forecolor="white" />         <pagerstyle backcolor="#cccccc" forecolor="black" horizontalalign="left" />         <rowstyle backcolor="white" />         <selectedrowstyle backcolor="#000099" font-bold="true" forecolor="white" />         <sortedascendingcellstyle backcolor="#f1f1f1" />         <sortedascendingheaderstyle backcolor="#808080" />         <sorteddescendingcellstyle backcolor="#cac9c9" />         <sorteddescendingheaderstyle backcolor="#383838" />       <columns>         <asp:boundfield datafield="property" headertext="property" sortexpression="property" visible="false"/>        <asp:boundfield datafield="victim" headertext="victim" sortexpression="victim" visible="false" />        <asp:boundfield datafield="suspect" headertext="suspect" sortexpression="suspect" visible="false" />       </columns>     </asp:gridview> 

however, column still being displayed. how remove 3 column gridview. please not ask me remove 3 attribute sql statement need data further functions.

i have tried method found in thread in

protected void gridview_rowdatabound(object sender, gridviewroweventargs e)     {         e.row.cells[7].visible = false;         e.row.cells[8].visible = false;         e.row.cells[9].visible = false;     } 

but didnt work :/

regards.

you need add code in row created event.

    protected void yourgrid_rowcreated(object sender, gridviewroweventargs e)     {     e.row.cells[7].visible = false;     e.row.cells[8].visible = false;     e.row.cells[9].visible = false;     } 

edit:

another option can after assigning datasource grid view write these lines after line in code

   gwcase.datasource = ds;    gwcase.databind();     gwcase.columns[7].visible = false;    gwcase.columns[8].visible = false;    gwcase.columns[9].visible = false;