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;

Comments

Post a Comment

Popular posts from this blog

c++ - End of file on pipe magic during open -

i have c++ application in starting process(wireshark) following. if (fp == null){ fp = popen(processpath, "r"); //processpath process want start if (!fp){ throw std::invalid_argument("cannot start process"); } fprintf(fp, d_msg);//d_msg input want provide process } else if(fp != null){ fprintf(fp, d_msg); } the problem when execute c++ application, start wireshark error end of file on pipe magic during open what should avoid that? also tried using mkfifo create named pipe , execute it. used this: if (fp == null){ system("mkfifo /tmp/mine.pcap"); fp = popen("wireshark -k -i /tmp/mine.pcap", "r"); if (!fp){ dout << "cannot start wireshark"<<std::endl; throw std::invalid_argument("cannot start wireshark"); } input = fopen("/tmp/mine.pcap", "wb"); fprintf(input , d_msg); fclose(input)...
Read more

basic authentication with http post params android -

i doing basic authentication passing username , password , using basicnamevaluepair sending post params response service. my method: public stringbuilder callservicehttppost(string username, string password, string type) { // create new httpclient , post header httpclient httpclient = new defaulthttpclient(); httppost httppost = new httppost(webservice + type); httpresponse response = null; stringbuilder total = new stringbuilder(); try { url url = new url(webservice + type); /*string base64encodedcredentials = base64.encodetostring((username + ":" + password).getbytes(), base64.url_safe | base64.no_wrap);*/ string base64encodedcredentials = "basic " + base64.encodetostring( (username + ":" + password).getbytes(), base64.no_wrap); httppost.setheader("auth...
Read more

data.table making a copy of table in R -

i doing this: myfun <- function(inputvar_vec){ # inputvar_vec input vector # # result = output vector return(result) } dt[, result := lapply(.sd, myfun), = byvar, .sdcols = inputvar] i getting following warning: warning message: `in `[.data.table`(df1, , `:=`(prop, lapply(.sd, propeventinlastk)), : invalid .internal.selfref detected , fixed taking copy of whole table, := can add new column reference. @ earlier point, data.table has been copied r (or been created manually using structure() or similar). (and more stuff) .... ` my guess because stacking result vectors (after operation), copy being made? can suggest method remove warning? have done using apply functions , thought should extendable here too. my other question is: can pass chunk of rows data frame (subsetted using statement), , call function myfun operate on that? adding example requested # generate data n = 10000 default=na value = 1 df = data.table(id = sample(1:5000, n, replace=true), ...
Read more