Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: .NET
Expertise: Beginner
Mar 25, 2008

Displaying "Bit" Database Fields in Web Forms

When you display the value of a field with a "Bit" data types in a Web Form, the values show as True or False, as opposed to the actual value of 0 or 1.

However, if you're using a DataReader to retrieve the data, casting the type explicity to Int displays the actual values, as shown below:

while (dr.Read ())
     Response.Write (Convert.ToInt16 ( dr["bitcolval"]));
Srinath MS
Thanks for your registration, follow us on our social networks to keep up-to-date