Forum Moderators: open
protected void SubmitDetails(object sender, EventArgs e)
{
SqlConnection objConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
SqlCommand objCmd = new SqlCommand("INSERT INTO Member_Information (Name, Address_Line_1, Address_Line_2, Address_Line_3, Contact_Number, "
+ "Name_Of_Bank, Account_Number, Sort_Code, Bank_Address_Line_1, Bank_Address_Line_2, Bank_Address_Line_3) "
+ "VALUES (@Name, @Address_Line_1, @Address_Line_2, @Address_Line_3, @Contact_Number, "
+ "@Name_Of_Bank, @Account_Number, @Sort_Code, @Bank_Address_Line_1, @Bank_Address_Line_2, @Bank_Address_Line_3)", objConn);
objCmd.Parameters.AddWithValue("@Name", txtName.Text);
objCmd.Parameters.AddWithValue("@Address_Line_1", txtAL1.Text);
objCmd.Parameters.AddWithValue("@Address_Line_2", txtAL2.Text);
objCmd.Parameters.AddWithValue("@Address_Line_3", txtAL3.Text);
objCmd.Parameters.AddWithValue("@Contact_Number", txtContact.Text);
objCmd.Parameters.AddWithValue("@Name_Of_Bank", txtBank.Text);
objCmd.Parameters.AddWithValue("@Account_Number", txtAN.Text);
objCmd.Parameters.AddWithValue("@Sort_Code", txtSort.Text);
objCmd.Parameters.AddWithValue("@Bank_Address_Line_1", txtBA1.Text);
objCmd.Parameters.AddWithValue("@Bank_Address_Line_2", txtBA2.Text);
objCmd.Parameters.AddWithValue("@Bank_Address_Line_3", txtBA3.Text);
objConn.Open();
objCmd.ExecuteNonQuery();
objConn.Close();
}