How to resolve problem of getting "input string was not in a correct format" as output in C# console application

Question

0.00/5 (No votes)

See more:

, +

I haven't used any

C#

Console.WriteLine

to display the text i.e.: "Input string was not in a correct format" :( . I am trying to get data from database and save it in a double 2D array. One row in each array entry. This is my code :

C#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;

namespace Outliers2010_Console
{
    class Program
    {
        static void Main(string[] args)
        {            
            try
            {               
                double[][] rawData = new double[20][];           
                
                string con = @"Data Source=Kitty-PC\SQLEXPRESS;Initial Catalog=kitty12;Integrated Security=True";
                SqlConnection sql = new SqlConnection(con);
                string cms = "SELECT TOP 20 * FROM churn_or"; 
                SqlCommand cmd = new SqlCommand(cms, sql);               
                sql.Open();
                SqlDataReader dt = cmd.ExecuteReader();               
                int i = 0;

                //populating array
                if (dt.HasRows)
                {
                    Console.WriteLine(" datareader has rows ");
                    while (dt.Read())
                    { 
                        Console.WriteLine("read from dt") 
                      
                        rawData[i] = new double[] { Convert.ToDouble(dt[0]), Convert.ToDouble(dt[1]), Convert.ToDouble(dt[2]), Convert.ToDouble(dt[3]), Convert.ToDouble(dt[4]), Convert.ToDouble(dt[5]), Convert.ToDouble(dt[6]), Convert.ToDouble(dt[7]), Convert.ToDouble(dt[8]), Convert.ToDouble(dt[9]), Convert.ToDouble(dt[10]), Convert.ToDouble(dt[11]), Convert.ToDouble(dt[12]), Convert.ToDouble(dt[13]), Convert.ToDouble(dt[14]), Convert.ToDouble(dt[15]), Convert.ToDouble(dt[16]), Convert.ToDouble(dt[17]), Convert.ToDouble(dt[18]), Convert.ToDouble(dt[19]), Convert.ToDouble(dt[20]), Convert.ToDouble(dt[21]), Convert.ToDouble(dt[22]), Convert.ToDouble(dt[23]), Convert.ToDouble(dt[24]), Convert.ToDouble(dt[25]), Convert.ToDouble(dt[26]), Convert.ToDouble(dt[27]), Convert.ToDouble(dt[28]), Convert.ToDouble(dt[29]), Convert.ToDouble(dt[30]), Convert.ToDouble(dt[31]), Convert.ToDouble(dt[32]), Convert.ToDouble(dt[33]), Convert.ToDouble(dt[34]), Convert.ToDouble(dt[35]), Convert.ToDouble(dt[36]), Convert.ToDouble(dt[37]), Convert.ToDouble(dt[38]), Convert.ToDouble(dt[39]), Convert.ToDouble(dt[40]), Convert.ToDouble(dt[41]), Convert.ToDouble(dt[42]), Convert.ToDouble(dt[43]), Convert.ToDouble(dt[44]), Convert.ToDouble(dt[45]), Convert.ToDouble(dt[46]), Convert.ToDouble(dt[47]), Convert.ToDouble(dt[48]), Convert.ToDouble(dt[49]), Convert.ToDouble(dt[50]), Convert.ToDouble(dt[51]), Convert.ToDouble(dt[52]), Convert.ToDouble(dt[53]), Convert.ToDouble(dt[54]), Convert.ToDouble(dt[55]), Convert.ToDouble(dt[56]), Convert.ToDouble(dt[57]), Convert.ToDouble(dt[58]), Convert.ToDouble(dt[59]), Convert.ToDouble(dt[60]), Convert.ToDouble(dt[61]), Convert.ToDouble(dt[62]), Convert.ToDouble(dt[63]), Convert.ToDouble(dt[64]), Convert.ToDouble(dt[65]), Convert.ToDouble(dt[66]), Convert.ToDouble(dt[67]), Convert.ToDouble(dt[68]), Convert.ToDouble(dt[69]), Convert.ToDouble(dt[70]), Convert.ToDouble(dt[71]), Convert.ToDouble(dt[72]), Convert.ToDouble(dt[73]), Convert.ToDouble(dt[74]), Convert.ToDouble(dt[75]), Convert.ToDouble(dt[76]), Convert.ToDouble(dt[77]), Convert.ToDouble(dt[78]), Convert.ToDouble(dt[79]), Convert.ToDouble(dt[80]), Convert.ToDouble(dt[81]), Convert.ToDouble(dt[82]), Convert.ToDouble(dt[83]), Convert.ToDouble(dt[84]), Convert.ToDouble(dt[85]), Convert.ToDouble(dt[86]), Convert.ToDouble(dt[87]), Convert.ToDouble(dt[88]), Convert.ToDouble(dt[89]), Convert.ToDouble(dt[90]), Convert.ToDouble(dt[91]), Convert.ToDouble(dt[92]), Convert.ToDouble(dt[93]), Convert.ToDouble(dt[94]), Convert.ToDouble(dt[95]), Convert.ToDouble(dt[96]), Convert.ToDouble(dt[97]), Convert.ToDouble(dt[98]), Convert.ToDouble(dt[99]), Convert.ToDouble(dt[100]), Convert.ToDouble(dt[101]), Convert.ToDouble(dt[102]), Convert.ToDouble(dt[103]), Convert.ToDouble(dt[104]), Convert.ToDouble(dt[105]), Convert.ToDouble(dt[106]), Convert.ToDouble(dt[107]), Convert.ToDouble(dt[108]), Convert.ToDouble(dt[109]), Convert.ToDouble(dt[110]), Convert.ToDouble(dt[111]), Convert.ToDouble(dt[112]), Convert.ToDouble(dt[113]), Convert.ToDouble(dt[114]), Convert.ToDouble(dt[115]), Convert.ToDouble(dt[116]), Convert.ToDouble(dt[117]), Convert.ToDouble(dt[118]), Convert.ToDouble(dt[119]), Convert.ToDouble(dt[120]), Convert.ToDouble(dt[121]), Convert.ToDouble(dt[122]), Convert.ToDouble(dt[123]), Convert.ToDouble(dt[124]), Convert.ToDouble(dt[125]), Convert.ToDouble(dt[126]), Convert.ToDouble(dt[127]), Convert.ToDouble(dt[128]), Convert.ToDouble(dt[129]), Convert.ToDouble(dt[130]), Convert.ToDouble(dt[131]), Convert.ToDouble(dt[132]), Convert.ToDouble(dt[133]), Convert.ToDouble(dt[134]), Convert.ToDouble(dt[135]), Convert.ToDouble(dt[136]), Convert.ToDouble(dt[137]), Convert.ToDouble(dt[138]), Convert.ToDouble(dt[139]), Convert.ToDouble(dt[140]), Convert.ToDouble(dt[141]), Convert.ToDouble(dt[142]), Convert.ToDouble(dt[143]), Convert.ToDouble(dt[144]), Convert.ToDouble(dt[145]), Convert.ToDouble(dt[146]), Convert.ToDouble(dt[147]), Convert.ToDouble(dt[148]), Convert.ToDouble(dt[149]), Convert.ToDouble(dt[150]), Convert.ToDouble(dt[151]), Convert.ToDouble(dt[152]), Convert.ToDouble(dt[153]), Convert.ToDouble(dt[154]), Convert.ToDouble(dt[155]), Convert.ToDouble(dt[156]), Convert.ToDouble(dt[157]), Convert.ToDouble(dt[158]), Convert.ToDouble(dt[159]), Convert.ToDouble(dt[160]), Convert.ToDouble(dt[161]), Convert.ToDouble(dt[162]), Convert.ToDouble(dt[163]), Convert.ToDouble(dt[164]), Convert.ToDouble(dt[165]), Convert.ToDouble(dt[166]), Convert.ToDouble(dt[167]), Convert.ToDouble(dt[168]), Convert.ToDouble(dt[169]), Convert.ToDouble(dt[170]), Convert.ToDouble(dt[171]), Convert.ToDouble(dt[172]) };
                        Console.WriteLine(rawData[i]);
                                                                                                        i++;      
                    }
                }
                sql.Close();
	}
	catch()
	{}
     }
   }
}

I am not getting any error nor exception nor even a message, but in output instead of getting value of rawData which I need to be printed, I am getting
"Input string was not in a correct format" :sigh: .

What I have tried:

I have extensively googled and even tried the suggestions :confused: but all are talking about exceptions
and errors which are not solving my issue. haven't found any content like that :((

Posted 2-Apr-16 2:49am

KittoKy

Updated 2-Apr-16 3:23am

Add a Solution

Comments

Sascha Lefèvre 2-Apr-16 9:01am

Don't cross-post.
You already got an answer to your question here:
Input string was not in a correct format as output in c# console application - C# Discussion Boards - CodeProject[^]

If you don't understand how to follow the instructions in the answer, reply to it and ask for clarification.

CHill60 2-Apr-16 9:08am

I think this is the link you meant to post:
Input string was not in a correct format as output in c# console application - C# Discussion Boards - CodeProject[^]

Sascha Lefèvre 2-Apr-16 9:10am

Indeed! Fixed, thank you :)

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)

CHill60 · Answer 1 · 2016-04-02T03:23:00

KittoKy wrote:
but all are talking about exceptions and errors which are not solving my issue

Your code is throwing an exception (error) and that text is the message associated with it. It is appearing as "output" from your program because it is a Console program.

You have been told how to find the problem by OriginalGriff on your other post.

As an aside, this is an awful way to populate the array - at the very least use a for loop if not Linq.