datagrid column question

[Guest]

is there a way to make an if statement for a datagrid column?

i am currently filling a dataset from a mysql database and then putting it
into the datagrid. one of the fields is "Status" and it has a 0 for Active
and a 1 for Inactive. is there any way to make the datagrid display Active
or Inactive instead of 0 or 1 without creating a datatable and importing the
dataset to a datatable? the dataset has about 5,000 records and takes to
long to create a datatable.

thanx in advance.

 

[Brock Allen]

Yes, if you're using a DataSet. Add a new column to the DataTable and set
the Expression column. You can use access-like syntax in here, including
an IIF statement (if and only if). Check the docs on the allowed syntax (it's
quite decent):

http://msdn.microsoft.com/library/d...fsystemdatadatacolumnclassexpressiontopic.asp

-Brock
DevelopMentor
http://staff.develop.com/ballen