Xamarin SqlConnection throwing error Input string was not in correct format

Question

Im trying to connect my mobile to PC database using this code:

            string cString = @"Persist Security Info=False;Integrated Security=false;Initial Catalog=myDB;server=192.168.1.11,1433\SqlExpress";
            SqlConnection connection = new SqlConnection(cString);
            connection.Open();
            using (SqlCommand cmd = new SqlCommand("SELECT name1 FROM Product", connection))
            {
                using (SqlDataReader rdr = cmd.ExecuteReader())
                {
                    while (rdr.Read())
                    {
                        t.Text += rdr.GetString(rdr.GetOrdinal("name1")) + System.Environment.NewLine;
                    }
                }
            }

Unfortunately I'm getting error: "Input string was not in the correcr format", source: mscorlib.

I know that there's error in connectionString (throwin exception after connection.Open())

Any ideas? Thanks in advance!

Answer 1

your current Culture is not in correct format

    protected override void OnResume()
    {
        base.OnResume();

        //Here you would read it from where ever.
        var userSelectedCulture = new CultureInfo("en-US");
        Thread.CurrentThread.CurrentCulture = userSelectedCulture;
    }