store procedure return multiple data sets how to access all data sets in telerik report designer

2 posts, 0 answers
  1. zubair
    zubair avatar
    1 posts
    Member since:
    Mar 2017

    Posted 14 Mar 2017 Link to this post

    see my question also on stack overflow http://stackoverflow.com/questions/42758013/store-procedure-return-multiple-data-sets-how-to-access-all-data-sets-in-telerik

    when i add SQL data source and add store procedure in it, Actually store procedure return multiple tables but in telerik report designer just got single table or single table parameters if anyone can't understand my question than visit above link

     

    SQL store procedure result https://i.stack.imgur.com/ZL1hz.png

    in telerik report designer https://i.stack.imgur.com/uoonR.png

     

     

  2. Stef
    Admin
    Stef avatar
    3610 posts

    Posted 14 Mar 2017 Link to this post

    Hi zubair,

    The SqlDataSource component uses the .NET data provider, the associated ADO.NET classes and the connection string to create a connection and to execute the SQL command. The result is loaded in a DataSet from which you can use the first result set.

    If you want to use all results sets, you can load the data in a custom business object  (Entity Framework or other data access layer) and switch to the Entity/OpenAccess/Object data source components. We recommend the data-binding approaches from How to Databind to Collection Properties and Use DataObject as a datasource for nested data items (Table, List, Crosstab, Graph).

    Regards,
    Stef
    Telerik by Progress
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top