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.

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/de...ssiontopic.asp

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



> 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.
>