Bind text to Gridview according to data

[sudhaMurugesan]

Hi to all,
I need to bind 'yes or no' in a grid view column according to status which is boolean.
I am Binding Status field directly to grid view column using this code
'<%#Eval("Status").ToString() %>' . But i want to bind yes if Status ='true' else No . how to do this, any help?

[leela mn]

you can do so by two ways.......

while getting the data from the database itself u can put case statement and get the data in yes/no format

or

loop through the gridview rows set the values yes/no for that column by checking true/false

[sudhaMurugesan]

you can do so by two ways.......

while getting the data from the database itself u can put case statement and get the data in yes/no format

or

loop through the gridview rows set the values yes/no for that column by checking true/false

Thanks Leela, Can you tell me the code for the second method i.e looping each gridview row.

[sudhaMurugesan]

you can do so by two ways.......

while getting the data from the database itself u can put case statement and get the data in yes/no format

or

loop through the gridview rows set the values yes/no for that column by checking true/false

Thanks Leela, Can you tell me the code for the second method of looping thro' rows

[gomzi]

Hi to all,
I need to bind 'yes or no' in a grid view column according to status which is boolean.
I am Binding Status field directly to grid view column using this code
'<%#Eval("Status").ToString() %>' . But i want to bind yes if Status ='true' else No . how to do this, any help?

You can try this,
<%# iff(DataBinder.Eval(Container.DataItem("Status")). ToString().Equals("true"),"yes","no") %>

OR

As Leela mentioned,

Once you have taken the data in a dataset, you can add another column to the dataset, loop through the original dataset and add appropriate value for the new column.

[leela mn]

Thanks Leela, Can you tell me the code for the second method of looping thro' rows

foreach(GridViewRow row in grd.Rows)
{

}

[prabunewindia]

you can write one method in your code behind

public string getYesNo()
{
string Status="';
// code to get that status bool
if(status==true)
{
Status="Yes";
}
else
{
Status="No";
}
}

you should pass one parameter according your DataKeyfiled like below

public string getYesNo(string primaryKey)


and then call this in your gridview field text property

Text=<% # getYesNo(withparameter) %>
Prabu