Re: .Net 2.0 DataTable have a lot of lacks?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

The DataTable .Select method does support "some"
aggregate functions like SUM and AVG. Another
parameter exists for ORDER BY.

You may want to look into what is supported.

--
Robbe Morris - 2004/2005 Microsoft MVP C#
http://www.eggheadcafe.com/forums/merit.asp





<mtczx232@xxxxxxxxx> wrote in message
news:1135803746.774985.302860@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> it seem that data table and Expression field have a lot of Laks, it is
> true?
>
> the DataTable is powerfull of Memory relation data that bind to
> controls.
> so i can load data from remote service and manipulate it and after i
> send update to remote service.
>
> But, when i need to make standart operation that with SQL system is
> simple,
> with Datatable it's impossible.
>
> for example think about Accounting records. i load record from remote.
> and thaen
> user chnge Movement and add some. now (before we update the remote
> server),
> how i can put on the screen balance? by loop over all rows and grouping
> it manually!!
> instead write Group by!!??
>
> [in vb6 i remember the Data Environment that allow grouping!!]
>
> have some Project that extend DataTable abilities?
>
> also with DataColumn.Expression have a Lacke of many simple function.
> like Round, have a way to extend it?
>


.