Originally Posted by Roey
I am looking to create a column in my datagrid that does a running total of items eg
Item Qty Running Total
Not sure if I should be computing on a new dataset column or using SQL
Thanks in advance
I cant think of anyway to do that in SQL, but not hard in a dataset column. . .
something along the lines of this
value column = n
total column = t
curr row = r
for i = 0 to rows.count-1 do
if (r = 0)
rows[r]col[t] = rows[r]col[n]
rows[r]col[t] = rows[r-1]col[n] + rows[r]col[n]
Amendment 4: The right of the people to be secure in their persons, houses, papers, and effects, against unreasonable searches and seizures, shall not be violated, and no warrants shall issue, but upon probable cause, supported by oath or affirmation, and particularly describing the place to be searched, and the persons or things to be seized.
Amendment 9: The enumeration in the Constitution, of certain rights, shall not be construed to deny or disparage others retained by the people.