Advertisement
Guest User

Untitled

a guest
Jun 6th, 2016
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.15 KB | None | 0 0
  1. if (!txtUsername.Equals(null) && !txtPassword.Equals(null))
  2. {
  3. string constring = @"Provider = Microsoft.ACE.OLEDB.12.0; Data Source = " + System.Environment.CurrentDirectory + "../../../res/Coursework.accdb";
  4.  
  5. String username = txtUsername.Text;
  6. String password = txtPassword.Text;
  7. Boolean admin = chbAdmin.Checked;
  8.  
  9. string cmdText = "insert into tblUsers (username, password, admin) Values(@username, @password, @admin)";
  10. using (OleDbConnection con = new OleDbConnection(constring))
  11. using (OleDbCommand cmd = new OleDbCommand(cmdText, con))
  12. {
  13. con.Open();
  14. cmd.Parameters.Add("@username", OleDbType.VarChar).Value = username;
  15. cmd.Parameters.Add("@password", OleDbType.VarChar).Value = password;
  16. cmd.Parameters.Add("@admin", OleDbType.Boolean).Value = admin;
  17.  
  18. cmd.ExecuteNonQuery(); //crashing here with syntax error in the insert statement
  19. MessageBox.Show("Data Added");
  20. }
  21. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement