在前面已经声明了
string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\\UserData.mdb;";
myConn=new OleDbConnection(strConnection);
但执行到下面程序的**行时,老是报:FROM 语法错误,不知道哪里出的问题,高手们救命啊
string mySel = "SELECT count(*) as iCount from user where UserID='" + username + "'"; OleDbCommand myCmd1=new OleDbCommand(mySel,myConn);
myCmd1.Connection.Open();
OleDbDataReader Dr1;
Dr1 = myCmd1.ExecuteReader();********************************
Dr1.Read();
string Count = Dr1["iCount"].ToString();
Dr1.Close();
myCmd1.Connection.Close();
string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\\UserData.mdb;";
myConn=new OleDbConnection(strConnection);
但执行到下面程序的**行时,老是报:FROM 语法错误,不知道哪里出的问题,高手们救命啊
string mySel = "SELECT count(*) as iCount from user where UserID='" + username + "'"; OleDbCommand myCmd1=new OleDbCommand(mySel,myConn);
myCmd1.Connection.Open();
OleDbDataReader Dr1;
Dr1 = myCmd1.ExecuteReader();********************************
Dr1.Read();
string Count = Dr1["iCount"].ToString();
Dr1.Close();
myCmd1.Connection.Close();
关键字也可以用:
[user]
如:字段名为 John Mike,可用[John Mike]