VB>NET database connectivity with a table having checkboxes

Question

Can any1 help me hw 2 insert d code to move 2 d next record of the database in a table that has one CHECKBOX? i tried using the regular method of checkbox1=.Item("BookingStatus").ToString bt it gives a runtime error

Answer 1

As klabranche says, it's difficult to be sure without more information but I think you're probably looking for either of:

checkbox1.checked = CBool(.Item("BookingStatus"))  

checkbox1.checked = .Item("BookingStatus").ToString().Equals("X")  

Where X is some kind of status.

Just remember that if BookingStatus might be NULL you might have to check for that first as well.