summing columns error

Question

0.00/5 (No votes)

See more:

when i use this code vs shows following error : Specified cast is not valid. with title : InvalidCastExeption was unhandled

 private void TradeLog_Load_1(object sender, EventArgs e)
        {
sqlDataAdapter1.Fill(dataSet11);
decimal allwin;
            decimal win = 0;
            decimal self;

            for (int i = 0; i < DgvLog.Rows.Count; i++)
            {
                self = (decimal)DgvLog.Rows[i].Cells["selfPriceDataGridViewTextBoxColumn"].Value;
                win += self;
            }

            allwin = sum - win;
            label7.Text = win.ToString();
        }

what is incorrect i think it must be work very good. cant find any mistake

Posted 24-Oct-10 6:57am

lester555

Add a Solution

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)

Abhinav S · Answer 1 · 2010-10-24T07:05:00

Solution 1

Try Convert.ToDecimal(DgvLog.Rows[i].Cells["selfPriceDataGridViewTextBoxColumn"].Value); instead.

Convert.ToDecimal will try to parse your string - a cast using decimal (as you have done) is useful when the item being cast is already a number.

Posted 24-Oct-10 7:05am

Abhinav S

Updated 24-Oct-10 7:11am

v2

Comments

lester555 24-Oct-10 14:57pm

its make the same error

Sandeep Mewara · Answer 2 · 2010-10-24T07:11:00

Solution 2

Issue must be here:
self = (decimal)DgvLog.Rows[i].Cells["selfPriceDataGridViewTextBoxColumn"].Value;
A simple use of DEBUGGER must have told you about the line and the reason.

Error simply means that the conversion that you are trying to make is not valid. In above line, you are forcing a conversion (type casting) of some cell value into decimal which is not right.

If you are sure that the value of the cell is of decimal format then you can try:
Convert.ToDecimal(DgvLog.Rows[i].Cells["selfPriceDataGridViewTextBoxColumn"].Value);

Posted 24-Oct-10 7:11am

Sandeep Mewara

Comments

lester555 24-Oct-10 14:58pm

it does not work selfPrice in the sql table is decimal type.

Sandeep Mewara 24-Oct-10 15:44pm

1. Use DEBUGGER and see if and what is the value in 'DgvLog.Rows[i].Cells["selfPriceDataGridViewTextBoxColumn"].Value'
2. Looks like it's not necessary that you convert it into Decimal at frontend. If the cell has valid number then try Convert.ToDouble(DgvLog.Rows[i].Cells["selfPriceDataGridViewTextBoxColumn"].Value);

P.S.: Make sure you have value before conversion.

lester555 24-Oct-10 16:42pm

i have done. In table selfPrice was empty. that was problem

Sandeep Mewara 25-Oct-10 1:33am

Thats what I told you! A valid value for conversion. :)
Good to know its resolved now.