Querying DataTable, or...

[mcfly1204]

As it stands now, I have a tab delimited source file with data to be used by my app. Currently, I am reading the file into a datatable, but I need to group the rows of the datatable and use that data to create another file for each group. Should I abandon reading the source file into a datable, and instead insert the source file into a sql server table?

The source file consists of customers and invoices. I would like to have a group of all invoices per customer so that I can make a summary file of each customers invoices.

[mcfly1204]

**Addition**

- use string array to collect a distinct list of customerid's
- for each customerid in the string array, collect all invoices
- for each collection of invoices, create a summary file