Gender Selection

private void button1_Click(object sender, EventArgs e)

{

if (textBox1.Text != "" && textBox2.Text != "" && textBox3.Text != "" && comboBox2.Text != ""

&& textBox5.Text != "" && textBox6.Text != "" && textBox7.Text != "" && textBox8.Text != ""

&& textBox9.Text != "" && comboBox1.Text != "" && comboBox3.Text != ""

&& textBox13.Text != "" && textBox14.Text != "" && textBox15.Text != "" && textBox16.Text != ""

&& textBox17.Text != "" && comboBox4.Text != "" && dateTimePicker1.Text != ""

&& dateTimePicker2.Text != "")

{

cmd = new SqlCommand("insert into Empandadmin(Role,EmpId,Name,DOB,Gender,DOJ,Desgination,Username,Password,PanNo,BankName,AccountNo,City,State,Zip,Email,Mobile,Alternetno,Experiance,Createdby)Values(@Role,@EmpId,@Name,@DOB,@Gender,@DOJ,@Desgination,@Username,@Password,@PanNo,@BankName,@AccountNo,@City,@State,@Zip,@Email,@Mobile,@Alternetno,@Experiance,@Createdby)",con);

cmd.Parameters.AddWithValue("@Role" ,textBox1.Text);

cmd.Parameters.AddWithValue("@EmpId", textBox2.Text);

cmd.Parameters.AddWithValue("@Name", textBox3.Text);

cmd.Parameters.AddWithValue("@DOB", dateTimePicker1.Value);

cmd.Parameters.AddWithValue("@Gender", radioButton1.Checked);

//cmd.Parameters.AddWithValue("@Gender", checkBox2.Checked);

cmd.Parameters.AddWithValue("@DOJ", dateTimePicker2.Value);

cmd.Parameters.AddWithValue("@Desgination", comboBox1.Text);

cmd.Parameters.AddWithValue("@Username", textBox5.Text);

cmd.Parameters.AddWithValue("@Password", textBox6.Text);

cmd.Parameters.AddWithValue("@PanNo", textBox7.Text);

cmd.Parameters.AddWithValue("@BankName", textBox8.Text);

cmd.Parameters.AddWithValue("@AccountNo", textBox9.Text);

//cmd.Parameters.AddWithValue("@Address", textBox10.Text);

cmd.Parameters.AddWithValue("@City", comboBox3.Text);

cmd.Parameters.AddWithValue("@State", comboBox2.Text);

cmd.Parameters.AddWithValue("@Zip", textBox13.Text);

cmd.Parameters.AddWithValue("@Email", textBox14.Text);

cmd.Parameters.AddWithValue("@Mobile", textBox15.Text);

cmd.Parameters.AddWithValue("@Alternetno", textBox16.Text);

cmd.Parameters.AddWithValue("@Experiance", textBox17.Text);

cmd.Parameters.AddWithValue("@Createdby", comboBox4.Text);

con.Open();

cmd.ExecuteNonQuery();

con.Close();

MessageBox.Show("Employee added Successfully");

}

}

 

Database Output :