|
-
Mar 12th, 2004, 10:49 AM
#4
Thread Starter
New Member
Yes, the dataset is populated
The dataset is populated and shows on the form.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & _
"F:\Vendor_Compliance.mdb"
adpCarriers.TableMappings.Add("Table", "tblcarrier")
adpWHSE.TableMappings.Add("Table", "tblWarehouse")
adpVENDOR.TableMappings.Add("Table", "tblVendor")
adpCarriers.SelectCommand = New System.Data.OleDb.OleDbCommand(mySelectQuery, conn)
adpWHSE.SelectCommand = New System.Data.OleDb.OleDbCommand(mySelectQuery2, conn)
adpVENDOR.SelectCommand = New System.Data.OleDb.OleDbCommand(mySelectQuery3, conn)
Try
conn.Open()
adpCarriers.Fill(mydataset)
adpWHSE.Fill(WHSEdataset)
adpVENDOR.Fill(VENDORdataset)
Mytable = mydataset.Tables(0)
TextBox1.DataBindings.Add(New Binding("Text", mydataset, "tblcarrier.carrierid"))
TextBox2.DataBindings.Add(New Binding("Text", mydataset, "tblcarrier.name"))
cbWarehouse.DataSource = WHSEdataset.Tables("tblWarehouse")
cbWarehouse.DisplayMember = "Name"
cbVendor.DataSource = VENDORdataset.Tables("tblVendor")
cbVendor.DisplayMember = "Name"
Catch ex As Exception
System.Diagnostics.Debug.WriteLine(ex.Message & "l " & ex.StackTrace)
conn.Close()
End Try
End Sub
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|