Fill DataSet with two tables

[Lost User]

DataTable table1 = new DataTable(); DataTable table2 = new DataTable(); DataSet dataSet = new DataSet(); dataSet.Tables.Add(table1); dataSet.Tables.Add(table2);

[Mike Ellison]

DataAdapter.Fill perhaps? If you're using SQL Server for your database, you can call a stored procedure that returns two result sets - each will be filled in the dataset as a separate DataTable. The stored procedure is simple:

CREATE PROCEDURE Sample
AS
BEGIN
select * from table1;
select * from table2;
END

MishaInTheCloud.blogspot.com

[Rahul DSG]

the code is like this.. SqlCommand cmd; SqlConnection conn; SqlDataAdapter sda; conn = new SqlConnection("server=Sai2; database=Inventory; uid=sa; pwd=123456;"); cmd = conn.CreateCommand(); cmd.CommandText = "select * from stock"; sda = new SqlDataAdapter(); sda.SelectCommand = cmd; DataS.Stock ds = new SisInventorySystem.DataS.Stock(); sda.Fill(ds, "stock"); Crystal_Reports.TotalStockRpt TtlStkRpt = new SisInventorySystem.Crystal_Reports.TotalStockRpt(); TtlStkRpt.SetDataSource(ds); crystalReportViewer1.ReportSource = TtlStkRpt; crystalReportViewer1.DisplayToolbar = true; Now i have to run one more Query "select * from Company" having nothing in common between table company and stock.

[PIEBALDconsult]

With SQL Server: "SELECT * FROM Table1 ; SELECT * FROM Table2" (Other database engines don't allow multiple statements in a command.)

[Robin_Roy]

You can write a stored procedure that returns multiple recordset and get the resultset directly mapped with a dataset, it will create the same number of datatables in your dataset as the count of resultset in your procedure...

[Rahul DSG]

ok... and after what to write... da.fill(ds,"whichtable"); can i write the both table....

[Mike Ellison]

Access the tables through the DataSet's Tables collection:

DataTable dt0 = ds.Tables[0]; // first result set from the batch queries
DataTable dt1 = ds.Tables[1]; // second result set from the batch queries

MishaInTheCloud.blogspot.com

[Rahul DSG]

Done All the things but can not Solved ... sda.fill(ds,"Table name Is Must.") Is there any Solution...

[Mike Ellison]

Why is the table name a must upon filling? You can always change the table name (if you really need to) after filling the set like this:

sda.Fill(ds);
ds.Tables[0].TableName = "tableNameIsAMust.";
ds.Tables[1].TableName = "somethingElse";

Or is it that you are looking to execute two queries separately (instead of together in one batch)? In that case, you could supply separate table names upon filling:

da1.Fill(ds, "Table1");
da2.Fill(ds, "Table2");

I'm having difficulty understanding exactly why this is problematic for you. Can you explain?

www.MishaInTheCloud.com

[Rahul DSG]

Actually I have to make a crystal report which needs two table nothing is common in between these two tables.i tried all these suggestion in this section but not working...i already posted my code...