Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Performing a group by query on a datatable?

Status
Not open for further replies.

VBDotNetProgrammer

Programmer
Joined
Jul 9, 2003
Messages
50
Location
GB
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
 
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...


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

Rgrds
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top