private void button1_Click(object sender, EventArgs e) { if (name_box.Text == "" || phone_box.Text == "" || email_box.Text == "" || pwd_box.Text == "") { MessageBox.Show("Cannot be left Empty"); return; } if (phone_box.TextLength != 11) { MessageBox.Show("Enter Valid Phone Number"); return; } if (pwd_box.TextLength < 5) { MessageBox.Show("Password length must be greater or equal than 5"); return; } try { SqlConnection con = new SqlConnection(ConnectionString.connectionString); con.Open(); // procedure for inserting new user SqlCommand cmd = new SqlCommand("SIGN_UP_PROC", con); SqlCommand cmd2 = new SqlCommand("SELECT USER_ID FROM USER_ WHERE NAME = @Name ", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@NAME", name_box.Text)); cmd.Parameters.Add(new SqlParameter("@PASS", pwd_box.Text)); cmd.Parameters.Add(new SqlParameter("@EMAIL", email_box.Text)); cmd.Parameters.Add(new SqlParameter("@TEL", phone_box.Text)); cmd.ExecuteNonQuery(); //get user_name cmd2.Parameters.Add(new SqlParameter("@Name", name_box.Text)); cmd2.ExecuteNonQuery(); //get user_id this.user_id = Convert.ToInt32(cmd2.ExecuteScalar()); con.Close(); AddAddress add_address = new AddAddress(this.user_id); add_address.ShowDialog(); this.Close(); this.Dispose(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }