title: changes to database fail to update - visual basic
body: <p>I am having a problem getting my scores from my blackjack game to update to the Scores table in my Scoreboard database. When I click save score it does add the current users name and score to the ScoresDataGridView as it should but when I close the application and check the database no changes are made. I havent been able to figure this out. any help would be great. thanks.  </p>
  
  <pre><code>Private Sub ButtonSaveScore_Click(sender As Object, e As EventArgs) Handles 
  ButtonSaveScore.Click
  
      ScoresBindingSource.MoveLast()
  
      Dim scoreRow As ScoreboardDataSet.ScoresRow
      scoreRow = Me.ScoreboardDataSet.Scores.NewScoresRow()
      scoreRow.UserName = LabelPlayerName.Text
      scoreRow.Score = LabelWinsCounter.Text
  
      Me.ScoreboardDataSet.Scores.Rows.Add(scoreRow)
  
      Me.ScoresTableAdapter.Update(Me.ScoreboardDataSet)
  
  
      Try
          Me.Validate()
          Me.ScoresBindingSource.EndEdit()
          Me.TableAdapterManager.UpdateAll(Me.ScoreboardDataSet)
          MsgBox("Update successful")
  
      Catch ex As Exception
          MsgBox("Update failed")
      End Try
  End Sub
  </code></pre>