Quick formatting question

[quinnipiac0807]

Quick formatting question. What is the easiest way to change the format of a boolean variable in a datagrid on an asp webpage. Would it be to do it in the SQL procedure, or is there a way to put it right in the c# code?

 

[AtomicChip]

Usually, I'd just stick in something like:

<%# ((byte)DataBinder.Eval(Container,"DataItem.boolCol") == 1) ? "true string" : "false string" ) %>

There may be some syntax errors there - I didn't test it, but that should give you an idea.

-----------------------------------------------

http://www.liquidfuzion.com

"The night sky over the planet Krikkit is the least interesting sight in the entire universe."
-Hitch Hiker's Guide To The Galaxy

 

[NatGreen]

I would use a case statement inside the SQL sp

SELECT
Firstname,
LastName,
CASE IsActive
WHEN '0' THEN 'No'
WHEN '1' THEN 'Yes'
END
FROM UserInfo

Regards,
NatGreen