Advertisement
Guest User

Untitled

a guest
Jan 12th, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.22 KB | None | 0 0
  1. OleDbConnection conn = new OleDbConnection();
  2. conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\kenny\Documents\Visual Studio 2010\Projects\Copy Cegees\Cegees\Cegees\Login.accdb";
  3.  
  4. String Username = TEXTNewUser.Text;
  5. String Password = TEXTNewPass.Text;
  6.  
  7. OleDbCommand cmd = new OleDbCommand("INSERT into Login (Username, Password) Values(@Username, @Password)");
  8. cmd.Connection = conn;
  9.  
  10. conn.Open();
  11.  
  12. if (conn.State == ConnectionState.Open)
  13. {
  14. cmd.Parameters.Add("@Username", OleDbType.VarChar).Value = Username;
  15. cmd.Parameters.Add("@Password", OleDbType.VarChar).Value = Password;
  16.  
  17. try
  18. {
  19. cmd.ExecuteNonQuery();
  20. MessageBox.Show("Data Added");
  21. conn.Close();
  22. }
  23. catch (OleDbException ex)
  24. {
  25. MessageBox.Show(ex.Source);
  26. conn.Close();
  27. }
  28. }
  29. else
  30. {
  31. MessageBox.Show("Connection Failed");
  32. }
  33. }
  34. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement