I am having trouble binding a DataSet to TextBoxes on a form.
The last line gives me this error:
"Child list for field tbl cannot be created"
my code is this:
The last line gives me this error:
"Child list for field tbl cannot be created"
my code is this:
Code:
Dim sql As String = "Select * From tbl Where ID=2"
Dim ConString = ClassicCooking.My.Settings.Connstring
Dim Conn As New SqlConnection(ConString)
Dim myDataSet = New DataSet
Dim MyBinding As New BindingSource
MyBinding.DataSource = myDataSet.Tables("tbl")
Dim myAdapter As New SqlDataAdapter
myAdapter.UpdateCommand = New SqlCommand()
myAdapter.UpdateCommand.CommandText = "sptbl_Update"
myAdapter.UpdateCommand.CommandType = CommandType.StoredProcedure
Dim field1 As New Binding("Text", myDataSet, "tbl.RZone")
Me.RZone.DataBindings.Add(field1)