I know I could loop through the rows in a ado.net datatable to do this, but
is there a way to do the equivalent of "select sum(fiieldname) from table
where..." in a nice concise way? Thanks.


--

Matt

"Gravity. It's not just a good idea, it's the law!"

Hi,

See DataTable's Compute method.

--
Teemu Keiski
MCP, Microsoft MVP (ASP.NET), AspInsiders member
ASP.NET Forum Moderator, AspAlliance Columnist

"MattB" <(E-Mail Removed)> wrote in message
news:c3d765$268j0g$(E-Mail Removed)...
> I know I could loop through the rows in a ado.net datatable to do this,
but
> is there a way to do the equivalent of "select sum(fiieldname) from table
> where..." in a nice concise way? Thanks.
>
>
> --
>
> Matt
>
> "Gravity. It's not just a good idea, it's the law!"
>
>