I am trying to read data from an access database and do some computations like average of certain column values using ADO. I was able to select the data in to a datagrid using ADO. But is there any way can manipulate say find average and std deviation of a certain column in the datagrid and display it in the same windows form .

I think its better to get the avrage when u retrive the data.
However u can get the avrage in DataSet too, but u will have to do all steps urself, I mean read all records & get the sum then ...

Keep in touch.

Always:),
Hovik Melkomian.

Hi you can do via DataColumn Expression in DataTable, try the following links

http://msdn.microsoft.com/library/de...ta05312002.asp

http://msdn.microsoft.com/library/de...ssionTopic.asp


It is not how much we do,
but how much love we put in the doing.

-Mother Theresa