I have a datetimepicker which reads a date as dd-mm-yyyy. the sql im using(sql server 2008) is only reading mm-dd-yyyy. i am having a problem with changing the format of how the date is saved. i put a catch to the code and this came up
System.Data.OleDb.OleDbException: Conversion failed when converting date and/or time from character string.
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at WindowsFormsApplication1.Customer.Add() in C:\Users\Neville\Desktop\ThunderBolt Technologies Ltd\ThunderBolt Technologies Ltd\Customer.cs:line 53
when i run the program the date is represented as follows: 20/3/2011 but i want the month to come first... is this coming from sql server settings? i am using Visual C# 2008 Express Edition
P.S. i could help some fast respnses as this is an assignment for two months and this is just the start... :/ thanks again