How Do I...How Can I Update The Column?

Question

0.00/5 (No votes)

See more:

AOA!
I want to ask that i am making finance sytem project in C#. I want to update my balance column in databse with respect to entities, for example
I have four columns in my database like this:

account_no        acount_desc        debit    credit      balance
101               furniture           56         0         null
102               furniture            0        46         null

I want to update the balance column first time when debit is 56 then balance will be 56 in second entry when credit is 46 then balance will be (56-46=10) but i want this value in all the balance column of same account desc. How is it possible?
Actually i am making trial balance report. In crystal report i am showing balance with the help of formula but how can i save this balance in database table column?
I want to save the total balance with respect to some entity like furniture in database?

Posted 26-Mar-14 4:56am

Member 10690757

Updated 26-Mar-14 11:39am

Oshtri Deka

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Murugesan22 · Accepted Answer · 2014-03-26T05:13:00

SQL

you should maintain two table

One is main acc and another one is debit and credit table like this tables

 Create table Mainacc(AccNo int identity,AccDesc nvarchar(max),balance float)
 Create table accinvoice(accno int,AccDesc nvarchar(max), debit float,credit float)

 Insert into Mainacc values(1,'furniture',100)

First balance is 100
then
you debit 56 from accno 1

that entry insert to accinvoice table

insert into accinvoice values(1,furniture,56,0)

Update acc set balance=balance-56 where accNo=1

 Second credit 46 from accno 1

that next entry insert to accinvoice table

insert into accinvoice values(1,furniture,0,46)
Update acc set balance=balance+46 where accNo=1