Closing Balance how can get it next month opening

Question

1.00/5 (1 vote)

See more:

C#

Dear sir

please tell me how can get closing balance in next Day or Month of opening for eg 19-May-2014 closing Balance is 500 rs then i want to Display it next DAY or Month Opening Balance. I m using asp.net and Database is SQL 2005.Please take the code with output

Thanks

Er. Praveen Sharma

Posted 19-May-14 21:47pm

Member 10554297

Add a Solution

Comments

Richard MacCutchan 20-May-14 4:03am

The closing balance on one day is the opening balance on the next day.

Thanks7872 20-May-14 4:55am

:laugh:

Member 10554297 20-May-14 5:24am

The closing balance on one day is the opening balance on the next day.
YES
BUT i dont know how can solve this problem please give me a demo that means code and its output .please help me
thanks
Praveen Sharma

Richard MacCutchan 20-May-14 5:34am

Demo, code for what? We have no idea what your code does, what your database looks like or in fact what you are trying to calculate.

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)

Ravi Shankar Dokka · Accepted Answer · 2014-05-19T22:48:00

Solution 1

Create a trigger at database level to update the opening balance after updating the closing balance.

Posted 19-May-14 22:48pm

Ravi Shankar Dokka

Comments

irfanansari 1-Mar-16 1:51am

how to create a trigger ?

irfanansari 26-Sep-19 7:56am

please tell complete process then i will be able to clear my mind how