I haven't used any
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 :
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;
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 :((