各位高手,我用c# access2003数据库测试下面的代码,总是提示
语法错误。我弄不明白,请高人指点
string strConn = Utility.GetDatabaseConnectionString() ;
OleDbConnection myConn = new OleDbConnection (strConn) ;
string strInsert ="insert into arryData (bh,month) values ('hidjklmn','2009')";
OleDbCommand inst = new OleDbCommand(strInsert,myConn) ;
myConn.Open();
inst.ExecuteNonQuery( ) ;
myConn.Close ( ) ;
}
语法错误。我弄不明白,请高人指点
string strConn = Utility.GetDatabaseConnectionString() ;
OleDbConnection myConn = new OleDbConnection (strConn) ;
string strInsert ="insert into arryData (bh,month) values ('hidjklmn','2009')";
OleDbCommand inst = new OleDbCommand(strInsert,myConn) ;
myConn.Open();
inst.ExecuteNonQuery( ) ;
myConn.Close ( ) ;
}
string strInsert ="insert into arryData (bh) values ('hidjklmn')"这样就可以,为什么增加一个字段就不行呢,请各位指教。