Fields with ‘Bit’ Data Types, when displayed on Web Pages show as True/False. They don’t show the actual ‘0’ / ‘1’.
If you are using a DataReader to retrieve such data, you could cast them explicitly to Int and show them with 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.
