C# Tutorial 23: How to use DateTimePicker and save date in Database

[@DrSatti]

Your vision will make a great difference in the C Sharp world for a common programmer. Keep up the good work.

[@wilsonmateo6346]

thanks for the video mate it is not what i was looking for but great (what i am looking for is how to select the information of date from a datagridview, and make the datetimepicker show it) have tried a lot but nothing works

[@DeniseStack]

It is easy to convert the date to the database format by using the Value of the date time object. dobdatettime.Value.ToString("yyyy-MM-dd") This works really well.

[@NabeelHassanein]

In VS C# 2012 Value Does not exists any more so it is done as follows dobdatettime.ToString("yyyy-MM-dd"); Best Regards

[@josi-iwnl-8920]

thank god

[@sahack7322]

عااااااااااالی بود. مرررررررررررررررسی. it's very good. thank you so much sir. good luck.

[@mrj4082]

Thank you. Very helpfull despite being almost 9 years old. Appreciate it man 👍

[@TheJoker0]

Thank you, but I have a question when i try to insert date from Visual Basic Project to SQL Server 2008 with windows 7 I use '" & dateTipePiker.Text & "' it works when I use Windows 8 it don't work I tried '" & dateTipePiker.Value & "' and '" & dateTipePiker.Value.Date & "' and still dosen't work What should I do???

[@سبحاناللهالحمدلله-ش2ر6ث]

Type of field (DOB) date or vchar??

[@aydinyusifov262]

I used datetime. It works

[@eddyquintero91]

hello, What kind of data do you use in the date field of sql server?

[@markelven4641]

same question

[@luiejohnmalimit]

He's using VARCHAR I think, not quite sure tho..

[@chetanajadhav7478]

May be date time

[@AlexMartinez-be2rh]

Thaks very much sir, I was searching for this all day long, MSDN etc. and you have the answer.

[@achibelukwando6986]

learning a lot from your videos and still learning # keep up the good work guy

[@miesen1of4]

Thank you , i this was helpfull for my class lab.

[@kriegswar6733]

thank you sir, you solved my problem here

[@MIKEJMTR]

Not working! just save 0000-00-00 00:00:00:00.000000 "Incorrect date time value "12/11/14 0:00:00' for column "DOB" at row 1

[@shibleekhan101]

What can i do if i am not using the the MySQL server. i am using northwind database sample and i add column of DOB in it. when i use the datetimepicker i got the error massage (string or binary data would be truncated.the statement has been terminated.) Can any one help me? Thanks

[@heraNbUdDHikA]

what is the data type of DOB attribute in the database?

[@ikadoxdell1695]

i also need to know that xD

[@MrCoolbuddy143]

Ikado Xdell Heran Buddhika The data type used in DOB is DATETIME.

[@TamillaS]

thank you very much!!! your tutorials are very useful!!!

[@czajla]

spolier: property Format set Custom, this will activate property CustomFormat

[@snehanaidu5532]

When i click on date timer then my calendar is not showing that years and months why? Just showing today's date and that same format but other years date are missing what should i do? Please answer

[@JunLee000]

how to write code on dateTimePicker if you want to Display selected row from datagridview to TextBox click event dateTimePicker1.Text = row.Cells["dob"].Value.ToString(); it has error if I try to code like this

[@humkobulanayou]

Watch my channel for IT videos

[@naspiroh5152]

Amazing tutorial.. Thanks

[@ashrafzaky]

when i was trying to store the Picked Date it always send 00 month becuse my formate was dd/mm/yyyy, but it fixed when i changed it to dd/MM/yyyy ... why i must wirte MM not mm ? thanks in advance.

[@rushiayyappa165]

how can i view the details again in those textboxes ,considering id as primary key, how to convert it while retrieving it from database?

[@melvindelen2518]

Great tutorial. Thanks. Could you help me saving leap year in a database? Many thanks

[@saurabhbelekar5431]

Thanks bhaii❤🙏

[@mohammadtaghipahlavan940]

ok what if i want to read that date i put in DOB in to my app?

[@sandarusampath7463]

Thanks a lot🔥

[@TormentaJohnny]

somebody knows can i get a function that returns a inner join queery results using tree layer Architecture. I'm developing and studying with Murach Adonet Book, but i can´t find it.

[@saqibsultan9410]

