[RESOLVED] Data Binding to a TextBox
Hi Guys,
I am really new to Dataset, DataTables, and all the rest of it!
This is the code i have:
VB Code:
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
VB Code:
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
:afrog:
Re: Data Binding to a TextBox
Managed to fix it....it turns out
VB Code:
dtabVisit = dsetDB.Tables("Visit")
should have been
VB Code:
dtabVisit = dsetDB.Tables("Visits")
:wave: