I am trying to send a new user on my C# program to the database (MSAccess in this case). I create the string as follows...
String StrCmd = String.Format("INSERT INTO tbl_Users (Username, Password, IsAdmin) VALUES ('{0}', '{1}', {2});", Username, passwordHash, AdminPower);
This creates an SQL string, for example...
INSERT INTO tbl_Users (Username, Password, IsAdmin)
VALUES ('TestUser', '1013638657', False);
This works fine if I paste it into a Query in MSAccess, but in the code I keep getting a Syntax error in INSERT INTO statement. error.
Can anyone see something obvious I am missing?
Additional Information:
Username and passwordHash are Strings, AdminPower is a Boolean.
Username and Password are Text Fields, IsAdmin is a Yes/No Field.
Code Block of interest...
OleDbConnection MyConn = new OleDbConnection(Program.ConnStr);
MyConn.Open();
String StrCmd = String.Format("INSERT INTO tbl_Users (Username, Password, IsAdmin) VALUES ('{0}', '{1}', {2});", Username, passwordHash, AdminPower);
OleDbCommand Cmd = new OleDbCommand(StrCmd, MyConn);
Cmd.ExecuteNonQuery();
MyConn.Close();
Aucun commentaire:
Enregistrer un commentaire