[RESOLVED] Data Binding to a TextBox

[Kimmy4]

Hi Guys,
I am really new to Dataset, DataTables, and all the rest of it!

This is the code i have:

Private dsetDB As DataSet
    Private daptVisit As SqlCeDataAdapter
    Private dtabVisit As DataTable
    Private sqlCmd As SqlCeCommand
 
    Private boolLoading As Boolean = True
 
    Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load
        If Database.openConnection() Then
            Debug.WriteLine("Connection Open")
        Else
            Debug.WriteLine("Connection Closed")
        End If
 
        dsetDB = New DataSet("Visit")
        daptVisit = New SqlCeDataAdapter("SELECT visitID FROM currentVisit", Database.sqlConn)
 
        Dim cbldVisit As New SqlCeCommandBuilder(daptVisit)
 
        daptVisit.Fill(dsetDB, "Visits")
        dtabVisit = dsetDB.Tables("Visit")
 
        lblVisit.Text = "VisitID"
 
        textVisit.DataBindings.Add("Text", dtabVisit, "visitID")
 
        boolLoading = False
    End Sub
 
    Private Sub textVisit_Validated1(ByVal sender As Object, ByVal e As System.EventArgs) Handles textVisit.Validated
        Me.BindingContext(dtabVisit).EndCurrentEdit()
    End Sub

Now i don't know exactly how all of this code works, i found some code in a book and have changed it so that it is relevant to my DB. Now i keep gettin an error on the line

textVisit.DataBindings.Add("Text", dtabVisit, "visitID")

and as i am completely new to this i dont know why this is happening or how to fix it, so could someone please help me!

The error i am getting is ArgumentNullException - An error message cannot be displayed because an optional resource assembly containing it cannot be found

If anybody could help me i would greatly appreciate it.

Thanks in advance for any help

[Kimmy4]

Managed to fix it....it turns out

dtabVisit = dsetDB.Tables("Visit")

should have been

dtabVisit = dsetDB.Tables("Visits")