locked
Datatable RRS feed

  • 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

    Friday, September 13, 2019 6:45 PM

All replies

  • 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.
    Saturday, September 14, 2019 1:29 PM
  • 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

    Monday, September 16, 2019 8:09 AM