RETRIEVE GRIDVIEW CELL VALUE

Question

Hi Using dataset how can we retrieve cell value in a gridview? I want the secong cell value. all columns are labels..I have used this method: Dim label lblprod=Ctype(grv.Rows(e.RowIndex).FindControl(lblprod)label) Also used lblprod=grv.Rows(rowindex).Cells(1).Text.. But these are not fetching the cell value.. Based on which i need to update and delete the table... Is there any other way DataSet.Table... like that? I am a new bieee so plzzz try to understand me and plzz explain in simple words... Thanx....

Subhendu De · Answer

Change the following line for (int i = 0; i int id = ((Label)gvr.Rows(i).FindControl(lblid)).Text; obj.cmd.CommandText = update tblitems set bill_number=' + billnum + ' where id=' + id + '; obj.cmd.ExecuteNonQuery(); The updated code would be foreach (GridViewRow gdRow in gdr.Rows) { Label lbl = gdRow.FindControl(lblid) as Label; obj.cmd.CommandText = update tblitems set bill_number=' + billnum + ' where id=' + lbl.Text + '; obj.cmd.ExecuteNonQuery(); }

Subhendu De · Answer

Since you are not referencing the gridview from GridViewRowEventArgs hence you will not reference particular cell... So your requirement is to get the label within gridview in button click event. That's why I iterate over each row of the gridview find the control in the row and referencing it. That's it.....

Ananya Suhas · Answer

Thanx.. Can u plzz explain the loop..

Suthish Nair · Answer

change the code line to.. int id = ((Label)gvr.Rows(i). Cells(1). FindControl(lblid)).Text;

Ananya Suhas · Answer

private string billnumber() { string num = System.Guid.NewGuid().ToString(); int charCount = 0; foreach (char c in num) { if (char.IsDigit(c)) { billnum += c.ToString(); charCount += 1; } if (charCount == 6) { break; } } return billnum; } protected void btnbuy_Click(object sender System.EventArgs e) { try { billnum = billnumber(); int rowcount = gvr.Rows.Count; obj.Connect(); for (int i = 0; i int id = ((Label)gvr.Rows(i).FindControl(lblid)).Text; obj.cmd.CommandText = update tblitems set bill_number=' + billnum + ' where id=' + id + '; obj.cmd.ExecuteNonQuery(); } } catch (Exception ex) { } } ========================================================== The gvr(gridview) has five columns which are boundfield. only the second column is a label.It should give me the label value ==========================================================

Subhendu De · Answer

Send me your gridview code. It should fetch.... You are missing something. The cell contains the label control. You need to reference the label and then through it's text property you can get the value. In order to give you a solution please forward the code. Dim lblprod as label = Ctype(grv.Rows(e.RowIndex). access Cell code >FindControl(lblprod)label) lblprod.Text should give the value