Gridview issue

Pankaj Singh

Hi,

I am binding data from SQL table in gridview. I want to change one column(command field) value not header at runtime. I am using following code but it change header also.

HTML code:

ShowSelectButton="True">

server side code:

protected void grddetails_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow || e.Row.RowType == DataControlRowType.Header)
{
int len = ds.Tables[0].Rows.Count;
for (int i = 0; i < len; i++)
{
int id = Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[0]);
// check ID exists or not
com = new SqlCommand("SELECT 1 FROM Table WHERE id=" + id + "", con);
con.Open();
drd = com.ExecuteReader();
if (drd.Read())
e.Row.Cells[4].Text="Apply";

else

e.Row.Cells[4].Text="not Apply";
con.Close();

}

}

Please help me

Thanks in advance

6 Replies

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

Shen Hengbin14y ago
Accepted answer
```
like .
e.Row.Cells[i].Controls.Add(your linkbutton);
```
Pankaj Singh14y ago
Thank you so much
Pankaj Singh14y ago
its working well but its showing only text like label of Apply or NotApply . but I want Show like linkbutton. Please help me Thanks
Shen Hengbin14y ago
The rowDataBound event is raised for each row rendered by the GridView control after the GridView control is bound to its data source. So in your source code above , you have done the same loop in each row. Always used the last row . you can try like bellow instead of loop.
if (e.Row.RowType == DataControlRowType.DataRow)
{
DataRow row = ((DataRowView)e.Row.DataItem).Row;
int id = Convert.ToInt32(row.ItemArray[0]);

        com = new SqlCommand("SELECT 1 FROM Table WHERE id=" + id + "", con);
        con.Open();
        drd = com.ExecuteReader();
        if (drd.Read())
          e.Row.Cells[4].Text="Apply";
        else
          e.Row.Cells[4].Text="not Apply";
        con.Close();
}
Pankaj Singh14y ago
Now, Header is not changing but that cell is gettng only last value like if condition is true in last so it shows Apply in all rows and if false so Not Apply Help me.. Thanks
Shen Hengbin14y ago
Change

if (e.Row.RowType == DataControlRowType.DataRow || e.Row.RowType == DataControlRowType.Header)

To

if (e.Row.RowType == DataControlRowType.DataRow)

DataControlRowType.Header is the header row.