疑難雜症:在DataTale中如何實現SQL的匯總查詢功能???

Question

如題!

Answer 1

you can use DataTable's Compute method, for exampleobjSum = myTable.Compute("Sum(Total)", "EmpID = 5");see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatadatatableclasscomputetopic.asphttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndive/html/data05312002.asp

Answer 2

dim ard() as DataRow= ds.Table["Customers"].Select("Country='Venezuela'","ContactName ASC")

Answer 3

太好了~~
非常感謝saucer(思归)!!!