DataSet to perform Agregate function

[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

[Daniel O'Connell [C# MVP]]

"kids_pro" <ki******@yahoo.com> wrote in message
news:eP**************@TK2MSFTNGP12.phx.gbl...

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
'

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).

[Nicholas Paldino [.NET/C# MVP]]

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.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"kids_pro" <ki******@yahoo.com> wrote in message
news:eP**************@TK2MSFTNGP12.phx.gbl...

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