Thnk's very much sir for this tutorial I want to asked one thing how can we add a remainder in c#, for example remainder for the date of birth.

[@emilioibanez4981]

Thankyou this helped a lot

[@nessiraronialvarez1594]

Thank u very much :') you are beatiful programmer

[@bloodymindedchild]

"Date of butt" lol PS : I like your vids, keep doing !!!

[@fabiogoncalves3677]

Hello i am using sql server 2012 so can u tell me what i am suppose to wirite when u write("datasource=localhost;port=3306;username=rot;password=root";) i dont know :3 help

[@NabeelHassanein]

DOB is an abbreviation Date Of Birth and accordingly represent Date field

[@abobakersdeeg]

iwant using datetimepaker in sql server iceart column in db sql server type date in form iused datetime packer values datetimepacker1.text or value is errror

[@fatimashoaib4542]

such an amazing one! helped me a lot thank you so much

[@nerodan1763]

me han servido de mucho tus vídeos gracias, thanks for uploading your knowledge

[@sivakumarsivakumar1304]

the datetimepicker nice example

[@HenryDubon23]

Gracias, saludo desde Honduras

[@diahdwilestari1052]

thank you, this video help me a lot

[@selimsacu6387]

Thank you very mach

[@gdragon448]

what is data type in sql server of date?

[@jchaila_]

Datetime

[@RadhaKrishna_777]

Thank u 😊

[@skybladeyou]

hi may i know how u make the login page?

[@abdallahahmed3981]

please could anybody tell me how to insert date from date and time picker in MS Access DB ?

[@vantastic]

Abdallah Ahmed This is a C# tutorial dude, however I'm familiar with VBA so I can hopefully help you. You need to format the value within DatePicker to suit the destination database requirement. If MySql, then the following code will work: dim MySqlDate as String MySqlDate = format(dtpicker.value,"yyyy-mm-dd HH:nn:ss") 'You can remove the time formats if you just need the date itself. then include that string variable into your SQL string and use the runsql function. Something like: Dim MyQuery as String MyQuery = "INSERT into tablename (datefield) VALUES ('" & MySqlDate & "');" DoCmd.RunSql(MyQuery) Not sure if this is what you're after though.

[@nicador100]

Thanks very much !!!!!!

[@joannamaevillamor4270]

How about the code for radio button?

[@zwggra]

BE CAREFULL WHO EVER DO THIS LOAD DATABASE BUTTON DOESNT WORK WITH DATES YOU MUST USE THIS ON LOAD BUTTON : "server=localhost;User Id=root;password=kalaok123;Persist Security Info=True;database=database; Convert Zero Datetime=True"

[@spaceredx]

Gracias bro

[@heshanvithanage7357]

Thanks :-) It's Work

[@oddswish9524]

Thanks bro.

[@ribvicky]

Use parametrized query :-/

[@abobakersdeeg]

I want a distinguished institute in c# asp.mvc , India. Please detail the title. I will come from outside India

[@kishorkabadi6551]

how to change language of DateTimePicker to Rusian in c#.net

[@EkambaramPalabindela]

Thank You sir....

[@hakanyldz9013]

thanks bro

[@bereshdo]

that's good will be succssed

[@a-maxlee5763]

May I ask that the data type of attribute "DOB" is what? time or nchar(10)? Can any one reply me...Thank you ~~

[@Abhimanyukumar-vb8bz]

yes I have same doubt

[@BrunoSouza-jy4rk]

help a lot !!!

[@kiolerond8926]

can i have a copy of your codes?

[@manigopal]

how to use this in C# in SQL server 2008

[@redcardfordie]

thank u

[@gian-lucanardini9706]

mine is creating multiple names

[@hydrohutechhcm]

i have a problem but it's done now

[@SrVentor]

Thanks !!!!

[@coocoonuut49]

thx so much!!!

[@m0ro0n]

can you send for ,me the source please

[@maran9178]

Awesome

[@guleye]

do something for your fan

[@cameronjordan897]

I lov u

[@wunnell]

Any tutorial that teaches people to use string concatenation rather than parameters when saving to a database is a bad tutorial.

[@youdodle]

abudalalalalalala

[@hebermendozacaballero267]

porque si es aleman el tipo que explica el video, lo programa en inglés, no les basto con perder la guerra? jajaja

[@ishanmadushanka3709]

thank you bro

[@ShadowDared]

thanks you very much