Updating a database

[blazinjoe1]

Hey guys i was wondering if you could help me update a database,

I have connected a access database to a MS Chart tool which creates a bar graph (that works). What i want to do is say whatever is in this array element or screen element to equal that row in the database.

Here is the code which i haev currently generated

Public strPlayersNames(16) As String [In a module]
Public nudTotalMeters(16) As Integer [In a module]
Public con As New OleDb.OleDbConnection("Provider = Microsoft.Jet.OleDB.4.0;Data Source = rl.mdb;") [In a module]
Imports System.Data
Imports System.IO
Imports System.Data.OleDb

Dim adp As New OleDbDataAdapter("select *from playermeters", con)

Dim ds As New DataSet
adp.Fill(ds)
Dim dt As DataTable
dt = ds.Tables(0)

dt.Rows(0).Item(0) = strPlayersNames(0)
dt.Rows(0).Item(1) = nudTotalMeters(0)

dt.Rows(1).Item(0) = strPlayersNames(1)
dt.Rows(1).Item(1) = nudTotalMeters(1)

dt.Rows(2).Item(0) = strPlayersNames(2)
dt.Rows(2).Item(1) = nudTotalMeters(2)

(and it goes on)

Thankyou

[blazinjoe1]

can anyone help me please?

[kenobewan]

Please define "whatever is in this array element or screen element to equal that row in the database." Thanks

[blazinjoe1]

Please define "whatever is in this array element or screen element to equal that row in the database." Thanks

dt.Rows(0).Item(0) = strPlayersNames(0) thats what i mean. But its not updating at all could you please help me

[kenobewan]

Please paste more of your code so that we may see what is going on. Thanks.

[blazinjoe1]

Please paste more of your code so that we may see what is going on. Thanks.

Okay so ive updated the code . I 100% know that the database is connected becuase when i call a row into a text box it displays whatevers in that row into the text box. But the problem which i am having is when i click on button1 to update the database this error message comes up "Object reference not set to an instance of an object".

Public Class frmNewGameStatistics
Dim con As New OleDb.OleDbConnection("Provider = Microsoft.Jet.OleDB.4.0;Data Source = rl.mdb;")
Dim ds As New DataSet
Dim adp As New OleDb.OleDbDataAdapter '("select *from playermeters", con)
Dim sql As String
Dim dt As DataTable
Dim cb As New OleDb.OleDbCommandBuilder(adp)
Dim dsNewRow As DataRow


Private Sub frmNewGameStatistics_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
con.Open()
sql = "select *from playermeters"
adp = New OleDb.OleDbDataAdapter(sql, con)
adp.Fill(ds, "playermeters")
dt = ds.Tables(0)
con.Close()

End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

dsNewRow = ds.Tables("playersmeters").NewRow()
dsNewRow.Item("Player Name") = TextBox1.Text
ds.Tables("playersmeters").Rows.Add(dsNewRow)
adp.Update(ds, "playermeters")

End Sub

[blazinjoe1]

does anyone know what the problem is?