string myConnstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Dource=c:/project/App/database.mdb"; //data.mdb是你的数据库名称
OleDbConnection MyConnection;
MyConnection = new OleDbConnection(myConnstring);
MyConnection.Open();
string strinsert = "select name from user";
OleDbCommand MyCommand = new OleDbCommand(strinsert , MyConnection);
MyCommand.ExecuteReader();总是出现from 子句语法错误;不知道为什么?我是个初学者,请帮忙,谢谢了.
OleDbConnection MyConnection;
MyConnection = new OleDbConnection(myConnstring);
MyConnection.Open();
string strinsert = "select name from user";
OleDbCommand MyCommand = new OleDbCommand(strinsert , MyConnection);
MyCommand.ExecuteReader();总是出现from 子句语法错误;不知道为什么?我是个初学者,请帮忙,谢谢了.
变成string strinsert = "select name from [user]";
看看
要用[]括起来