Datatable

Question

User-797751191 posted

Hi

  I have 1 stored procedure like below . I want to create 2 datatables and then merge data & then pass to ReportDatasource 

I dont want to create 1 query

select * from customers

select * from custaddress

Thanks

Answer 1

User1120430333 posted
http://csharp.net-informations.com/data-providers/csharp-multiple-resultsets.htm

The result of executing the sproc is one resultset that has multiple results. You would have to create and load datatables and load them manually from each usage of the the datareader.

Answer 2

User288213138 posted

Hi jsshivalik,

jsshivalik

I have 1 stored procedure like below . 

I dont want to create 1 query

select * from customers

select * from custaddress

Can you tell me why can't create 1 query? What are its application scenarios？

As far as I know, putting two queries into a stored procedure and returned data from the first table.

jsshivalik

I want to create 2 datatables and then merge data

Is the DataTable created based on the data in the stored procedure?

Is there any relation between these two tables?

jsshivalik

pass to ReportDatasource 

Which control's data source of ReportDatasource?

So please post more details information about your requirement.

Best regards,

Sam