Creating a new Datatable with from an existing Datatable using SQL

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
 
C

Cor

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clear a datatable before inserting new records 7
Create empty datatable from SQL Server table? 1
How fill existing DataTable? 5
Strongly typed DataSets: Relation between DataTable and TableAdapter 3
Creating a Dataview from a Dataset using SQL? 3
DataTable ColumnChanging event nit firing on adaptor.Fill() 1
Issue SQL Statement with a DataTable in VB 2005 2
know if a datatable is being schemafilles but not ever filles 3

Top