I cannot enter the Datetime fields in the sql database

Question

I can’t enter in the fields dateCreation and dataRefMovimento in the sql database

     private Contexto contexto;
    public void Inserir(RegCabecalho regCabecalho)
    {       
        var strQuery = "";
        strQuery += " INSERT INTO regCabecalho (tipoReg, dataCriacao,horaCriacao,dataRefMovimento,IDArq,codParceiro
      ,numeroSeq,versaoLayout) ";
      strQuery += string.Format(" VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}') " ,
      regCabecalho.tipoReg, regCabecalho.dataCriacao,
      regCabecalho.horaCriacao, regCabecalho.dataRefMovimento, regCabecalho.IDArq,
      regCabecalho.codParceiro,
      regCabecalho.numeroSeq, regCabecalho.versaoLayout
            );
        using (contexto = new Contexto())
        {
            contexto.ExecutaComando(strQuery);
        }
    }

Answer 1

1. Use any data access library

Entity Framework, Dapper, something, but do not write SQL in hand. Concatenating data in hand in the middle of SQL leaves you open security problems and makes its application difficult to maintain after.

2. Dates not universally represented in databases

You have to deliver dates in the pattern that the database expects, usually a formatted string in a specific way. You are concatenating the data in hand, which generates the date in a string format, but which may not be the format the database is waiting for.

Your computer is probably formatting dates in the day/month/year scheme, but the database is waiting in American format (month/day/year) or in ISO 8601 format.

Create the class below somewhere ...

public static class DateExtensions
{
    public static string ToIso8601Date( this DateTime date )
    {
        return date.ToString( "yyyy-MM-dd" );
    }
}

... and add ToIso8601Date() at the end of regCabecalho.dataCriacao and regCabecalho.dataRefMovimento. See if it works and then comment there.