Avoid using common words when creating a database.

You have created an Access database and used SQL statements 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 ();

 

Just a few simple lines of code, an error is reported, caught in the exception, that is, "From clause syntax error" occurs when connecting to the database ". There is certainly no problem in writing the SELECT statement. I want to know that the original user is a keyword. So I changed the table name to user_info. Not only the table name, but also the column name cannot use keywords.

 

This is a lesson, and I promise not to make such a low-level mistake in the future. Haha.