I have a sql Query whose results are to be displayed in a particular
manner ( Having Total , Sub Totals , Out of Range etc..).

This could be easily handled in ASP as there was total control over
the layout of the table.

How do I get the same done in ASPX.

1)  Do I make a new(Custom) dataset & populate it with records
    in the desired manner?Is this correct. Secondly even after
    doing this I still will have to trap the OnItemDataBound
    event of the datagrid so as to format the row
    (i.e. colspan=6) in a particular manner.

2)  Loop through the dataset & create a table as it was done
    in ASP ( using table TD & TR tag)

-- 
Regards,
 Amit