I currently have a Dataset with a single Datatable, which is filled
using a DataAdapter. I would like to run a SQL query on the Datatable
and create a new Datatable in the same Dataset with the results from
the SQL query.

The results from the second Datatable will be used to populate a
Crystal Report.

Any ideas or suggestions on how I should approach this?

Thanks,

Minh

Hi Monkhi,

I did not take long time to think about your problem, but I think that
\\\
dataset.tables.add(mynewtable)
///
I asume you did already clone the datatable and populated it with the
founded datarow array from the datatable.select.

I think this is all you need?

Cor

> I currently have a Dataset with a single Datatable, which is filled
> using a DataAdapter. I would like to run a SQL query on the Datatable
> and create a new Datatable in the same Dataset with the results from
> the SQL query.
>
> The results from the second Datatable will be used to populate a
> Crystal Report.
>
> Any ideas or suggestions on how I should approach this?
>
> Thanks,
>
> Minh