Question

c#向access中插入记录，inst.ExecuteNonQuery();语句出现了错误：至少一个参数没有被指定值。求大神赐教~

private void button1_Click(object sender, EventArgs e)
{
String strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Database5.mdb;";
OleDbConnection myconn = new OleDbConnection(strConn);
myconn.Open();
String strinsert = "INSERT INTO 表名(字段名) VALUES (textBox1.Text)";
OleDbCommand inst=new OleDbCommand(strinsert,myconn);
inst.ExecuteNonQuery();
myconn.Close();
}

Answer 1

你这样写的话，最后执行的语句是：INSERT INTO 表名(字段名) VALUES (textBox1.Text)

需要改成这样：

String strinsert = "INSERT INTO 表名(字段名) VALUES ('" + textBox1.Text + "')";