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 .......
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; }
Comment