How to set condition when calculate in datagridview

Question

0.00/5 (No votes)

See more:

Hello everyone , I have a question need your help .

Question :

I have a datagridview have 5 columns like this

Quantity Prices TotalAmount Discount TotalAmountAfterDiscount

The expression is :

TotalAmount = Quantity * Prices
TotalAmountAfterDiscount = TotalAmount * Discount/100 ( Problem here !!!)

If Discount = 0% the expression will go wrong . So i want set condition here if values of Discount cells equal 0 we will have other expression TotalAmountAfterDiscount = TotalAmount

Please help me solve this problem . Thanks you a lot

@note : I'm using DataColumnName.Expression to calculate and datagridview datasource is bound to temp table which created by code because i want to calculate all values after that insert all of it to database

Posted 21-Jun-13 5:17am

Anhduc Mai

Add a Solution

2 solutions

Solution 1

Looks to me like your formula for the total amount after discount is incorrect. What you're calculating with TotalAmount * Discount/100 is the amount of the discount, not the total amount after discount, which would be total amount - discount amount, right? Fix your formula and you fix your problem.

Posted 21-Jun-13 5:25am

Marc A. Brown

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)

OriginalGriff · Accepted Answer · 2013-06-21T05:29:00

You do realize that that expression won't work anyway?

Price = 100
Quantity = 10
TotalAmount = P * Q = 1000
Discount = 25%
TotalAmountAfterDiscount = (P * Q) * D / 100 = 1000 * 25 / 100 = 250

What you actually want is:

Price = 100
Quantity = 10
TotalAmount = P * Q = 1000
Discount = 25%
TotalAmountAfterDiscount = (P * Q) - ((P * Q) * D / 100) = 1000 - (1000 * 25 / 100) = 1000 - 250 = 750

So change your TotalAmountAfterDiscount calculation, and 0% discount will work fine.