Datetime attribute error in C# saving to Mysql

Question

I am trying to enter in the Mysql database the date of birth of the user, in C# the attribute data_birth is of type DateTime and in Mysql the attribute data_nascimento is of type Date, to insert C# I’m doing so:

DateTime nascimento = Convert.ToDateTime(txNascimento.Text);
bDep.Data_nascimento = nascimento;

Obs:. bDep is the basic class of the dependent

And in the dependent’s data class I’m inserting thus:

public void insertDependente (BDependente bDep) {
      string sql = "INSERT INTO dependente(id_funcionario, nome, grau_parentesco, data_nascimento) ";
             sql += "VALUES ("+bDep.Funcionario.Id_funcionario+", '"+bDep.Nome+"', '"+bDep.Grau_parentesco+"', '"+bDep.Data_nascimento+"')";
            conn.update(sql);
        }

am selecting thus:

string sql = "SELECT id_dependente, id_funcionario, nome, grau_parentesco, data_nascimento ";
       sql += "FROM dependente";
                while (mdr.Read()) {
                    BDependente bDepe = new BDependente();
                    bDepe.Id_dependente      = mdr.GetInt16("id_dependente");
                    bDepe.Funcionario.Id_funcionario = mdr.GetInt16("id_funcionario");
                    bDepe.Nome               = mdr.GetString("nome");
                    bDepe.Grau_parentesco    = mdr.GetString("grau_parentesco");
                    bDepe.Data_nascimento    = mdr.GetDateTime("data_nascimento");
                    lDep.Add(bDepe);
                }

Every time I register a new addict at the bank it appears like this:

The first record was made in Mysql itself, and even so when I search in C# it brings the time and when I search in C# the other dependent, appears this other error:

Answer 1

The problem starts in the recording. That’s not how it’s done. It has a huge security problem in doing this in addition to generating this kind of problem.

From what I understand the error in reading occurs because the write failed.

I’d have to switch to something like this:

var sqlInsert = new SqlCommand(@"Insert into dependente (id_funcionario, nome, grau_parentesco, data_nascimento)
                    VALUES (@id_funcionario, @nome, @grau_parentesco, @data_nascimento)", conn);
sqlInsert.Parameters.AddWithValue("@id_funcionario", bDep.Funcionario.Id_funcionario);
sqlInsert.Parameters.AddWithValue("@nome", bDep.Nome);
sqlInsert.Parameters.AddWithValue("@grau_parentesco", bDep.Grau_parentesco);
sqlInsert.Parameters.AddWithValue("@data_nascimento", bDep.Data_nascimento.ToShortDateString());
sqlInsert.ExecuteNonQuery();

I put in the Github for future reference.

Then you will adapt to your need. And please never try to record this way again.

The ideal would be not to use variables with hungarian notation also.

• ToShortDateString()
• SqlCommand

I’m not a fan of the term attribute, I prefer field.