Input string was not in a correct format

Question

My C# .NET 2.0 application code looks like this:

 

gridData.Rows[i - 1][Convert.ToInt32(BillDivColumns.salary)]=

                            (Convert.ToInt32(bdmSet.BILLING_DIV_MEMBER_SET_LIST[i - 1].A_SAL_CNS) / 100).ToString("###,###,##0.00");

The input data is 785.
The data is being displayed as 7.00

When trying to edit the field in the application, I get the error msg: "Input string was not in a correct format."

Can you tell me what I'm doing wrong?

Thank you.

Chuck

Answer 1

Dang! We're this close! =)

Good luck on your future projects.

Answer 2

Jan, thank you for the offer to help, but the problem has been reassigned.

Thanks anyway.

Chuck

Answer 3

I could not really tell without more details.

Please post some code especially those related to the gridview.

Could you also post the stack trace of the error? that stack trace would really help in solving your problem

Answer 4

I changed the Int32 to Double. That worked. Thank you.

But, now in the SAVE routine, I'm getting the same error. My code is:

 if (Convert.ToString(gridData.Rows[i - 1][Convert.ToInt32(BillDivColumns.modesal)]) == "H") SaveInput.BILLING_DIV_MEMBER_SET_LIST[i - 1].A_SAL_CNS = Convert.ToInt32(gridData.Rows[i - 1][Convert.ToInt32(BillDivColumns.salary)]) * 100;

I assume the Int32 is causing the problem again. How should this be handled?

 

Answer 5

The problem is with the Convert.ToInt32 function call.

int value / 100 will return an integer value.

that is why 785/100 will return 7 for you instead of 7.85.

replace the Convert.ToInt32 with Convert.ToDouble instead.

Answer 6

No, not currency. I would like the format of  INT 785 to display as 7.85

However, I don't know if this display issue is the cause of the error msg. Do you know?

Thank you.

Answer 7

do you want to format your column as currency?