Hi to all,

I am working on an e-commerce site , and Im trying to show a documents
historic to the user.So the idea is to have a table like this:

Orders    Deliveries          Invoices ...
----------------------------------------------
123        4125               5214
           1236               5214
           5214               63214
-----------------------------------------------
854        854                8541
           85478              89654
                              8745
-----------------------------------------------


So i have many procedures to get these informations .
1) Get the list of orders numbers
2)for each order , get the list of deliveries
3)for each order ,get the list of invoices

In the table we have for exemple an order (in orders column) , and all
the Deliveries that correspond to this order(in Deliveries column) ,
all the invoices that correspond to the orders and Deliveries (in the
invoices column).

So i can't bind my DataList to one simple SQLDataReader , because i
have many procedure .How can i do this??
Thank you for any idea

It sounds like you would be better served with a DataSet. You could
load all the data into one dataset, set your DataRelations between
tables and you can get the child rows of each parent row easily, and it
would be a much cleaner solution with a much easier implementation.
Check out
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpcontheadonetdataset.asp
for an overview of the ADO.NET.

Jason Bentley
http://geekswithblogs.net/jbentley

5th Re-Post with NO RESPONSE FROM MS!
Hyperlink Format
Can't get a reference to user control in datagrid
DataGrid Export to Excel
Sorting Datagrid With Hyphen / Dash
How can I format a telephone # in the datagrid
Problem with Top And Bottom Paging
DataGrid sort when Editing
email validation
textbox.value