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 2288 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

Ask by Samuel Fernandes

Updated 29 Oct 2016

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

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.