If one of your tables contains a BLOG field, the general approach is as follows:
OleDbConnection conn = new OleDbConnection( .. );
OleDbCommand cmd = conn.CreateCommand();
OleDbParameter paString = new OleDbParameter( .. );
OleDbParameter paInt = new OleDbParameter( .. );
OleDbParameter paBLOB = new OleDbParameter( .. );
// Currently there are two options
cmd.CommandText = INSERT INTO TableName( ?, ?, ? );
cmd.CommandText = INSERT TabName( ?, ?, ? );
When setting up a SQL statement, the latter has one less INTO keyword than the former. We all know that this keyword can be omitted. Which setting method will you choose here?
Choose the former: the program is correct.
Choose the latter: program exception --> syntax error in the INSERT INTO statement.
// Reason: Maybe the standard support is not good, I haven’t checked yet.