multiple tables in a DataSet

Question

how to load multiple tables in a DataSet ?

Sam Hobbs · Answer

You need to be more clear in your question. Do the tables already exist? I assume they do but it would help to state that explicitly. Are the fields different for the two tables? I assume they are but it would help to state that explicitly. If there are other issues such as Referential integrity then it would help to specify those too. There are many ways to do what you are asking for help with so if you specify what you are familiar with then that will help too.

Suthish Nair · Answer

use SqlDataAdapter to load dataset with multiple tables (number of tables count depends on the number of SELECT queries)

Jiteendra Sampathirao · Answer

Hi, objCommand.CommandText = "Table1" objDataAdapter.Fill(objDataSet, "Table1") objCommand.CommandText = "Table2" objDataAdapter.Fill(objDataSet, "Table2") Above is a sample code which shows how to load multiple "DataTable" objects in one "DataSet" object. Sample code shows two tables "Table1" and "Table2" in object ObjDataSet. lstdata.DataSource = objDataSet.Tables("Table1").DefaultView In order to refer "Table1" DataTable, use Tables collection of DataSet and the Defaultview object will give you the necessary output. Source: Sivaprasad Koirala Interview book

Mayur Gujrathi · Answer

Can you please explain more your scenario? in which situation you want to add tables in dataset

Muralidharan Deenathayalan · Answer

DataSet.Tables.Add(yourDataTable1) DataSet.Tables.Add(yourDataTable2) otherwise you can do two or more select statements from your sp...

Praneeth Kumar · Answer

If you are using a stored procedure. in simple if you have 2 select queries inside that stored proc you will have 2 tables inside dataset when you call that stored proc.