c# 4.0 - object cannot be cast from DBNULL to ther types

Question

I'am using GetOrdinal in my code. the code

mastxtDateEnded_Edit.Text =
        Convert.ToDateTime(cursor.GetValue(cursor.GetOrdinal("DateEnded")))
               .ToString("MM/dd/yyyy"));

Error: object cannot be cast from DBNULL to ther types.   

Answer 1

You can use the IsDBNull method to check for the null value:

int index = cursor.GetOrdinal("DateEnded")
mastxtDateEnded_Edit.Text =
  cursor.IsDBNull(index) ?
    String.Empty :
    ((DateTime)(cursor.GetValue(index))).ToString("MM/dd/yyyy");