insert date to sql

Dec 28 2009 7:53 AM
hi all
i am new about in c# and making a small project to improve myself and to learn new things...but as u can imagine i have a problem...i have a datetimepicker in my form and i keep the customer's birthdate with it...but it tries to save the birthdate to database like dd.mm.yyyy...i use sql server 2005 express edition for database and it keeps that data as yyyy.mm.dd so how can i get rid of that problem..i want it to keep data as dd.mm.yyyy...and i keep my data in database as smalldatetime...i dont want to keep it as string because maybe i will make some operations on it later...thanks for your help

Answers (10)