Updating database table.

Dear Sir,

Below mention code I used in Visual Basic 6 to update my MS Access Table to get UPDATED Balance Column. Now my problem is the same code I want to use in Visual Basic 2010 to update SQLserver Table. Can u guide me pls.

SQL Code in VB6.
With recordsetBank
.MoveFirst
Balance = .Fields("Balance")
Do While .EOF = False
Balance = Balance + .Fields("Debit") - .Fields("Credit")
.Fields("Balance") = Balance
.MoveNext
Loop
End With

For ur information : I have Dataset, Bindingsource and TableAdaptor in Windows Form so with that how can I update my Balance Column. The Table contained 3 columns i. Debit ii. Credit iii. Balance.

Thanks.

Hello ahmed

why Update ,
instead a simple select query will give the out put what you are in need, and it responds any changes in the data base dynamically.
just create a view and save it that's all it will work as table
say for example your table name is Ledger

Code:

---

SELECT Ledger.Debit, Ledger.Credit, [Ledger]![Debit]-[Ledger]![Credit] AS BALANCE FROM Ledger;

---

this view will give your data out put what you are trying for

Yes your way also correct but my idea it is in my mind and I used in vb6 that above code also I told u before that Running Total Matter, can u remember. Of course I used the same command in vb to get Running total update. Once I click command button from vb form its gets update.
Pls try with my same code and reply to me.

Thanks.