Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- OleDbConnection conn = new OleDbConnection();
- conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\kenny\Documents\Visual Studio 2010\Projects\Copy Cegees\Cegees\Cegees\Login.accdb";
- String Username = TEXTNewUser.Text;
- String Password = TEXTNewPass.Text;
- OleDbCommand cmd = new OleDbCommand("INSERT into Login (Username, Password) Values(@Username, @Password)");
- cmd.Connection = conn;
- conn.Open();
- if (conn.State == ConnectionState.Open)
- {
- cmd.Parameters.Add("@Username", OleDbType.VarChar).Value = Username;
- cmd.Parameters.Add("@Password", OleDbType.VarChar).Value = Password;
- try
- {
- cmd.ExecuteNonQuery();
- MessageBox.Show("Data Added");
- conn.Close();
- }
- catch (OleDbException ex)
- {
- MessageBox.Show(ex.Source);
- conn.Close();
- }
- }
- else
- {
- MessageBox.Show("Connection Failed");
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement