Hi all,

i am applying aggregate function on datatable.compute. I have one
fiter criteria and based on that i want to apply sum function on two
columns like sum(sal), sum(pf). if i write query in sql it is
allowing me to use more than one aggregate function but how to do it
in datatablse.select. or is there any other alternative of doing
this. i want this in disconnected datatable only.

please help me asap.

thanks in advance.

You might consider using LINQ to Dataset if possible.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"Archana" <(E-Mail Removed)> wrote in message
news:27b37738-7a48-4ea2-a5ca-(E-Mail Removed)...
> Hi all,
>
> i am applying aggregate function on datatable.compute. I have one
> fiter criteria and based on that i want to apply sum function on two
> columns like sum(sal), sum(pf). if i write query in sql it is
> allowing me to use more than one aggregate function but how to do it
> in datatablse.select. or is there any other alternative of doing
> this. i want this in disconnected datatable only.
>
> please help me asap.
>
> thanks in advance.