private void button1_Click(object sender, EventArgs e)
{
try
{
SqlConnection cn = new SqlConnection("Add your connection String");
SqlCommand cmd = new SqlCommand("insert into RegistrationDetails @id,@Name,@Address,@City,@Pincode,@Mobileno,@Password,@ConfirmPassword");
cmd.Parameters.AddWithValue("Id", txtid.Text);
cmd.Parameters.AddWithValue("Name", txtname.Text);
cmd.Parameters.AddWithValue("Address", txtaddress.Text);
cmd.Parameters.AddWithValue("City", txtcity.Text);
cmd.Parameters.AddWithValue("Pincode", txtpincode.Text);
cmd.Parameters.AddWithValue("Mobileno", txtmobileno.Text);
cmd.Parameters.AddWithValue("Password", txtpassword.Text);
cmd.Parameters.AddWithValue("Confirmpassword", txtconfirmpassword.Text);
if (txtpassword.Text == "" || txtconfirmpassword.Text == "" || txtid.Text == "" || txtmobileno.Text == "" || txtname.Text == "" || txtpincode.Text == "" || txtcity.Text == "")
{
label10.Show();
}
if (txtconfirmpassword.Text != txtpassword.Text)
{
MessageBox.Show("Confirm Password Not Matching With Password");
txtconfirmpassword.Focus();
cmd.ExecuteNonQuery();
cn.Close();
}
else if (txtpassword.Text == "" || txtconfirmpassword.Text == "" || txtid.Text == "" || txtmobileno.Text == "" || txtname.Text == "" || txtpincode.Text == "" || txtcity.Text == "")
{
this.Show();
MessageBox.Show("Please Fill All Fields");
new Form1().Hide();
}
else
{
MessageBox.Show("Registered Successfully");
this.Hide();
new Form1().Show();
}
}
catch (Exception )
{
}
}
コメント