vb.net Calculate total column from database

[Embed]

Hey there,

I'm New'ish to vb.net but having a bit of trouble with my program.

I'm currently writing a program for college (atm machine simulator) but I'm having a bit of trouble working out how to add all the rows up in a specific column from a database which houses the 'account details' to allow me to work out the maximum £ of all the accounts.

My tutor was saying that I must use an array to do it as a new account could be created at any time thus increasing the total again.


What iv been using so far for other ds stuff is this code

ds.Tables("AccountRecord").Rows(index).Item(7)

Can I use something like

ds.Tables("AccountRecord").[B]columns[/B](index).Item(7)

Is that too vague ?

Doing my nut in haha

Hope someone will understand!

Thanks in advance

 

[Cheetah Designs]

Can you not do in pseudocode:

column = column you want to grab
total = 0
for i = 0 to rowscount
    total += rows[i].item[column]
end

 

[Dj_Jestar]

LinQ to the rescue..

(Paraphrased from C#, and somewhat guessing what your examples are using)

int total = ds
    .Tables("AccountRecord")
    .Rows(index)
    .Sum( eachRow => eachRow("columnName") )