Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

System.Data.SqlClient.SqlException occurred while using checked or radio button in form application

Samuel Fernandes 2147 29 Oct 2016

Hi Buddy

System.Data.SqlClient.SqlException occurred while using checked or radio button in form application

                if (checkBox1.Checked == true)
                {
                    savecom.Parameters.AddWithValue("@Subject_Maths", "Selected ");
                }

	if (radioButton1.Checked == true)
                {
                    savecom.Parameters.AddWithValue("@Sex", "Male");
                }
                else
                {
                    savecom.Parameters.AddWithValue("@Sex", "Female");
                }

Please help me.I would really appreciate your help

Thanks

Samuel Fernandes

Other

1 Answers

Abhishek Srivasatava 29 Oct 2016

Hi Samuel,

This error occured because data is not passed to SQL parameter.

You can used this code

if (radioButton1.Checked == true || radioButton2.Checked == true)
            {
                if (radioButton1.Checked == true)
                {
                    savecom.Parameters.AddWithValue("@Sex", "Male");
                }
                else
                {
                    savecom.Parameters.AddWithValue("@Sex", "Female");
                }
            }
else
          {
                savecom.Parameters.AddWithValue("@Sex", null);
           }

Similarly used else case for checked box.

MindStick Training