This is a migrated thread and some comments may be shown as answers.

Procedure gives me two tables

2 Answers 76 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Sony Telkar
Top achievements
Rank 1
Sony Telkar asked on 29 May 2009, 06:24 AM
I have a stored procedure which gives me two different tables. One having the details of the loans and the other having calculated averages of the numbers of these loans. I have two sections of the report which are to be binded respectively with these two tables.
My problem is how can I handle a dataset with the procedure giving me two result sets?

Any help would be appreciated. Thanks


2 Answers, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 29 May 2009, 10:03 AM
Hello Sony,

A report can be bound to a single data table only. If you need to present data from more than one, then you can use the Table or Subreport report items i.e. you can bind the report to one datatable report1.DataSource = dataSet1.Table[0]; and bind a subreport or table item to another e.g. dataSet1.Tables[1];

Greetings,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
0
Sony Telkar
Top achievements
Rank 1
answered on 29 May 2009, 10:10 AM
Thanks Steve,

But in this case how will the dataset get populated. As far as I know the tableadapter takes only one table columns. It does not know which table of the procedure to take. Do we have to manually call the procedure and fill the dataset instead of using tableadapter.
Tags
General Discussions
Asked by
Sony Telkar
Top achievements
Rank 1
Answers by
Steve
Telerik team
Sony Telkar
Top achievements
Rank 1
Share this question
or