Dataset modifid DateTime rows

  • Thread starter Thread starter Assaf
  • Start date Start date
A

Assaf

Hello all.

Here is my architecutre: I have a sql server data table feeding a
dataset/datatable displayed in a datagrid.
Today I had a very strange error, something like: 'Sql Exception - Date
Overflow'.
Which is strange in of its own.
After i restarted my application, I noticed that all the dates were moved
one day forward!!!

Has anyone else experienced such a problem?

Assaf
 
Are you talking about the dates in the SQL Server table getting moved
forward? Or the data in the DataSet? Was the error when you were
fetching data or attempting to write data back through a DataAdapter?
SQL Server has a more limited range of valid dates than the CLR, so
it's not hard to trigger an exception when manipulating datetime
values.

-Mary
 
Back
Top