How to add mutiple table Reference in dataset

Question

Hi I want to add more than one table in dataset. how i can please suggest me. For example Gridview1.datasource= ds.table[2]; It mean dataset contain three table reference. so provide me code through which i can add more than one table reference in dataset.

Hemant Srivastava · Answer

What Satya Praksh wrote above that is also one of the way. Another way you could directly create a data table in code and add it to your data set. e.g. DataSet customerOrders = new DataSet( CustomerOrders ); DataTable ordersTable = customerOrders.Tables.Add( Orders ); DataColumn pkOrderID = ordersTable.Columns.Add( OrderID  typeof (Int32)); ordersTable.Columns.Add( OrderQuantity  typeof (Int32)); ordersTable.Columns.Add( CompanyName  typeof ( string )); ordersTable.PrimaryKey = new DataColumn[] { pkOrderID };

Veerabhadram Dhodla · Answer

IF you put 3 select statement in a stored Procedure that will return 3 tables to you. Now bind your data set to that Stored Procedure. Automatically your dataset will get 3 tables