using DataTable how to handle query = "slect sum(amount)/count(amount) from emp group by CustomerID"

[EDN Admin]

I have a dataTable having 1000 rows,
i want to query the dataTable as like " slect sum(amount)/count(amount) from emp group by CustomerID "
I tried to solve it using
dataTable.Select("<font color="#ff0000 sum(amount)/count(amount)</font>", "<font color="#ff0000 group by CustomerID</font>");
but i encountered an error.



and another question is
when the result returns using above query then i want to show it in dataGridiew.

how to solve this problem, i it is not possible show me alternative other then storing it in RBMS.
<hr class=sig>
Seek Knowledge From Cradle to Grave

View the full article