DataTable.Select()???

kendalgoodrich

Is there any way to use the GROUP BY options with a DataTable.Select() method??????? Thanks, Kendal

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

kendalgoodrich22y ago
For speed purposes, I make 1 query to the database to retrieve 1 table. Then I make numerous queries to that datatable. It greatly increases the application speed and reduces network traffic. Thanks, Kendal
jcity44422y ago
Why not just put it in the SelectCommand of your DataAdapter. You can put any combination of sql query commands here. From MSDN: OdbcConnection nwindConn = new OdbcConnection("Driver={SQL Server};Server=localhost;" + "Trusted_Connection=yes;Database=northwind"); OdbcCommand selectCMD = new OdbcCommand("SELECT CustomerID, CompanyName FROM Customers", nwindConn); OdbcDataAdapter custDA = new OdbcDataAdapter(); custDA.SelectCommand = selectCMD; nwindConn.Open(); DataSet custDS = new DataSet(); custDA.Fill(custDS, "MyDataTableName"); -Mike