Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: Display of Bit Field on UI

Learn how to cast fields with 'Bit' data types explicitly to Int and show the actual values.


advertisement

WEBINAR:

Live

Full Text Search: The Key to Better Natural Language Queries for NoSQL in Node.js


Date: 1/31/2018 @ 2 p.m. ET

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"]));
}


 

Visit the DevX Tip Bank

 



   
Srinath M. S. says: "I would love to leave a footprint in this flat world."
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date