Grid View

[Guest]

I have a Grid View. Here I have a column "Active". I attached this GridView
to objectDataSource. In database this field has true or false value.(1 or
0). But in Grid View I want to show that if this field has value 1 in
database the value for this column should show "Yes" but if the value of this
field is 0 in data base the The GridView should show "No".

How can I do that.

 

[Guest]

Hi,
You can handle it in two ways.In first way you can handle at sql query level
in stored procedure itself by using CASE syntax.Or you can handle in asp.net
by using rowdatabound event.For tutorial on how to use rowdatabound event for
gridview refer below link:
http://www.asp.net/learn/data-access/tutorial-11-cs.aspx