Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Checkboxes w/ MSSQL

Status
Not open for further replies.

djsuperz

IS-IT--Management
Joined
Jan 25, 2004
Messages
37
Location
US
When dealing with check boxes what datatype should i use? Bit or Const?
Then in VB.NET which should i bind it to: Checked, CheckState, Tag or Text?
thanks in advance
 
1) Use the Bit type, unless you plan to index on it, in which case you should use TinyInt

2) If you're just using a checkbox as a on/off value, then use the Checked property. If you're using the checkbox in it's three-state mode, then I don't think you can bind it, as the CheckState property returns one of three possible values from the CheckState enumeration.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top