Retrieve checkbox value from database

Question

HI I have a registration form which has a checkbox for email notification Q: 1.how to insert delete and update form with checkbox value 2.Retrieve value of checkbox from database

Vishal Gilbile · Answer

Hello friend for storing checkbox value you could make use of column having Integer or byte datatype. and while storing the value from front end to the DB. you could check whether the checkbox is checked or not if it is checked you can store value as 1 or else 0. For instance. int value=CheckBox1.Checked==true?1:0; and while retrieving also you just need to check whether the Column cell contains value as 1 or not if it is one set the checked property of the checkbox to true or else false. Hope that solves your problem. With Regards Vishal Gilbile