Conversion failed to convert varchar 'No' value to tinyint data type

Question

I am trying to solve a patch error of converting a variable created by me to store data that is in an Excel sheet.

The error happens when I try to insert the data that is in this variable in SQL Server, ie in (query).

code:

variable declaration:

string valmoradafiscaligualmoradalocal = "";

information search code:

case 47://coluna 21

if (((WS.Cells[linha, Contcoluna] as Excel.Range).Value) != null)
{
    valmoradafiscaligualmoradalocal = Convert.ToString((WS.Cells[linha, Contcoluna] as Excel.Range).Value);  
}
continue;

insert code in sql server:

cmd.CommandText = "INSERT tabela_sacc (Morada_Fiscal_Igual_a_Morada_Local) VALUES ('" + valmoradafiscaligualmoradalocal.ToString() + "')";

connection.Open();
cmd.Connection = connection;
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
connection.Close();
valgrupo = null;

Answer 1

Buddy, good afternoon

if the value you are trying to enter is an integer, try to remove the simple quotes from your code

    cmd.CommandText = "INSERT tabela_sacc (Morada_Fiscal_Igual_a_Morada_Local) VALUES (" + valmoradafiscaligualmoradalocal + ")";

the recommending would be you use the sqlparameter https://msdn.microsoft.com/pt-br/library/system.data.sqlclient.sqlparameter(v=vs.110). aspx where you define what type of table

hope I’ve helped

Answer 2

Friend, try to make your code using sql Parameter, follow example

 var serverName = "LAPTOP-EVEJOG4C";
        var databaseName = "MyDatabase";
        var dataString = "Não";
        using (SqlConnection conn = new SqlConnection($"Server={serverName};Database={databaseName};Trusted_Connection=True;"))
        {
            conn.Open();
            string sql = "insert Example01 (DadoTinyInt) values (@DadoTinyInt)";

            using (SqlCommand cmd = new SqlCommand(sql, conn))
            {
                cmd.Parameters.Add("@DadoTinyInt", System.Data.SqlDbType.TinyInt).Value =
                    dataString == "Não" ? 0 : 1;
                cmd.ExecuteNonQuery();
            }
        }