How can we load multiple tables in a DataSet ?
objCommand.CommandText = "Table1"
objDataAdapter.Fill(objDataSet, "Table1")
objCommand.CommandText = "Table2"
objDataAdapter.Fill(objDataSet, "Table2")
The sample code above shows how to load multiple "DataTable" objects in one
"DataSet" object. The Sample code shows two tables "Table1" and "Table2" in the object ObjDataSet.
lstdata.DataSource = objDataSet.Tables("Table1").DefaultView