MySQL VB.NET Tutorial 19 : How to use DateTimePicker and save date in Database

[@kitezopo2593]

If you encountered and null exception cannot convert MySqlDate/Time value to System.Date.Time just change your database birthdate/DOB column datatype to TEXT instead of DATE/DATETIME.

[@NotFound-wc7ym]

you're a life saver man!.. keep it up!...

[@GhassanYousif]

Dear Sir i thank you so much you are a life saver.

[@abdullateifa9981]

Great job, although I found some mistakes in your code for the query's but it's easy to solve. Thanks a lot and please keep going.

[@yassmine3284]

Thank you so much for this video I am jassmine from marrocco , i am very hapy to watch your videos and complete your convesation

[@rhyndaryll6790]

thank u :D from Philippines!

[@Gandula83]

Hello, I would like to thank you for this tutorial, it has been very useful for me in the realization of my applications. I would ask one thing: after adding a "DateTimePicker" within my form I chose to set the date format in this way "dd/mm/yyyy hh:mm:ss" so that the user using the program sees this format when entering the date information. The problem occurs when I go to enter the date in my MYSQL database because the only accepted date format is "yyyy-MM-dd HH:mm:ss". Can you show me correct syntax to include in my query so that the date format of "DateTimePicker" is converted to the correct one? Thanks in advance

[@ProgrammingKnowledge]

[@nalsminator]

Thank you for your sharing, help me a lot with this of saving Date in MySQL.

[@Sahikhduty]

Really thanks bro ☺️

[@mariocalcetin7602]

Thank you very much my friend, it helped me a lot Greetings from Chile

[@MrChum]

the answer that I need! thank you!

[@foxayaan7160]

Pro trick: you can watch series at flixzone. I've been using them for watching loads of movies recently.

[@kodybaker8499]

@Fox Ayaan yup, I have been using flixzone for since november myself =)

[@jesushenrik8631]

@Fox Ayaan definitely, I've been using Flixzone for months myself :D

[@fadhilmauladhani8155]

Thank you, it solved my problem

[@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 I am using Visual Basic 2010 What should I do???

[@misbcc4639]

wrong spelling man

[@linewenterprises6050]

i have something to ask, how to retrieve the date from the database and pass it into datetimepicker for update purposes. for example the expiration date i want to change it using datetimepicker.

[@linewenterprises6050]

hi thanks for the tutorial its very helpful.

[@jirridi]

This one really help. Thankyou.

[@prylldmyg1193]

Why do I keep getting an error "Unable to convert MySQL date/time value to System.DateTime". please help

[@rylai0219]

How to show the date in the datetimepicker when datagridview is clicked?

[@guilhermeterra1100]

is there a way to deploy the program now to use in another computer?

[@review476]

Hallo how to I use datetimepicker with timer control... I have students to be move from one class to another after every academic year

[@auraarzadun9127]

hi, can you have MySQL visual basic.net tutorial the topics are using PrintDialogBox you can also have the capabilties to choose printers installed, Save DialogBox have the capabilities of saving ms word file to the database. also have the find and replace Ms Word using vb.net any Ms Word starting 2003 to 2016 versions. urgent needed tutorial. thanks hopefully for your favorable reply.

[@nicador100]

Thanks very much !!!!!

[@princessmaepanes7696]

Guys i need help. After i used this code. The delete button doesnt work anymore. How will i fix this?

[@Ishunrzb]

sir kindly make some video for networking programing like socket server code in vb

[@women_kingdom]

😘😘😘😘thank youuuuu

[@juanabad1252]

Como hago para guardar un datos sexo con dos radio button en visual basic 2010 y sql 2008 rb1 ombre rb2 mujer

[@snowdecember26]

Hi, do you know how to add image to table or datagrid ? thanks :D

[@harry250007]

Hello sir i want to know that how to convert 01-01-2017 as first January two thousand seventeen.

[@makubexmeg]

Thanks Sir! God bless!!!!!!!!!!!

[@jasonburn4161]

how to compute date using datetimepicker? pls help

[@yeshacroe9354]

How to search T_T in datagrid for datetime picker

[@yosifpharmapro6768]

I have question How to convert date to integer in vb.net

[@enlabodeguita]

thank you

[@alktab8993]

Thank 🌹

[@PabloMartinez-te7ey]

very good contribution would like me to do a tutorial to update.

[@MrAliWest]

Thanks sir !

[@luigicalvelo6857]

thank you so much !

[@timothymurauzi5144]

Thanks man

[@misbcc4639]

unable to convert string error

[@OMEDIT-1990]

Time ?

[@misbcc4639]

source code needed please

[@prylldmyg1193]

Why do I keep getting an error "Unable to convert MySQL date/time value to System.DateTime". please help

[@NK34Player]

to fix this problem change it to text in phpmyadmin then it must work :)