saving the data in sqlserver parameter error showing

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Syed Hadi
    New Member
    • Dec 2012
    • 56

    saving the data in sqlserver parameter error showing

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

    Code:
     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;
    
                }
    Last edited by Frinavale; Jun 12 '13, 06:38 PM. Reason: Grammar and spelling
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    I can not understand what you are asking at all.

    Comment

    • vijay6
      New Member
      • Mar 2010
      • 158

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

      You've to use like this...
      Code:
      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();

      Comment

      • Syed Hadi
        New Member
        • Dec 2012
        • 56

        #4
        @vijay6 i m using procedure for inserting the values

        Comment

        • vijay6
          New Member
          • Mar 2010
          • 158

          #5
          @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.

          Comment

          • Syed Hadi
            New Member
            • Dec 2012
            • 56

            #6
            Yeah I did that.
            Its right.
            Thanks.
            Last edited by Frinavale; Jun 12 '13, 06:38 PM.

            Comment

            Working...