We help IT Professionals succeed at work.

how to get the selected value of check-box in asp.net

moe57
moe57 asked
on
I am trying to get the selected value of the check-box but it is always showing zero in the back-end table even when i select the check-box. The data type for the check-box is bit. I am not sure what am i doing wrong here.
 using (SqlConnection con = new SqlConnection(strConnString))
            {
                using (SqlCommand cmd = new SqlCommand(@"insert into myTable(UserID, Name) values( @UserID, @Name)"))                                                                                            

                {
                    using (SqlDataAdapter sda = new SqlDataAdapter())
                    {
                        cmd.CommandType = CommandType.Text;
                        cmd.Parameters.AddWithValue("@UserID", tempUser.ToString());

                        cmd.Parameters.AddWithValue("@Name", chckNM.Checked);

                        cmd.Connection = con;
                        con.Open();
                        cmd.ExecuteNonQuery();

                    }

Open in new window

here is the checkbox
<asp:CheckBox ID="chckNM" runat="server" />

Open in new window

Comment
Watch Question

Senior Network Systems Specialist
Commented:
Try this code:
if (chck.Checked )
   cmd.Parameters.AddWithValue("@Name", True);
else
   cmd.Parameters.AddWithValue("@Name", False);

Assuming the @Name field is a Boolean value or integer value. If its a text value then change the values to "True" and "False"
with the quotes.

Author

Commented:
thanks

Author

Commented:
sorry even though i closed the question but i hope you could help me.  I want to retrieve the data and this is the syntax i am want to use but it is not quite right yet
checkNM.value = dtSETS_row.Field<bool>("Name");

Open in new window

when the page loads, i want the checkbox to show whatever value in the database but the chckNM.value is not working for me..
Peter HutchisonSenior Network Systems Specialist

Commented:
Change the line to:
checkNM.Checked = dtSETS_row.Field<bool>("Name");

Author

Commented:
thanks