Dataset/datatables as a source for a Datalist/Datagrid combination
I have a report with a datagrid in the ItemTemplateColumn of a datalist.
The datalist is populated with one stored procedure call to the database
and the datagrid with a second stored procedure call on every datalist
I want to change this.
I want to make one stored procedure call and populate one dataset
with two datatables containing the info I need and create a
datarelation to link the two.
I can see how to get it going to the point where the datalist item
is being populated, but at that moment I don't know how to get to the
dataset and get the data I need for the datagrid.
Is this feasible and if so can you help me where I'm stuck?