Not able to create data source of stored procedure that is returning multiple table

[Jayesh]

Hi All,

I am facing an issue with creating data source for store procedure which is returning multiple table in response,
not able to retrive all tables, currently I am getting only first table .

please suggest any method to solve this.

thanks in advance
Jayesh Idnani

[Momchil]

Hello Jayesh,

Indeed, the SqlDataSource component will only load the first result set if more than one is returned from the stored procedure (see Selecting Data with the SqlDataSource).

If dividing your existing stored procedure into separate ones for each result set is not an option, I can suggest the following workaround.

Use the ObjectDataSource component to read the data into a DataSet and set the DataSource and DataMember properties of the object data source accordingly (the DataMember property is the property you can use to indicate which table to bind to). Take a look at the Binding ObjectDataSource to a DataSet article for more information.

Note that in order to use your object data source in the Standalone Report Designer, you would need to extend the configuration of the designer with your custom assembly. The same applies if you need to use the object data source in your web application.

I hope this helps.

Best Regards,
Momchil
Progress Telerik