Hjælp til syntaksfejl
hejKan i hjælpe med denne simple fejl: Incorrect syntax near ')'.
Her er koden:
SqlDataSource name = new SqlDataSource();
name.ConnectionString = ConfigurationManager.ConnectionStrings["DatabaseConnectionString"].ConnectionString;
name.InsertCommand = "INSERT INTO [A] (A1, A2, A3, A4, A5)";
name.InsertParameters.Add("A1", TypeCode.String, TextBox1.Text);
name.InsertParameters.Add("A2", TypeCode.String, TextBox2.Text);
name.InsertParameters.Add("A3", TypeCode.String, TextBox3.Text);
name.InsertParameters.Add("A4", TypeCode.String, TextBox4.Text);
name.InsertParameters.Add("A5", TypeCode.Boolean, CheckBox1.Checked.ToString());
name.InsertCommandType = SqlDataSourceCommandType.Text;
name.Insert();