How can I transport datagridview data to jagged array

Question

1.00/5 (1 vote)

See more:

Hi, I am trying to transport datagridview data to jagged array for some reason but I couldn't succeed

the error is:

An unhandled exception of type 'System.FormatException' occurred in mscorlib.dll

Additional information: The input line was not in the correct format.

my datagridview data is like;

|0.35|1.58|0.82|1.78|0.85|1.55|1|0|0|}

What I have tried:

C#

string linex= "";
string[] correction= null;
for (int i=0;i<= rowcount-1;i++)
{
                
    for (int j=0;j<= colmcount-1;j++)
    {
        linex= linex.ToString()+" " + dataGridView1.Rows[i].Cells[j].Value.ToString();
    }
    correction= linex.Split(',');
    rowdataexample[i] = new double[columncnt];
    for (int k = 0; k <= colmcount-1; k++)
    {
        rowdataexample[i][k] = double.Parse(correction[k]);

    }
    correction= null;
    linex= "";
}

Posted 10-Apr-17 4:07am

ser_khan

Updated 10-Apr-17 18:40pm

CHill60

v4

Add a Solution

Comments

[no name] 10-Apr-17 10:17am

Obviously whatever correction[k] is can't be converted to a double. Which makes total sense when you are splitting your string by comma and using a space character as your delimiter. And you should be using TryParse anyway.

ser_khan 10-Apr-17 15:39pm

nope, it doesn't work, i tried it before.

[no name] 10-Apr-17 16:24pm

Well "it doesn't work" only means something to you. WHAT doesn't work? What did you see when you debugged your code?

ser_khan 10-Apr-17 16:43pm

my data became just like this correction[0]==>0.35 1.58 0.82 1.78 0.85 1.55 1 0 0

[no name] 10-Apr-17 17:12pm

Yes ... AND? You are splitting your string on a comma. Where is the COMMA in that string?

ser_khan 10-Apr-17 15:49pm

its became very annoying, why jagged array dont except correction array's content.

ZurdoDev 10-Apr-17 11:08am

This is such a simple thing for you to fix if you use the debugger. You'll see exactly what is happening.

ser_khan 10-Apr-17 15:42pm

i saw, but whatever i've tried it didn't work
my data became just like this correction[0]==>0.35 1.58 0.82 1.78 0.85 1.55 1 0 0

1 solution

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)

Karthik_Mahalingam · Answer 1 · 2017-04-10T18:40:00

Solution 1

add comma to this

linex= linex.ToString()+"," + dataGridView1.Rows[i].Cells[j].Value.ToString();

Note:
use Double.TryParse Method (System)[^] for converting string to double
use String.Trim Method (System)[^] to avoid unwanted space in the beginning and end of the string.

Posted 10-Apr-17 18:40pm

Karthik_Mahalingam