Insert date in database by DateTimePicker
Hi to all. If you are new in developing so you have mostly problem to add date in database. so i make code for new beginners. first take one DateTimePicker name it to Dtdate. Set property Format=Short so we get simple date not in long format. Take one button so on click event we save in database. In Button click event. string Dtdate = Dtdate.Value.ToString("yyyy-MM-dd"); Now the string contain date string in "yyyy-MM-dd" format. on save time make query for date. string sQuary="Insert into testTable (Dtdate) Values (#"+Dtdate +"#)" ; Execute this query. In query I use "#" on start and end. that specify this is date. in database date save always in "yyyy-MM-dd" format so i convert in this format. Thanks for read this post