Creating a new Datatable with from an existing Datatable using SQL

  • Thread starter Thread starter monkhi
  • Start date Start date
M

monkhi

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
 
Back
Top