Wednesday, March 7, 2012

Need a little help

Is there a way to include either a checkbox or a yes/no field in SQL? Here is why I ask. I have a small db that I am creating that will house data about cars. I want to display two of these cars based off of a user selected field in SQL, or on a webform. There will be about a hundred or so cars that will be available, but I only want the ones that the user selects to show on my page. What is the best way to accomplish this?

DUUUUHHHHH.... how about adding a bit field to the db and a checkbox field to the Grid View!!

|||YesNo fields in Sql Server are bit datatypes - 1 or 0. The value can be read as 1 or 0, true or false.

No comments:

Post a Comment