forum

Home / DeveloperSection / Forums / System.Data.SqlClient.SqlException occurred while using checked or radio button in form application

Ask Question

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

Samuel Fernandes 1755 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

c# c# 
Updated on 29-Oct-2016
Samuel Fernandes

Samuel Fernandes

Follow

Can you answer this question?

Answer

1 Answers

Abhishek Srivasatava

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.

Liked By