Link to home
Start Free TrialLog in
Avatar of moe57
moe57

asked on

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

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

ASKER CERTIFIED SOLUTION
Avatar of Peter Hutchison
Peter Hutchison
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of moe57
moe57

ASKER

thanks
Avatar of moe57

ASKER

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..
Change the line to:
checkNM.Checked = dtSETS_row.Field<bool>("Name");
Avatar of moe57

ASKER

thanks