• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 179
  • Last Modified:

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

0
moe57
Asked:
moe57
  • 3
  • 2
1 Solution
 
Peter HutchisonSenior Network Systems SpecialistCommented:
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.
0
 
moe57Author Commented:
thanks
0
 
moe57Author 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..
0
 
Peter HutchisonSenior Network Systems SpecialistCommented:
Change the line to:
checkNM.Checked = dtSETS_row.Field<bool>("Name");
0
 
moe57Author Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now