Posted on: 6/26/2014 11:48:42 AM | Views : 411

I am using Visual Basic 2010 and SQL Server 2005 Express and having a terrible time setting several date values. The DataGridView is dragged to the form from the data source and custom format set to MMM-d-yyyy. I have tried   database fields, set to DateTime and SmallDateTime, with no success.
In the past several days I think I have tried so many combinations of data types( that I can't remember them all so I'll pose this as one questions. The most common error(which makes no sense to me is a message saying the data exceeds the field size.
What is the best database format and property to use to save my data, which will be displayed to the user in a DateTimePicker control with my desired format.
sirmilt

Go to the complete details ...