saving the data in sqlserver parameter error showing

[Syed Hadi]

I have an application with general customer detail.

It has TextBox and radio button.

First I have used if statement then code but on first step is working fine then error is showing. I'm not getting what I'm missing can any body guide me .......

 try
            {
                if (textBox1.Text == "")
                {
                    MessageBox.Show("Please Enter The First Name");
                    //textBox1.Focus();
                }
                else if (radioButton1.Checked == false && radioButton2.Checked == false)
                {
                    MessageBox.Show("Please Select  The Gender ");
                    //radioButton1.Focus();
                }
                else if (checkBox1.Checked == false && checkBox2.Checked == false)
                {
                    MessageBox.Show("Please Enter Your Phone Or Mobile Number");
                    //checkBox1.Focus();
                }
                else if (textBox6.Text == "")
                {
                    MessageBox.Show("Please Enter Your Email Id");
                    //textBox6.Focus();
                }
                else if (radioButton3.Checked == false && radioButton4.Checked == false && radioButton5.Checked == false && radioButton6.Checked == false)
                {
                    MessageBox.Show("Please Grade Us According To Our Service");
                    //radioButton3.Focus();
                }
 
            }
            catch (Exception ex)
            {
                //MessageBox.Show("Please Fill The Required Blanks");
 
            }
 
                con.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = con;
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandText = "insertpro";
                cmd.Parameters.AddWithValue("@firstname", textBox1.Text);
                cmd.Parameters.AddWithValue("@lastname", textBox2.Text);
                if (radioButton1.Checked == true)
                {
                    cmd.Parameters.AddWithValue("@gender", radioButton1.Text);
                }
                else if (radioButton2.Checked == true)
                {
                    cmd.Parameters.AddWithValue("@gender", radioButton2.Text);
                }
                //else if (radioButton1.Checked == false && radioButton2.Checked ==false )
                //{
                //    cmd.Parameters.AddWithValue("@gender","");
                //}
                cmd.Parameters.AddWithValue("@age", comboBox1.Text);
                cmd.Parameters.AddWithValue("@company", textBox3.Text);
                cmd.Parameters.AddWithValue("@profession", textBox10.Text);
                cmd.Parameters.AddWithValue("@adress", textBox7.Text);
                cmd.Parameters.AddWithValue("@city", textBox8.Text);
                cmd.Parameters.AddWithValue("@date", DateTime.Today.TimeOfDay);
 
 
                SqlCommand cmd1 = new SqlCommand();
                cmd1.Connection = con;
                cmd1.CommandType = CommandType.StoredProcedure;
                cmd1.CommandText = "insertfeed";
                cmd1.Parameters.AddWithValue("@contactnoph", textBox4.Text);
                cmd1.Parameters.AddWithValue("@emailadress", textBox6.Text);
                if (radioButton3.Checked == true)
                {
                    cmd1.Parameters.AddWithValue("@remark", radioButton3.Text);
                    cmd1.Parameters.AddWithValue("@remarkid", 0);
                }
                else if (radioButton4.Checked == true)
                {
                    cmd1.Parameters.AddWithValue("@remark", radioButton4.Text);
                    cmd1.Parameters.AddWithValue("@remarkid", 1);
                }
                else if (radioButton5.Checked == true)
                {
                    cmd1.Parameters.AddWithValue("@remark", radioButton5.Text);
                    cmd1.Parameters.AddWithValue("@remarkid", 2);
                }
                else if (radioButton6.Checked == true)
                {
                    cmd1.Parameters.AddWithValue("@remark", radioButton6.Text);
                    cmd1.Parameters.AddWithValue("@remarkid", 3);
                }
                else if (radioButton3.Checked == false && radioButton4.Checked == false && radioButton5.Checked == false && radioButton6.Checked == false)
                {
                    cmd1.Parameters.AddWithValue("@remark", "");
                    cmd1.Parameters.AddWithValue("@remarkid", "");
                }
                if (comboBox2.SelectedIndex == 1)
                {
                    cmd1.Parameters.AddWithValue("@sugession", textBox9.Text);
                    cmd1.Parameters.AddWithValue("@sugid", 1);
                }
                else if (comboBox2.SelectedIndex == 2)
                {
                    cmd1.Parameters.AddWithValue("@sugession", textBox9.Text);
                    cmd1.Parameters.AddWithValue("@sugid", 2);
                }
                else if (comboBox2.SelectedIndex == 0)
                {
                    cmd1.Parameters.AddWithValue("@sugession", textBox9.Text);
                    cmd1.Parameters.AddWithValue("@sugid", 0);
                }
                cmd1.Parameters.AddWithValue("@firstname", textBox1.Text);
                cmd1.Parameters.AddWithValue("@contactnomob", textBox5.Text);
                cmd.ExecuteNonQuery();
                cmd1.ExecuteNonQuery();
                con.Close();
                MessageBox.Show("Thanks For Your Feed Back.");
                textBox1.Text = "";
                textBox2.Text = "";
                textBox3.Text = "";
                textBox4.Text = "";
                textBox5.Text = "";
                textBox6.Text = "";
                textBox7.Text = "";
                textBox8.Text = "";
                textBox9.Text = "";
                textBox10.Text = "";
                comboBox1.SelectedIndex = 0;
                comboBox2.SelectedIndex = 0;
                radioButton1.Checked = false;
                radioButton2.Checked = false;
                radioButton3.Checked = false;
                radioButton4.Checked = false;
                radioButton5.Checked = false;
                radioButton6.Checked = false;
                checkBox1.Checked = false;
                checkBox2.Checked = false;
 
            }
 

[Rabbit]

I can not understand what you are asking at all.

[vijay6]

Hey Syed Hadi, where is the insert query in your code? (The insert query you wrote was wrong.)

You've to use like this...

SqlCommand myCommand = new SqlCommand("INSERT INTO TableName (Column1, Column2, ..., ColumnN) VALUES (@Param1, @Param2, ..., @ParamN)", myConnection);
myCommand.Parameters.AddWithValue("@Param1", variable1);
myCommand.Parameters.AddWithValue("@Param2", variable2);
...
myCommand.Parameters.AddWithValue("@ParamN", variableN);
myCommand.Open();
myCommand.ExecuteNonQuery();
myCommand.Close();

[Syed Hadi]

@vijay6 i m using procedure for inserting the values

[vijay6]

@vijay6 i m using procedure for inserting the values

Okay.

Hey Syed Hadi, the mistake i noticed from your code is, codes from line number 36 to line number 134 should be placed inside the else statement after line number 27 in your code.

[Syed Hadi]

Yeah I did that.
Its right.
Thanks.