Hello,

I have a data grid control. One of the fields (of the SQL Server data source for the control) is a code value:

T = Valid
F = Invalid

Instead of displaying the T/F, I want to display Valid/Invalid. How can I do this manually? Do I use a template column field?

Thanks,

Brian Mains

__________________
Brian

Can you modify the query? I'd say the easiest way would be to change the query to return the desired values:

SELECT ..., CASE tfField WHEN 'T' THEN 'Valid' ELSE 'Invalid' END AS tfField ...

Peter
------------------------------------------------------
Work smarter, not harder.

I was wondering if the databindings event would handle this... Not necessarily for the data grid, but for other uses (such as binding a label or textbox), would the data bindings event handle what I wanted to do?

Thanks.

The OnItemDataBound event of the datagrid will fire for each item that's created and bound. Potentially, you could look in the grid for the code value and translate it into your desired string. (remember though that the header and footer of the grid are also bound so you have to skip those items in the handler.)

Peter
------------------------------------------------------
Work smarter, not harder.