Datalist binding

[Abhishek P.]

Hi

I am using a datalist bound to a query to display data.
The problem is that, in the query there is a numeric field
that stores values from 0 to 3, each corressponding to a
state {0-availble, 1-unavailable...and so on}.

When i bind the datalist, numeric values in the field
values are displayed . Is there any way (other than
modifying the query to use a CASE struct) by which i can
display text instead of numbers.

pls mail your suggestions to (e-mail address removed).

thanks

Abhishek P.

 

[S. Justin Gengo]

Abhishek,

You could use the ItemDataBound event of the datalist object.

When a list item is created and it's data is bound to it the ItemDataBound
event is fired. This allows you to change data on the fly for the list item.

However, it is probably more efficient to adjust your query.

--
Sincerely,

S. Justin Gengo, MCP
Web Developer / Programmer

Free code library at:
www.aboutfortunate.com

"Out of chaos comes order."
Nietzche