Error making select with start and end date

Question

I need to search the database for a list where it is necessary to filter by the employee, the initial date and the final date. However, when you pass the parameters and enter while, you jump to catch

public List<Nota> BuscarNotas(int funcionarioid, DateTime dataemissaoi, DateTime dataemissaof)
    {
        List<Nota> oNotas = new List<Nota>();
        using (MySqlConnection conexao = ConexaoBD.getInstancia().getConexao())
        {
            try
            {
                conexao.Open();
                MySqlCommand comando = new MySqlCommand();
                comando = conexao.CreateCommand();
                comando.CommandText = @"select * from nota where DataEmissao
                                        between DataEmissaoI = @dataemissaoi
                                        and DataEmissaoF = @dataemissaof 
                                        and FuncionarioID  = @FuncionarioID;";
                comando.Parameters.AddWithValue("FuncionarioID", funcionarioid).ToString();
                comando.Parameters.AddWithValue("DataEmissaoI", dataemissaoi).ToString();
                comando.Parameters.AddWithValue("DataEmissaoF", dataemissaof).ToString();

                MySqlDataReader reader = comando.ExecuteReader();
                while (reader.Read())
                {
                    Nota oNota = new Nota();
                    oNota.NotaID = Convert.ToInt32(reader["NotaID"].ToString());
                    oNota.FuncionarioID = Convert.ToInt32(reader["ClienteID"].ToString());
                    oNota.NumeroNota = reader["NumeroNota"].ToString();
                    oNota.DataEmissao = Convert.ToDateTime(reader["DataEmissao"].ToString());
                    oNota.Status = (Status)Convert.ToInt16(reader["Status"].ToString());
                    if ((reader["DataPagamentoFinal"] != DBNull.Value))
                        oNota.DataPagamentoFinal = Convert.ToDateTime(reader["DataPagamentoFinal"].ToString());
                    if ((reader["ValorPago"] != DBNull.Value))
                        oNota.ValorPago = Convert.ToDecimal(reader["ValorPago"].ToString());
                    if ((reader["Desconto"] != DBNull.Value))
                        oNota.Desconto = Convert.ToDecimal(reader["Desconto"].ToString());

                    oNotas.Add(oNota);
                }
            }
            catch (MySqlException ex)
            {
                throw new Exception(ex.ToString());
            }
            finally
            {
                conexao.Close();
            }
        }
        return oNotas;
    }
}

Can someone help me?

Answer 1

I’m assuming that the datetimepicker is in a windows form application.

You can use: data_Final.Value to obtain a Type object DateTime.

Or if you want the date in string format you can use the example below:

string data = data_Final.Value.ToString("dd-MM-yyyy");