Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Select an option

  • Save xSystemIOx/31a9bfde5b7fd4a08740ec0beffc1c28 to your computer and use it in GitHub Desktop.

Select an option

Save xSystemIOx/31a9bfde5b7fd4a08740ec0beffc1c28 to your computer and use it in GitHub Desktop.
Private Sub LoadHighScore()
Dim connection As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Path")
Dim command As New OleDbCommand("SELECT [HighScore] From [Log_in_Info] WHERE [Username] = @Username", connection) 'SQL Statement to update record in database
Dim usernameparam As New OleDbParameter("@Username", Loginpage.usernametxtbox.Text) 'username parameter
Dim Score As New OleDbParameter("@HighScore", playerhighscore) 'password parameter
command.Parameters.Add(usernameparam) 'command parameter
command.Parameters.Add(Score) 'command parameter
connection.Open() 'Opens connection to database
playerhighscore = command.ExecuteNonQuery() 'Executes SQL Statement
connection.Close() 'Closes connection to database
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment