How to insert a value in database using checkbox?

[kumardharanik]

Here i'm using two checkboxes with yes or no format.. When i check yes it should store '1' in the database and when i check no it should store '0' in the database..

[Curtis Rutland]

First of all, this would be much better suited to Radio Buttons, since they are mutually exclusive.

But you would use .Checked in either case to get true or false. Then you just do your normal insert into a database. The "bit" datatype is the best for storing a boolean value.

[kumardharanik]

Hi insertalias,

As i'm a newbie.. will yo pls explain me with codings..

[Rohit Garg]

Hi kumardharanik, if you are having two radio buttons "radioButtonYes" and "radiobuttonNo", a submit button "button1" and a sql database table named "test" in your database with just one coloumn having name "checked" and data type bit. then following code can help you storing the value of checked property of radio button on button clicking.

         SqlConnection con = new SqlConnection("Data    Source=(local);Integrated Security=True");
 
         SqlCommand cmd;
 
         cmd = new SqlCommand("insert into test (checked) values(@check)");
 
         cmd.Parameters.AddWithValue("@check", radioButtonYes.Checked);
 
         cmd.Connection = con;
 
 if(con.State == ConnectionState.Closed)
 {
     con.Open();
 }
 cmd.ExecuteNonQuery();