Q: sum on datagrid

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JIM.H. - 14 Jul 2005 22:01 GMT

Hello,

float tAmt = dataSet11.Tables[myTable].Compute("Sum(myAmount)", "");

I have this line in my code to calculate total myAmount field in my
datagrid. Now I need to do this conditional to another field in the datagrid.
Like “Sum(myAmount) where mySecondField =”XXXX””. How can I do this?

Thanks,

Reply to this Message

Daniel Walzenbach - 15 Jul 2005 03:17 GMT

Jim,

I don't have VS running so I don't know if this works but give it a try.

float tAmt =
dataSet11.Tables[myTable].select("mySecondField='XXXX'").Compute("Sum(myAmount)",
"");

Regards,

Daniel

> Hello,
>
[quoted text clipped - 6 lines]
>
> Thanks,

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...