这个SQL语句在Access通过,怎么在c#报语法错误?
语句如下:
string strSql = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Test.mdb";
string sql = "Insert Into Name(Name,Password) values('zhang','1234')";
OleDbConnection oleDBConn;
OleDbCommand oleDBComm;
oleDBConn= new OleDbConnection (strSql);
oleDBConn.Open ();
oleDBComm = new OleDbCommand (sql, oleDBConn);
oleDBComm.ExecuteNonQuery ();
oleDBConn.Close ();
Insert Into Name(Name,Password) values('zhang','1234')在Access2003可以正确执行,但是在C#中执行到oleDBComm.ExecuteNonQuery ();这句时就报Insert Into 语法错误,实在搞不懂了?请各位大侠指点一下。