How to get Template value from grid?

Question

' style="font-size: 13px;font-weight:bold;"> when i filter my grid with Status im getting records and im looping through the grid to get each row values storing in a string variable and send to database im trying like this protected void HitAPI_Click(object sender, EventArgs e) { foreach(GridViewRow gridViewRow in Paymentview.Rows) { for (int i = 0; i but here im unable to get status value as pending returning null to me how can i get it and also i keep checks for if cell value is empty is should not take   instead of this it should take empty if cell doesn't contain a value? pls help me

Naimish Makwana · Answer

In your code, you are trying to access the Status value from a TemplateField in a GridView . However, the TemplateField does not expose its value through the Cells collection like a BoundField does. Instead, you need to find the control in the TemplateField and get the value from it. Here’s how you can modify your code to get the Status value: protected void HitAPI_Click(object sender, EventArgs e) { foreach (GridViewRow gridViewRow in Paymentview.Rows) { if (!String.IsNullOrWhiteSpace(gridViewRow.Cells[2].Text)) { String RequestID = gridViewRow.Cells[2].Text; } if (!String.IsNullOrWhiteSpace(gridViewRow.Cells[3].Text) || gridViewRow.Cells[3].Text != " ") { String AckNo = gridViewRow.Cells[3].Text; } if (!String.IsNullOrWhiteSpace(gridViewRow.Cells[4].Text)) { String UTR = gridViewRow.Cells[4].Text; } // Find the control in the TemplateField and get the value from it Label lblStatus = (Label)gridViewRow.FindControl("lblStatus"); if (lblStatus != null) { string statusValue = lblStatus.Text; } } } In this code, I’m using the FindControl method to find the Label control in the TemplateField . Once the control is found, you can get the Text property from it which should give you the Status value. Also, to check if a cell is empty, you can compare the Text property of the cell to , which is the HTML entity for a non-breaking space. This is often used in HTML to represent an empty space. If the Text property is equal to you can consider the cell to be empty. In your code, you are already doing this correctly. Thanks

Naimish Makwana · Answer

Try this one. protected void HitAPI_Click(object sender, EventArgs e) { foreach (GridViewRow gridViewRow in Paymentview.Rows) { if (!String.IsNullOrWhiteSpace(gridViewRow.Cells[2].Text)) { String RequestID = gridViewRow.Cells[2].Text; } if (!String.IsNullOrWhiteSpace(gridViewRow.Cells[3].Text) || gridViewRow.Cells[3].Text == " ") { String AckNo = gridViewRow.Cells[3].Text; } if (!String.IsNullOrWhiteSpace(gridViewRow.Cells[4].Text)) { String UTR = gridViewRow.Cells[4].Text; } // Find the span control that holds the Status value var statusControl = (gridViewRow.Cells[5].FindControl("Status") as Span); if (statusControl != null) { string statusValue = statusControl.InnerText; } } } Regarding your second question,   is the HTML entity for a non-breaking space. When you check if a cell’s text is   , you’re effectively checking if the cell is empty. If you want to replace   with an empty string, you can do so like this: String AckNo = gridViewRow.Cells[3].Text.Replace(" ", string.Empty); Thanks.

Jaya Prakash · Answer

then i should add a label control? can't we do without adding a label control?