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"]));}
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
