Hi i basically am creating a registration page. I am getting an error saying "Syntax error in INSERT INTO statement." Also sometimes am getting an Error saying that the connection is open or something. It was working before in a different table and different fields etc...The code is as follows\[code\]public partial class Registration : System.Web.UI.Page{ static OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\New folder\Project 1.0\WebSite1\New Microsoft Office Access 2007 Database.accdb"); OleDbDataAdapter ada = new OleDbDataAdapter(); OleDbCommand cmd = new OleDbCommand(); OleDbDataReader dr;protected void Page_Load(object sender, EventArgs e){}protected void Button1_Click(object sender, EventArgs e){ string str = "insert into User_Registeration (First_Name, Last_name, Phone_No, Username, Password, Email, Address, City, Country, Zipcode)" + "values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; con.Open(); cmd = new OleDbCommand(str, con); cmd.Parameters.AddWithValue("@p1", TextBox1.Text); cmd.Parameters.AddWithValue("@p2", TextBox2.Text); cmd.Parameters.AddWithValue("@p3", TextBox3.Text); cmd.Parameters.AddWithValue("@p4", TextBox4.Text); cmd.Parameters.AddWithValue("@p5", TextBox5.Text); cmd.Parameters.AddWithValue("@p6", TextBox6.Text); cmd.Parameters.AddWithValue("@p7", TextBox8.Text); cmd.Parameters.AddWithValue("@p8", TextBox12.Text); cmd.Parameters.AddWithValue("@p9", TextBox9.Text); cmd.Parameters.AddWithValue("@p10", TextBox11.Text); cmd.ExecuteNonQuery(); con.Close();}\[/code\]}And my mc access table has the following structure... ID First_Name Last_name Phone_No Username Password Email Address City Country ZipcodeCan someone please help me? 
Thank you
Thank you