Multiple tables in dataset

[gqstud79]

Can anyone tell me how to add multiple tables to a dataset? I'm having all kinds of problems trying to figure it out. Thanks Edited November 18, 2002 by gqstud79

[Bucky]

First you need to create a new table to add, then all you need to

do is add that table to the DataSet's Tables collection, using its

add method.

 

Here ds is the dataset:

Dim dtMoo As New DataTable("Moo")

ds.Tables.Add(dtMoo)

 

Then dtMoo will be one of the DataSet's tables, and you can

access it by an index, its name, or the DataTable instance itself (dtMoo).

 

You can add as more tables to the DS using this same method.

 

[edit]Fixed up some stuff[/edit]

[robertsams23]

multiple tables in dataset , click the following link

 

http://vb.net-informations.com/dataset/dataset-multiple-tables-sqlserver.htm

 

robert.