vb Code:
  1. If txtName.Text = "" Then
  2.             MsgBox("You need to fill out your name")
  3.             Exit Sub
  4.         End If
  5.         Try
  6.             ''This code is doing my head in''
  7.             Dim objRow As DataRow
  8.             Dim tableName As String = "highScore"
  9.             Dim objDataSet As New DataSet
  10.             dbConnection = New OleDb.OleDbConnection(ConnectionString)
  11.  
  12.             dbAdapter = New OleDb.OleDbDataAdapter("SELECT * FROM " & tableName & "", ConnectionString)
  13.             Dim NewCommand = New OleDb.OleDbCommandBuilder(dbAdapter)
  14.             dbAdapter.FillSchema(objDataSet, SchemaType.Source, tableName)
  15.             dbAdapter.Fill(objDataSet, tableName)
  16.             objRow = objDataSet.Tables(tableName).Rows.Add
  17.             Dim rowNum = objDataSet.Tables(tableName).Rows.Count
  18.             objRow = objDataSet.Tables(tableName).Rows.Find(rowNum)
  19.  
  20.             objRow.Item(0) = rowNum
  21.             objRow.Item(1) = txtName.Text
  22.             objRow.Item(2) = myTotalScore
  23.             dbAdapter.Update(objDataSet, tableName)
  24.         Catch ex As Exception
  25.             MsgBox(ex.Message)
  26.         End Try

Ok this works and anyway thanks for the helps folks