Datetime null 01/01/0001 - Error in selection (Winforms+Layers bll,dal,model) C#

Question

I made a business rule where I pass some information from my service order to my cashier. However when I will perform the search in the box, my date passes 01/01/0001, and the error of characters.

    Public List<Model.caixa> Select()
    {

        List<Model.caixa> ListaCaixa = new List<Model.caixa>();

        SqlConnection conexao = new SqlConnection(strCon);

        string sql = "Select * from caixa;";

        SqlCommand cmd = new SqlCommand(sql, conexao);

        conexao.Open();

        try

        {
            SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            while (reader.Read())
            {
                Model.caixa caixa = new Model.caixa();
                caixa.CodCaixa = Convert.ToInt32(reader[0].ToString());
                caixa.CodSrv = Convert.ToInt32(reader["CodSrv"].ToString());
                caixa.TipoSrv = reader["TipoSrv"].ToString();
                **caixa.DataPagamento = Convert.ToDateTime(reader["DataPagamento"].ToString());**
                caixa.Status = reader["Status"].ToString();
                caixa.Parcelamento = reader["Parcelamento"].ToString();
                caixa.Pagamento = reader["Pagamento"].ToString();
                ListaCaixa.Add(caixa);
            }
        }
        catch
        {
            MessageBox.Show("Deu erro na seleção do caixa!");
        }
        finally
        {
            conexao.Close();
        }
        return ListaCaixa;
    }

When it comes caixa.DataPagamento = Convert.ToDateTime(reader["DataPagamento"].ToString()); already falls for catch.

If anyone can help, I’d be grateful!

Answer 1

Probably your reader["DataPagamento"] is null and you are calling a method from a null instance which causes an exception.

Make this change:

if(reader["DataPagamento"]!=null)
   caixa.DataPagamento = Convert.ToDateTime(reader["DataPagamento"].ToString());