How to add mutiple table Reference in dataset

Satya Prakash

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Hemant Srivastava14y ago
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 Dhodla14y ago
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