DataSet to perform Agregate function

  • Thread starter Thread starter kids_pro
  • Start date Start date
K

kids_pro

Hi there,

I think it is a stupid idea but I wonder since dataset is a disconnected
datasource.
Why not all some more functionality to it like SUM, AVG, MIN, MAX when?
So that we don't need to send round trip to the server. :) may be imposible
:D
 
kids_pro said:
Hi there,

I think it is a stupid idea but I wonder since dataset is a disconnected
datasource.
Why not all some more functionality to it like SUM, AVG, MIN, MAX when?
So that we don't need to send round trip to the server. :) may be
imposible
:D
'
Click to expand...

This would probably be best posted to the adonet group, you will likely have
a much wider pool of expertise than you will here. I know lots about C# and
the framework, but when it comes to datasets you can paint a big ole stupid
sign on me(I am more of a fan of domain objects than datasets, myself. But I
don't want any lectures on that, everyone).
 
kids_pro,

You can do this. You can add another column to the DataTable and set
the Expression property to the aggregate function you want. If you want to
perform these operations by grouping, then you will have to create a
relation to another table which will group the values properly.

Check the Expression property on the DataColumn class for more
information on how to get the aggregate functions to work.

Hope this helps.
 
Back
Top