I have a Dataview grid that contains a column called Status.

In the database the value is enumerated.. so if a record has a Status of Closed the database value is 5 - if Status is Open database value is 1. I am getting the numbers in my page and I would like to somehow convert these dynamically so the user sees Closed, Open etc instead of 0,1,2..etc.

Is this possible. .Net Framework 3.5

-Ina Gaida Binta Single Baby

1) Do you have a status type table in the database that contains the values and names? If so, then just join to that table and use the name column instead of the value.

2) Do these map to an enum in the code? Is so, use the Enum class static method GetName. See MSDN:

http://msdn2.microsoft.com/en-us/lib...m.getname.aspx

-Peter
peterlanoie.blog

I added a new table that does the translation and then did a join query - all is good now. Thanks.

-Ina Gaida Binta Single Baby