这个问题让我疯掉!用oledbcommand执行一个插入一条记录的程序,到现在也没有解决!
数据库结构:
总是报错,insert语句有错误,查了很多资料都没搞定!郁闷!郁闷!
String Str="INSERT INTO DataHis(时间,开盘价,最高价,最低价,收盘价) VALUES('98-02-12',4,34,45,56)" ;
//String Str="select * from DataHis";
string strConn = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = SocketDataHis.mdb " ;
OleDbConnection myConn = new OleDbConnection (strConn ) ;
myConn.Open ( ) ;
OleDbCommand inst = new OleDbCommand (Str,myConn ) ;
inst.ExecuteNonQuery ( ) ;
myConn.Close ( ) ;
MessageBox.Show("ok");
//String Str="select * from DataHis";
string strConn = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = SocketDataHis.mdb " ;
OleDbConnection myConn = new OleDbConnection (strConn ) ;
myConn.Open ( ) ;
OleDbCommand inst = new OleDbCommand (Str,myConn ) ;
inst.ExecuteNonQuery ( ) ;
myConn.Close ( ) ;
MessageBox.Show("ok");