How to get Template value from grid?

Jaya Prakash


 
  
  




 <%# Eval("Status") %>

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 < Paymentview.Columns.Count; i++)
                {
                    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;
                    }
                    string statusValue = DataBinder.Eval(e.gridViewRow.DataItem, "Status").ToString();
                }
            }
        }

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

3 Replies

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

Naimish Makwana2y ago
Accepted 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 Makwana2y ago

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 Prakash2y ago
then i should add a label control?
can't we do without adding a label control?