Question

ASP.NET对ACCESS数据库进行操作，报from子句语法错误

string myConnectionString = System.Configuration.ConfigurationManager.AppSettings["ConnString"].ToString() + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dbPath"]) + ";";

string mySelectQuery = "select * from user";//查询语句

OleDbConnection myConnection = new OleDbConnection(myConnectionString);

OleDbCommand myCommand = new OleDbCommand(mySelectQuery, myConnection);

myConnection.Open();

OleDbDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);

while (myReader.Read())
{
Console.WriteLine(myReader.GetString(0));
//GetString(0,1,2....)
}
myReader.Close();
我开始还真的以为是什么SQL语句错了，所以改成这个简单的查询

Answer 1

user是asp/asp.net保留关键词

你要用这个词作表名的话必须写成[user]才行

不然的话要出错

Answer 2

一般user在数据库中都是关键字,建议你将表明多个s什么的