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