I have an SQLDataSource control, which is bound to an ASP.net
GridView control. It outputs a list of user roles that a admin can give status like user,admin or disabled
In my gridview, I have a column called "Status" which is bound to
a column in my database, called "isCompanyAdmin". A zero means User, and a
one means Admin status.
Showing a 0 or 1 is ugly and I want to use USER or Admin. I can't figure
out how to get at my SQLDataSource control's rows so that I can look at
them and write text out, rather than what's in the database (a 0 or 1).
My code is like this:
<asp:Label ID="lbStatus" runat="server" text='<%# Eval("isCompanyAdmin")
%>' />
I've tried assiging the return value of Eval("isCompanyAdmin") to a local
variable, but I get asp errors telling me that Eval must be used in a
databound control.
I want to do something like this:
If Eval("CheckedOut") = "0" Then
...
Else
...
End Of
I can post real code if that helps- but it's more the approach I am
looking for...
Thanks for any help