How to retrieve data to checkbox

Question

Hello I need help with checkboxes. I have a field (nvarchar) in a table on SQL Server and i want to return values in a checkbox. For example if field=H then checkbox=checked. The same goes with insert and edit. If the user checks the checkbox i want to save field=H on the table. Any suggestions? Thank you in advance.

Dealy · Answer

TextBox temp_No = new TextBox(); temp_No.DataBindings.Add(Text binBindSource CHECK_NO); if (temp_No.Text == 1) check_no.CheckState = System.Windows.Forms.CheckState.Checked; else check_no.CheckState = System.Windows.Forms.CheckState.Unchecked; check_no is a checkbox. The problem is that I always get null as a result of temp_no. I do something similar when inserting/updating the record and i have no problem. It saves value 1 if the checkbox is checked and value 0 if it's not.

Kirtan Patel · Answer

Post your code from which you are trying to retrieve it please so that i can get better idea wht you exactly want to do please :)