搭建父子关联表（Build parent-child association table）.docVIP

搭建父子关联表（Build parent-child association table） Build parent-child association table It is also necessary to study how to display after creating a parent-child query Public Class NorthwindDataSet Public, Shared, Sub, Main () Dim connectionString As String = _ GetConnectionString () ConnectToData (connectionString) End Sub Private Shared and his son Sub to create _ query (ByVal connectionString As String the original sample) create a SqlConnection to Northwind database. Using, connection, As, SqlConnection = New, SqlConnection (connectionString) Create, a, SqlDataAdapter, for, the, Suppliers, table. Create a SqlDataAdapter vendors table. Dim, suppliersAdapter, As, SqlDataAdapter = New, SqlDataAdapter () A, table, mapping, names, the, DataTable. a table map name DataTable. SuppliersAdapter.TableMappings.Add (Table, Suppliers) Open the connection. Connection.Open () Console.WriteLine (The SqlConnection is open.) Create, a, SqlCommand, to, retrieve, Suppliers, data. create a SqlCommand to retrieve vendor data. Dim suppliersCommand As SqlCommand = New SqlCommand (_ SELECT SupplierID, CompanyName FROM dbo.Suppliers, _; Connection) SuppliersCommand.CommandType = CommandType.Text Set, the, SqlDataAdapters, SelectCommand. set SqlDataAdapter SelectCommand. SuppliersAdapter.SelectCommand = suppliersCommand Fill, the, DataSet. fill DataSet. Dim, dataSet, As, DataSet = New, DataSet (Suppliers) SuppliersAdapter.Fill (dataSet) Create, a, second, SqlDataAdapter, and, to, get, the, Products, table, a, child, table, of, SqlCommand, Suppliers. create second SqlDataAdapter and SqlCommand to get the product list, a child watch provider. Dim, productsAdapter, As, SqlDataAdapter = New, SqlDataAdapter () ProductsAdapter.TableMappings.Add (Table, Products) Dim productsCommand As SqlCommand = New SqlCommand (_ SELECT ProductID, SupplierID FROM dbo.Products, _; Connection) ProductsAdapter.SelectCommand = productsCommand Fill the DataSet. fill DataSet. ProductsAdapter.Fill (dataSet) Close the co