[Solved] Error converting varchar-Value ‘..’ to int-Datatype

by


Maybe change the data type on the db to an integer of some sort? Why does this differ from your input? Anyway the below should work. You should always make sure you utilize the parameters property within a SqlCommand to avoid SQL injection.

void countVR(int kk)
{
    string selectString = "SELECT COUNT(*) FROM cllohn" + (Jahr % 100).ToString("00") + " WHERE lzVSTR=@KK";
    if (filtsel == selstr)
    {
        using (IDbConnection con = DatabaseFactory.Connect("CL" + (Jahr % 100).ToString("00"), true))
        {
            //con.Open();
            using (IDbCommand cmd = con.CreateCommand())
            {
                cmd.CommandText = selectString;
                SqlParameter sqlParameter = new SqlParameter()
                {
                    Value = kk,
                    ParameterName = "@KK"
                };
                cmd.Parameters.Add(sqlParameter);
                using (IDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        zeilenCount = reader.GetInt32(0);
                        //System.Diagnostics.Debug.WriteLine("Zeilen in " + kk + ": " +zeilenCount);
                    }
                }
            }
        }
    }
}

1

solved Error converting varchar-Value ‘..’ to int-Datatype