Data in not displayed on checkbox in c#.net sqlserver

Kobinath Ram

I am trying to display the values from database. The textbox values are displayed successfully but checkbox values are not displayed, and it shows the error. i attached the error on screenshot image below

sql = "select * from repair where repairid = '" + repairid + "'";
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader dread;
con.Open();
dread = cmd.ExecuteReader();
while (dread.Read())
{
checkBox7.CheckState = dread[6].ToString();
}

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rupesh Kahane7y ago
In while loop do some modifications for property Checked , is an boolean value so make it as true / false
CheckBox.Checked= true
will work fine
0
Jignesh Kumar7y ago
Hi,

Please find below link,
https://www.aspforums.net/Threads/799562/Populate-and-Update-CheckBoxList-value-from-database-using-C-in-ASPNet/
0
Amit Kumar7y ago
Hi,
You have to set CheckBox.Checked property not CheckState property.
CheckBox.CheckState proeperty check that it is checked or not that's only.

Set the property like this
CheckBox.Checked= true
          or
CheckBox.Checked= false
For more detail gothrough below reference

https://www.c-sharpcorner.com/UploadFile/mahesh/checkbox-in-C-Sharp3/

Thanks,
-1
Praveen Maurya7y ago
what exactly you want.. do you want database value to write on checkbox or do you want status to be update on checkbox
0
Kobinath Ram7y ago
no it is not working if i use checkbox1.text can you write the code for me
0
Praveen Maurya7y ago
in this case you can use checkbox.text hotel it will work for you to get the checkbook value
0