Changing DateTimeMode using SQLDataReader

Question

Does anyone know whether it is possible to change the DateTimeMode when using a DataReader. All the examples, as below, I can find use a DataTable.

SqlCommand command = new SqlCommand("SELECT EmployeeID, FullName, DateCreated,           DateAppointment FROM [Employees] ...", connection);
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataTable result = new DataTable();
adapter.FillSchema(result, SchemaType.Source);
result.Columns["DateCreated"].DateTimeMode = DataSetDateTime.Utc;
result.Columns["DateAppointment"].DateTimeMode = DataSetDateTime.Utc;
adapter.Fill(result);
return result;

Would I be better going to a DataTable? Any pointers much appreciated.

Remus Rusanu · Accepted Answer · 2009-08-26 02:40:38Z

2

If your question is whether you can avoid setting the UTC mode explicitly every time, then you should use a strongly typed data set and set the mode in the designer.

answered Aug 26, 2009 at 2:40

Remus Rusanu

296k42 gold badges459 silver badges583 bronze badges

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

1 Comment

Chin Over a year ago

Thanks, I very rarely use VS so was just hoping for a way of making sure I got UTC dates back via an existing method call to the db.

Collectives™ on Stack Overflow

Changing DateTimeMode using SQLDataReader

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related