i have created a regestration page in that there is name,username,password,date of birth,Gender.
when i'm clicking on save button data is saved successfully in the database but in the Gender field insted of Male or Female it is coming 1.
please help me with perfect code.
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 :