Advertisement
Guest User

Untitled

a guest
Jun 26th, 2019
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.38 KB | None | 0 0
  1. Using conn = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & _
  2. "C:UserslenovoDesktopVB SystemsPOS simpleSP1SPoS1 Database.accdb" & _
  3. ";Jet OLEDB:Database Password=admin1234")
  4. Using cmd = New OleDbCommand()
  5.  
  6. conn.Open()
  7. cmd.Connection = conn
  8. cmd.CommandText = "UPDATE Employees SET [Employee ID]=@ID, [First Name]=@Fname, [Last Name]=@Lname," & _
  9. "[Date of Birth]=@DoB, [Age]=@Age, [Password]=@Pass WHERE [Employeee ID]=" & frmAdminMain.IDtoUpdate
  10.  
  11.  
  12. cmd.Parameters.Clear()
  13. cmd.Parameters.AddWithValue("@ID", txtID.Text)
  14. cmd.Parameters.AddWithValue("@Fname", txtFname.Text)
  15. cmd.Parameters.AddWithValue("@Lname", txtLname.Text)
  16. cmd.Parameters.AddWithValue("@Dob", DateTime.Parse(Format(dtpDoB.Value, "MM/dd/yyyy")))
  17. cmd.Parameters.AddWithValue("@Age", GetCurrentAge(dtpDoB.Value))
  18. cmd.Parameters.AddWithValue("@Pass", txtPass.Text)
  19.  
  20.  
  21. Try
  22. cmd.ExecuteNonQuery()
  23. conn.Close()
  24. txtID.Clear()
  25. txtFname.Clear()
  26. txtLname.Clear()
  27. txtPass.Clear()
  28. MsgBox("Record added successfully", MsgBoxStyle.OkOnly Or MsgBoxStyle.Information, "Success")
  29. Catch ex As Exception
  30. MsgBox(ex.ToString, MsgBoxStyle.OkOnly Or MsgBoxStyle.Exclamation, "Error")
  31. End Try
  32.  
  33. End Using
  34. End Using
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement