Display of Bit Field on UI

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"]));}
Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Related Posts