DateTime from SQL database with value null

Question

I want to get datetime from SQL database and store it in a DateTime property. At the moment it has value null. I keep getting conversion error. Programming in C# with MVVM.

private void LoadFunctie()
    {
        _myModel = new ObservableCollection<myModel>();
        DataTable DT = new DataTable();
        DT = 
        clsDAC.ExecuteDataTable(Properties.Resources.S_myStoredProcedure);
        foreach (DataRow DR in DT.Rows)
        {
            var x = new clsOrderOverzichtM()
            {
                SomeID = (int)DR[0],//works
                SomeString = DR[1].ToString(),//works
                SomeDate = (DateTime)DR[2]//ERROR

            };
            _myModel.Add(x);
        }
    }

My Property

    private DateTime? _SomeDate;
    public DateTime? SomeDate
    {
        get { return _SomeDate; }
        set
        {
            _SomeDate = value;
            RaisePropertyChanged();
        }
    }

What could be my problem?

Igor · Accepted Answer · 2017-06-07 18:30:53Z

1

If the column allows null values then you have to check for DBNull when you read from it. The easiest way to do this on a DataRow is with IsNull. The line of code would then be:

SomeDate = DR.IsNull(2) ? null : (DateTime?)DR[2]

The assignment type you are using should then also be nullable or have an acceptable default value.

answered Jun 7, 2017 at 18:30

Igor

62.5k10 gold badges111 silver badges181 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

DateTime from SQL database with value null

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related