How to do calculations in grid view based on date

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008R2

how to do emi calculation

for ex i have taken loan 50000

for 50000 i have to pay emi monthly 5000 for 10 months

start date is 1st Mar 2015
end date is 1st Dec 2015.

and i have inserted all these values in database those are
Name
TotalAmount
StartDate
EndDate
MonthlyPay

and i have binded these values to grid view also

my problem is , i want to show extra column in grid that is due amount ,when start date is crossed 1 month,show due amount is 5000 , and it crossed
2 months show 10000 and this so on for 10 months and then stop.

can you please suggest me how to do this, or give me any example for emi payment page,
if you want code i will attach

Posted 26-Oct-15 19:54pm

Member 11382784

Add a Solution

Comments

Suvendu Shekhar Giri 27-Oct-15 3:07am

Please share the relevant code, if you have tried anything so far.

2 solutions

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)

Maciej Los · Answer 1 · 2015-10-26T21:17:00

Solution 1

Such as functionality is called running sum[^]. Follow the link to get tons of examples.

Posted 26-Oct-15 21:17pm

Maciej Los

Naveen.Sanagasetti · Answer 2 · 2015-10-26T21:51:00

Solution 2

Apart from the above answer, you can do it like below.

SQL

select Case StartDate 
          When 1 Then 1*MonthlyPay
          When 2 Then 2*MonthlyPay
          When 3 Then 3*MonthlyPay
          When 4 Then 4*MonthlyPay
       End
from tablename

Posted 26-Oct-15 21:51pm

Naveen.Sanagasetti