Established an Access database yourself, then use the SQL statement in ASP.NET, the statement is as follows:
MyConnection.open ();
Mycommand = new oledbcommand ("SELECT PWD from User" "Where id = '" user_name "'", myconnection);
OLEDBDATAREADER AREADER = mycommand.executereader ();
As such a simple line of code, an error, in an abnormal capture, saying that "FROM sub-sentence syntax error" occurs when connecting the database. The way the SELECT statement is definitely no problem. I want to think, I want to understand that User is the keyword. So hurry to change the name to user_info. Not just a table name, the column name in the table cannot use the keyword.
This is a lesson, and it will not make this low-level mistake after ensuring this. Ha ha.
