How to extract data from a Datatable into another DataTable or dat

  • Thread starter Thread starter PIPUSER
  • Start date Start date
P

PIPUSER

I have a DataTable that I build from a .CSV file and that works fine. I then
update some SQL Server tables. To finish the job I need a query like the
following to run on the DataTable I have created:

"SELECT Shippernum,Date,Sum(Amount) as Amt,Sum(Premium) as Prem,Count(*) as
PKGS FROM pdsData.Tables(""Items"") GROUP BY Shippernum"

Can this be done with the Datatable.Select()??? Can something like this be
done using anything? Thanks in advance!
 
Thx MB, this answer and the links look like good stuf and
I should be able to crank out what I need from this.
 

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

Adding datatable data to sql database. 1
Creating a DataTable from another DataTable 7
Datatable to a new DataTable 1
copy data from one datatable to another - different schemas 2
transfer data from Dictionary to DataTable 2
Oracle integer is set to Decimal in the DataTable 1
select sum from column 3
How to fill a datatable with data from another datatable 2

Back
Top