Hi,
I am getting the following error and I cannot understand why.
SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
Before i try and insert the data into the database I print it out and this is what i get: 09/04/2012 00:00:00
The code below is used to insert the data into the database:
DataClassesDataContext db = new DataClassesDataContext();
var departDate = (TextBox)FlightDataView.FindControl("txtDepartDate");
Journey journey = new Journey();
journey.OutboundFlight = DateTime.Parse(departDate.Text);
db.Journeys.InsertOnSubmit(journey);
db.SubmitChanges();
OutboundFlight is set as DateTime in SQL Server 2005 and I am using Visual Studio 2010
If anybody could help me i'd really appreciate it.
Thank you.