Dataset modifid DateTime rows

[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

 

[Mary Chipman [MSFT]]

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