Thanks a lot for your response. I am now looking into the idea of creating a
new dataset in memory and merging the results from the other two dataset.
In addition since I am using ASP.net 2.0 I have come accross a Merge method
for Dataset that allows you to merge datasets but I get an error of
"<target>.nID and <source>.nID have conflicting properties:"
which I assume is based on the Merge taking the ID column as the primary key
hence trying to keep it unique, I will try to investige these possibilities
to sort this issue out. thanks a lot for your help.
Imran.
<jh*****@yahoo.com> wrote in message
news:11*********************@e56g2000cwe.googlegro ups.com...
I inherited a project that included a lot of this. Typically we might
create a third dataset
and populate it by iterating through the original two, taking the
values we needed.
We also had a module called DataSetHelper, which was probably found
somewhere on the web -- try googling for it. This provided a lot of
functionality (SelectDistinct,Min,Max).
I can't remember if sorting is available with the native
DataSet/DataTable.