Hi

I am using a Gridview in my web page. I bind with a sqldatasource and gridview displays all data correctly.
But i want gridview to display an another string instead of the data in database.
For example :
There is a field named "isexists" in my table having 1 or 0 data.
But on the web page , i want to show that column data as "YES" (instead of 1) and "NO" (instead of 0) in gridview.
Could you please help me about this?

Thank you
Jitesh
Programmer



Sharepoint Consulting

__________________
Sharepoint Consulting

Hey,

Override the RowDataBound event. This event fires once for every row, and do something like this:

void grid_RowDataBound(..)
{
  if (e.Row.RowType != DataControlRowType.DataRow)
    return;

  e.Row.Cells[index].Text = (e.Row.Cells[index].Text == "1" ? "Yes" : "No");
}

Brian

hi there,

           I am Thank full for your response, that's indeed a good solution. i will defiantly try it out.but is there any other way to do so.

Any replies or suggestion is most welcome.

Thanking you
Jitesh
Programmer


Sharepoint Consulting