thankx for your reply.:rose: but how i check the current value at that record? i need to know some codes like : // rowdatabound event if gridview1.rows(?).cells(??).text = "1" then gridview1.rows(?).cells(??).text = "YES" else gridview1.rows(?).cells(??).text = "NO" :^)

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