c# - Display value on a label from a specific column of the gridview which is not viewable physically -

i'm creating thread followed previous 1 here.

i'm trying create gridview filled data database. however, can see bottom 3 boundfield, have prevented them appearing on webapp.

 <columns>     <asp:boundfield datafield="memberreportid" headertext="property" sortexpression="false"/>     <asp:boundfield datafield="typeofcrime" headertext="property" sortexpression="false" />     <asp:boundfield datafield="crdatetime" headertext="property" sortexpression="false" />     <asp:boundfield datafield="address" headertext="property" sortexpression="false" />     <asp:boundfield datafield="detail" headertext="property" sortexpression="false"/>     <asp:boundfield datafield="incidentdate" headertext="property" sortexpression="false" />     <asp:boundfield datafield="incidenttime" headertext="victim" sortexpression="false"/>     <asp:boundfield datafield="property" headertext="suspect" sortexpression="false" visible="false" />     <asp:boundfield datafield="victim" headertext="suspect" sortexpression="false" visible="false" />     <asp:boundfield datafield="suspect" headertext="suspect" sortexpression="false" visible="false" />   </columns> 

i'm trying display them out onto label despite them not being able see physically via webpage. used method display them out when select button being clicked ( have set "autogenerateselectcolumn" true)

protected void gwcase_selectedindexchanged(object sender, eventargs e)     {         lbmemberreportid.text = gwcase.selectedrow.cells[1].text;         lblproperty.text = gwcase.selectedrow.cells[8].text;          lblvictim.text = gwcase.selectedrow.cells[9].text;         lblsuspect.text = gwcase.selectedrow.cells[10].text;     } 

unfortunately, i'm able display out memberreportid onto label not other 3 attirbute believe doesn't because hid physically. there other method apart 1 attempted display out specific value when being selected in gridview?

updated

page_load binding

 protected void page_load(object sender, eventargs e)     {          if (!ispostback)         {             loadgrid();         }       }      private void loadgrid()     {         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, detail, suspectdetail, propertydetail memberreport", conn);         da.fill(ds);          gwcase.datasource = ds.copy();         gwcase.databind();          conn.close();          ddlpid1.visible = false;         ddlpid2.visible = false;         ddlpid3.visible = false;         ddlpid4.visible = false;         ddlpid5.visible = false;         ddlpid6.visible = false;         ddlpid7.visible = false;         ddlpid8.visible = false;         ddlpid9.visible = false;         ddlpid10.visible = false;     } 

trying read hidden field

protected void gwcase_pageindexchanging(object sender, gridviewpageeventargs e)     {         loadgrid();         gwcase.pageindex = e.newpageindex;         gwcase.databind();     } 

well can take different approach , place value in hidden field:

<columns>     ...     <asp:templatefield>         <itemtemplate>             <asp:hiddenfield id="hdfsuspect" runat="server" value='<%# eval("suspect") %>' />         </itemtemplate>     </asp:templatefield> </columns> 

then can access doing following:

protected void gwcase_selectedindexchanged(object sender, eventargs e) {     ...     lblsuspect.text = ((hiddenfield) gwcase.selectedrow.findcontrol("hdfsuspect")).value; }