Forum Moderators: open

Message Too Old, No Replies

wont enter data

         

Timmyc21

5:07 pm on Feb 14, 2008 (gmt 0)

10+ Year Member



Hi,
I'm doing a project in Visual Studio in asp.net, C# and a SQL Server DB. I'm currently trying to write to my database but im encountering problems. I'm receiving no errors but the data still isn't being entered to the database. The code is shown below..........any ideas would be greatly appreciated!

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();
}