Update SQLserver Database Table Column.

[Miquash]

Dear Sir,

I'm maintaining a Table in SQLserver, the Table contains Transaction of Cash IN(Debit) and Cash OUT(Credit) as follows:
Table Name : "BankLedger "

DATE...DETAILS........DEBIT...CREDIT...BALANCE
1/1/11.Opening Balance.................5000
1/1/11.Rent payment...........2500.....
2/1/11.Mobile Bill.............500.....
3/1/11.Monthly Share...5000............
6/1/11.Emp Salary.............3000.....

Now my requirement is how to update the Balance column respectively same as "Running Total" method???

DATE....DETAILS........DEBIT...CREDIT..BALANCE
1/1/11..Opening Balance................5000
1/1/11..Rent payment...........2500....2500
2/1/11..Mobile Bill.............500....2000
3/1/11..Monthly Share...5000...........7000
6/1/11..Emp Salary.............3000....4000

My application in Visual Basic 2010 and Database SQLserver 2008.

Expecting your answer with sample codes....

Thanks in advance.

[BlackLibrary]

Hard to understand what you want...except that you are overdemanding in tone.

[kadghar]

I agreee with BlackLibrary.

Anyway, why don't you ask google about the SLQClient library?
You might be interested in:
Opening an SqlConnection,
Filling a DataSet using an SqlDataAdapter
Updating your info with an SqlCommandBuild er

[VijaySofist]

Hi,

Check this URL below. This may be helpful to you

http://www.sqldev.org/transactsql/sql-running-totals-subtracting-95189.shtml

Regards
Vijay.R