What is the cause of this error

Question

1.00/5 (3 votes)

See more:

Conversion from string 'Kitchen 41' to type 'Double' is invalid.
..................................................................

Input string was not in a correct format.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.FormatException: Input string was not in a correct format.

Source Error:

Line 518: Dim location As Double = 0
Line 519: For t As Integer = 0 To Datagrid2.Items.Count - 1
Line 520: location += CDbl(Datagrid2.Items(t).Cells(0).Text)
Line 521: Next

What I have tried:

Hello everyone, what is the cause of this error? I am trying to show the location from the datagrid to the label

Posted 15-Oct-23 4:30am

yossef2023

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)

OriginalGriff · Answer 1 · 2023-10-15T04:55:00

Look at the error message: it's pretty clear:

Error

Conversion from string 'Kitchen 41' to type 'Double' is invalid.
..................................................................

Input string was not in a correct format.

Location is a Double but at least one of the cells you are trying to convert contains the text "Kitchen 41" which is not a number at all.

Use the debugger to look at your DataGrid content and determine why you are trying to convert a non-numeric value. The most frequent reason is that it's the wrong column ... but we don't have access to your data so we can't tell exactly what you are trying to do.

Ralf Meier · Answer 2 · 2023-10-15T08:41:00

Solution 2

Because this is the continuation from the other question (https://www.codeproject.com/Questions/5370000/I-want-a-solution-to-this-problem)
Perhaps you should show us per example what your DataGrid contains and what you want to add.

To continue the answer from OG :
What do you think is the sum of "Kitchen 41" and "Bathroom 12" in your opinion ?

Posted 15-Oct-23 8:41am

Ralf Meier

Comments

OriginalGriff 16-Oct-23 1:45am

"Bedroom 53"? :D

Ralf Meier 16-Oct-23 2:57am

👍