. Net statement syntax error caused by the keyword connecting to the Access Database

If the table design of your database contains the keywords (commonly used system, Master, admin, user, useres, userid, and money) contained in access ), when an update is inserted, a "syntax error" occurs"
For example:
String sqltext = string. Format ("insert into testtable (ID, order) values ({0 },{ 1})", 123,0 );
The preceding statement in this line fails because the "order" keyword exists in the testtable table. solution:
(1). Use [order] to process the keywords in the statement. For example:
String sqltext = string. Format ("insert into testtable (testid, [order]) values ({0 },{ 1})", 123,0 );
(2). enclose all fields in [], or add the table name in front of it.CodeThis method is used in the generator to solve the keyword conflict problem. For example:
String sqltext = string. Format ("insert into testtable ([ID], [order]) values ({0 },{ 1})", 123,0 );
(3) avoid using the reserved words of access when designing the database. In this way, there will be no errors caused by keyword issues, which is also the best solution.