关于C#中ExecuteNonQuery()的问题
我是新手,问题代码如下:
private void button1_Click(object sender, EventArgs e)
{
string connstr = @"Provider = Microsoft.Jet.OLEDB.4.0; Data Source = C:\Users\z\Desktop\date1.mdb";
OleDbConnection conn = new OleDbConnection(connstr);
conn.Open();
OleDbCommand command = conn.CreateCommand();
command.CommandText = "insert into 表1(姓名,学号,数学,语文,英语,总分) values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "','" + textBox6.Text + "')";
command.ExecuteNonQuery();
conn.Close();
}
编译没问题,运行的时候说我的ExecuteNonQuery();存在语法错误,跪求高人指点。