DataTable.Select()???

Question

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

kendalgoodrich · Answer

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

jcity444 · Answer

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