|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Cpmute values in Dataset Table??assigning datagrid source to it??? My data table looks something like this. DATE CAT STEP VALUE --------------------------------------------------------------------------- 01/16/2006 AAA1 50 1 01/16/2006 AAA1 50 1 01/16/2006 AAA1 50 1 01/16/2006 AAA1 50 1 01/16/2006 AAA1 100 2 01/16/2006 AAA1 100 2 01/16/2006 AAA1 100 2 01/16/2006 AAA1 100 2 01/17/2006 BBB1 50 3 01/17/2006 BBB1 50 3 01/17/2006 BBB1 50 3 01/17/2006 BBB1 50 3 01/17/2006 BBB1 100 4 01/17/2006 BBB1 100 4 01/17/2006 BBB1 100 4 01/17/2006 BBB1 100 4 What i want to do is to be able to sum "VALUE" for each step & date. Final Output: DATE CAT STEP VALUE --------------------------------------------------------------------------- 01/16/2006 AAA1 050 4 01/16/2006 AAA1 100 8 01/17/2006 BBB1 050 12 01/17/2006 BBB1 100 16 Thanks for your help! Can you just write an SQL statement to grab the sum and then add to the
dataset? This data table is a result of a SQL query which i cant change....so i
was wondering if there is a way to query a dataset table or view? This data table is a result of a SQL query which i cant change....so i
was wondering if there is a way to query a dataset table or view? Jaawaad,
Compute gives the values in Net alone for a complete datatable. Probably can this sample help you to do it, although you have now to sum the values in the for index loop. http://www.vb-tips.com/default.aspx?ID=dcad9a66-1366-4d61-8d32-1a580eb893b2 I hope this helps, Cor Cor, thanks...i will look into this example. Althoght, i was wondering
if there was an easy way to query dataset table and make a new table out of the result. 
Other interesting topics
MsgBox("test") no msg box?
Type 'OleDbConnection' no define Getting the hWnd of an IE window from an NT service Typed DataSet The free format? How to know if Windows Update is ON or OFF? Generate all possible maches from a regular expression. Confusion: VB Express/VC Express/Sql Server Express Edition DataGridBoolColumn - Greyed Out vb.net asp converting |
|||||||||||||||||||||||
