RETRIEVE GRIDVIEW CELL VALUE

Ananya Suhas

15y3.8k.NET

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....

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Subhendu De15y ago
Accepted answer
Change the following line
for (int i = 0; i <= rowcount - 1; i += i + 1) {
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 De15y ago
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 Suhas15y ago
Thanx.. Can u plzz explain the loop..
Suthish Nair15y ago
change the code line to..

int id = ((Label)gvr.Rows(i).Cells(1).FindControl("lblid")).Text;

Ananya Suhas15y ago

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 <= rowcount - 1; i += i + 1) {
			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 De15y ago
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