Datatable = dataset.Tables( "Supplier") ?

[Tom W]

code snipped from MS sample "N-Tier Data Form and Data Layer" example
(101 vb.net samples).

Public Class frmMain
Private dsSupplierProdu cts as DataSet
Private dtSupplier as DataTable
Private dtProducts as DataTable
Private dvSupplier as DataView
Private dvProduct as DataView

Sub GetDateSet()
m_DAL = new DataAccess () 'Data access tier.
dsSupplierProdu cts = m_DAL.CreateDat aSet() ' this returns one
dataset with two tables, Supplier & Products

'Set variables for the DataTables for use later
dtSupplier = dsSupplierProdu cts.Tables("Sup plier")
dtProducts = dsSupplierProdu cts.Tables("Pro ducts")

'Set up Dataviews for the datagrid
dvSupplier = dtSupplier.Defa ultView
dvProduct as dtProducts.Defa ultView
end Sub

Sub BindProductsGri d()
....
dvProducts.RowF ilter = "Suppliers = " & strCurrentSuppl ierID

With grdProducts
.CaptionText = "whatever"
.DataSource = dvProducts
end With

End Sub
What I don't understand are the lines
dtSupplier = dsSupplierProdu cts.Tables("Sup plier")
dtProducts = dsSupplierProdu cts.Tables("Pro ducts")

Do these assignments populate separate, distinct datatables with the two
tables from the dataset? IE: the data now exists in two places?
Or are the datatables just pointers to the original dataset.datatab les
(dsSupplierProd ucts.Tables(".. "))?

Changes made to data in the grids is passed back to the data access tier
like:
m_DAL = new DataAccess()
m_DAL.UpdateDat aSet(dsSupplier sProducts.GetCh anges())
Thanks
Tom

--

E-mail correspondence to and from this address may be subject to the
North Carolina Public Records Law and may be disclosed to third parties.

[GhostInAK]

Hello Tom,

dtSupplier and dtProducts should both be references to their respective tables
in dsSupplierProdu cts. Any changes made to one should be reflected in the
other.

-Boo

What I don't understand are the lines
dtSupplier = dsSupplierProdu cts.Tables("Sup plier")
dtProducts = dsSupplierProdu cts.Tables("Pro ducts")
Do these assignments populate separate, distinct datatables with the
two tables from the dataset? IE: the data now exists in two places?
Or are the datatables just pointers to the original dataset.datatab les
(dsSupplierProd ucts.Tables(".. "))?

Changes made to data in the grids is passed back to the data access
tier
like:
m_DAL = new DataAccess()
m_DAL.UpdateDat aSet(dsSupplier sProducts.GetCh anges())
Thanks
Tom