Reading a datetime value from a SQL database

Question

How can I read datetime fields from a SQL database?

This is not working:

emp.DateFacturation = (DateTime)(dr["DateFacturation"])

nor is this:

emp.DateFacturation = DateTime.Parse(dr["DateFacturation"].toString());

Answer 1

Since you've commented a now deleted answer with:

dr is a DataReader

You can use SqlDataReader.GetDateTime. You should check first if the value is DBNull with DataReader.IsDBNull:

DateTime dateFacturation;
int colIndex = dr.GetOrdinal("DateFacturation");
if(!dr.IsDBNull( colIndex ))
    dateFacturation = dr.GetDateTime( colIndex );

I use GetOrdinal to get the column index of the column name to pass it to GetDateTime.