C#: Cannot cast DBNull.Value to type 'System.DateTime'. Please use a nullable type.

Today I got "Cannot cast DBNull.Value to type 'System.DateTime'. Please use a nullable type." error in the C# application. After my trace, it is caused by this line:

DateTime? moveOutDate = dt.Rows[0].Field("MoveOutDate");

You should make it as:

DateTime? moveOutDate = dt.Rows[0].Field("MoveOutDate");

Comments

Anonymous said…
Thanks for this, it looked like quite an imposing error until i found your post :-)
October 24, 2012 at 9:08 AM
J R Bishnoi said…
but crystal report don't support Nullable variable, any solution..
June 3, 2013 at 2:00 AM
Post a Comment

Popular posts from this blog

Post packing slip of sales order in X++

SalesFormletter SalesFormletter; SalesTable SalesTable; ; SalesFormletter = SalesFormletter::construct(DocumentStatus::Confirmation,true); SalesTable.clear(); SalesTable = SalesTable::find(_salesId); SalesFormletter.update(SalesTable, systemDateGet(), SalesUpdate::All, AccountOrder::None, false, false);
Read more