Vb 10 nullreference exception

Question

i got this code from the net , but i can't make this code work on the system i am programming so, i used the same codes to another system and it worked, when i tried using it to my system, it failed, so i started a new program and it still fails... what is wrong with my program? here is a sample of the code:

Public Class Form2
Dim con As New OleDb.OleDbConnection
Dim dbProvider As String
Dim dbSource As String
Dim ds As New DataSet
Dim da As OleDb.OleDbDataAdapter
Dim sql As String
Dim inc As Integer
Dim max As Integer


Private Sub AllRecordsToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)

dbProvider = "PROVIDER = Microsoft.Jet.OLEDB.4.0;"
    dbSource = "Data Source = C:\Users\Josh\Documents\enrollment.mdb"

    con.ConnectionString = dbProvider & dbSource

    con.Open()

    sql = "SELECT * FROM Personal"
    da = New OleDb.OleDbDataAdapter(sql, con)
    da.Fill(ds, "enrollment")

    max = ds.Tables("enrollment").Rows.Count
    inc = -1

    con.Close()


Private Sub Sve_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Sve.Click

    If inc <> -1 Then
        Dim cb As New OleDb.OleDbCommandBuilder(da)
        Dim dsnewrow As DataRow

        dsnewrow = ds.Tables("enrollment").NewRow()

        dsnewrow.Item("LastName") = TextLast.Text


        ds.Tables("enrollment").Rows.Add(dsnewrow)
        da.Update(ds, "enrollment")

        MsgBox("Saved!")
    End If
End Sub

whenever i run the program, it compiles, but when i click the commit button, this message appears "NullReference Exception was unhandled Object reference not set to an instance of an objects" and it points to .NewRow

score 0 · Answer 1 · answered Mar 09 '11 at 10:39

If I read right, you're getting the exception on this line:

dsnewrow = ds.Tables("enrollment").NewRow()

This means that either ds is null (unlikely since it's initialized), or that the table "enrollment" doesn't exist in the dataset.

However, it's very hard to answer your question well since you've not posted all of the code (the end of the first sub is missing, which suggests more code is probably missing too).

Have you clicked your toolstripmenuitem before you click commit? It looks like that's responsible for populating the dataset.

Mostly, though, I'd advise you learn to understand the code that you've copied better before you start posting questions about it...

Vb 10 nullreference exception

1 Answers1