Advertisement
Ang377ou

insert using sql

May 25th, 2015
233
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.48 KB | None | 0 0
  1. namespace WindowsFormsApplication1
  2. {
  3. public partial class FormNewUser : Form
  4. {
  5. public FormNewUser()
  6. {
  7. InitializeComponent();
  8. }
  9.  
  10. private void BTNSave_Click(object sender, EventArgs e)
  11. {
  12. OleDbConnection conn = new OleDbConnection();
  13. conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\kenny\Documents\Visual Studio 2010\Projects\Copy Cegees\Cegees\Cegees\Login.accdb";
  14.  
  15. String Username = TEXTNewUser.Text;
  16. String Password = TEXTNewPass.Text;
  17.  
  18. OleDbCommand cmd = new OleDbCommand("INSERT into Login (Username, Password) Values(@Username, @Password)");
  19. cmd.Connection = conn;
  20.  
  21. conn.Open();
  22.  
  23. if (conn.State == ConnectionState.Open)
  24. {
  25. cmd.Parameters.Add("@Username", OleDbType.VarChar).Value = Username;
  26. cmd.Parameters.Add("@Password", OleDbType.VarChar).Value = Password;
  27.  
  28. try
  29. {
  30. cmd.ExecuteNonQuery();
  31. MessageBox.Show("Data Added");
  32. conn.Close();
  33. }
  34. catch (OleDbException ex)
  35. {
  36. MessageBox.Show(ex.Source);
  37. conn.Close();
  38. }
  39. }
  40. else
  41. {
  42. MessageBox.Show("Connection Failed");
  43. }
  44. }
  45. }
  46. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement