469,644 Members | 1,696 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,644 developers. It's quick & easy.

Update SQLserver Database Table Column.

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"
Expand|Select|Wrap|Line Numbers
  1. DATE...DETAILS........DEBIT...CREDIT...BALANCE
  2. 1/1/11.Opening Balance.................5000
  3. 1/1/11.Rent payment...........2500.....
  4. 2/1/11.Mobile Bill.............500.....
  5. 3/1/11.Monthly Share...5000............
  6. 6/1/11.Emp Salary.............3000.....
Now my requirement is how to update the Balance column respectively same as "Running Total" method???
Expand|Select|Wrap|Line Numbers
  1. DATE....DETAILS........DEBIT...CREDIT..BALANCE
  2. 1/1/11..Opening Balance................5000
  3. 1/1/11..Rent payment...........2500....2500
  4. 2/1/11..Mobile Bill.............500....2000
  5. 3/1/11..Monthly Share...5000...........7000
  6. 6/1/11..Emp Salary.............3000....4000
  7.  
My application in Visual Basic 2010 and Database SQLserver 2008.

Expecting your answer with sample codes....

Thanks in advance.
Mar 26 '11 #1
3 2062
Hard to understand what you want...except that you are overdemanding in tone.
Mar 26 '11 #2
kadghar
1,295 Expert 1GB
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 SqlCommandBuilder
Mar 27 '11 #3
VijaySofist
107 100+
Hi,

Check this URL below. This may be helpful to you

http://www.sqldev.org/transactsql/sq...ng-95189.shtml

Regards
Vijay.R
Mar 30 '11 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Martin Lucas-Smith | last post: by
3 posts views Thread by Daniel M | last post: by
reply views Thread by =?Utf-8?B?dmlzaHJ1dGg=?= | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.