ADO.NET

[Tony Johansson]

Hello!

I have never discovered when a DataSet will contains several DataTable.

Can somebode explain when a DataSet will contain several DataTable.

For example when using the Fill method for dataAdapter you will
always get a single TableAdapter.

//Tony

 

[Alberto Poblacion]

I have never discovered when a DataSet will contains several DataTable.

Can somebode explain when a DataSet will contain several DataTable.

For example when using the Fill method for dataAdapter you will
always get a single TableAdapter.

If you create two DataAdapters and use the Fill method of both of them on
THE SAME DataSet, you will get the two DataTables added to the DataSet.
If both tables are "connected" (e.g., they are linked by a foreign Key),
you can then add DataRelations and/or ForeignKeyConstraints to the DataSet
to allow navigation between both DataTables.