Performing a group by query on a datatable?

[VBDotNetProgrammer]

Hi,

I would like to perform an equivilent to a group by query on a Data Table object. Is this possible and if so could someone please give me a small demo of how it would be done?

Thanks

 

[bduke]

Are you using a stored procedure/dataset/or direct SQL statement to the data table.

SELECT CustomerID, CompanyName, ContactName, ContactTitle
FROM Customers
GROUP BY CustomerID, CompanyName, ContactName, ContactTitle

Hope this is what you're looking for if not just let me know...

 

[VBDotNetProgrammer]

Ah no sorry, i meant data stored in a vb.net data.datatable object.

Rgrds