display a string in GridView istead of DB value

[mcbulan]

Hi
I have a probably quite easy question but which drives me crazy!
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?
Thanks and Regards

mcbulan

 

[JohnH]

Have you tried the GridView.RowDataBound Event ?

 

[mcbulan]

i solved

yes, i found the solution with row data bound event. thankx a lot