C# Tutorial 23: How to use DateTimePicker and save date in Database
Vložit
- čas přidán 7. 09. 2024
- ★★★Top Online Courses From ProgrammingKnowledge ★★★
Python Programming Course ➡️ bit.ly/2vsuMaS ⚫️ bit.ly/2GOaeQB
Java Programming Course ➡️ bit.ly/2GEfQMf ⚫️ bit.ly/2Vvjy4a
Bash Shell Scripting Course ➡️ bit.ly/2DBVF0C ⚫️ bit.ly/2UM06vF
Linux Command Line Tutorials ➡️ bit.ly/2IXuil0 ⚫️ bit.ly/2IXukt8
C Programming Course ➡️ bit.ly/2GQCiD1 ⚫️ bit.ly/2ZGN6ej
C++ Programming Course ➡️ bit.ly/2V4oEVJ ⚫️ bit.ly/2XMvqMs
PHP Programming Course ➡️ bit.ly/2XP71WH ⚫️ bit.ly/2vs3od6
Android Development Course ➡️ bit.ly/2UHih5H ⚫️ bit.ly/2IMhVci
C# Programming Course ➡️ bit.ly/2Vr7HEl ⚫️ bit.ly/2W6RXTU
JavaFx Programming Course ➡️ bit.ly/2XMvZWA ⚫️ bit.ly/2V2CoAi
NodeJs Programming Course ➡️ bit.ly/2GPg7gA ⚫️ bit.ly/2GQYTQ2
Jenkins Course For Developers and DevOps ➡️ bit.ly/2Wd4l4W ⚫️ bit.ly/2J1B1ug
Scala Programming Tutorial Course ➡️ bit.ly/2PysyA4 ⚫️ bit.ly/2PCaVj2
Bootstrap Responsive Web Design Tutorial ➡️ bit.ly/2DFQ2yC ⚫️ bit.ly/2VoJWwH
MongoDB Tutorial Course ➡️ bit.ly/2LaCJfP ⚫️ bit.ly/2WaI7Ap
QT C++ GUI Tutorial For Beginners ➡️ bit.ly/2vwqHSZ
★★★ Online Courses to learn ★★★
Get 2 FREE Months of Unlimited Classes from skillshare - skillshare.eqc...
Data Science - bit.ly/2lD9h5L | bit.ly/2lI8wIl
Machine Learning - bit.ly/2WGGQpb | bit.ly/2GghLXX
Artificial Intelligence - bit.ly/2lYqaYx | bit.ly/2NmaPya
MERN Stack E-Degree Program - bit.ly/2kx2NFe | bit.ly/2lWj4no
DevOps E-degree - bit.ly/2k1PwUQ | bit.ly/2k8Ypfy
Data Analytics with R - bit.ly/2lBKqz8 | bit.ly/2lAjos3
AWS Certification Training - bit.ly/2kmLtTu | bit.ly/2lAkQL1
Projects in Java - bit.ly/2kzn25d | bit.ly/2lBMffs
Machine Learning With TensorFlow - bit.ly/2m1z3AF | bit.ly/2lBMhnA
Angular 8 - Complete Essential Guide - bit.ly/2lYvYRP
Kotlin Android Development Masterclass - bit.ly/2GcblsI
Learn iOS Programming Building Advance Projects - bit.ly/2kyX7ue
★★★ Follow ★★★
My Website - www.codebind.com
DISCLAIMER: This video and description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. This help support the channel and allows us to continue to make videos like this. Thank you for the support!
Visual C# .NET Controls The Date Time Picker - Date Picker
C# - How do I set my datetimepicker date?
visual C# - DateTimePicker date to string C#
How to compare the time of a DateTimePicker control and the
How do I get value from Date time picker and Month calendar C#
How to pass values to a dateTimePicker control C#
How to change DateTimePicker control to 24h time format ?
Getting started with the DateTimePicker
Visual Studio 2012 RC - Age calculation from
Converting date time picker value into t_time type
date time picker - 7 posts
DateTimePicker - Visual C#
assign SYSTEMTIME to DateTimePicker Control C#
Your vision will make a great difference in the C Sharp world for a common programmer. Keep up the good work.
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
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???
Type of field (DOB) date or vchar??
I used datetime. It works
Thank you. Very helpfull despite being almost 9 years old. Appreciate it man 👍
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.
In VS C# 2012 Value Does not exists any more so it is done as follows
dobdatettime.ToString("yyyy-MM-dd");
Best Regards
thank god
spolier: property Format set Custom, this will activate property CustomFormat
عااااااااااالی بود. مرررررررررررررررسی.
it's very good. thank you so much sir. good luck.
Thaks very much sir, I was searching for this all day long, MSDN etc. and you have the answer.
"Date of butt" lol
PS : I like your vids, keep doing !!!
thank you sir, you solved my problem here
learning a lot from your videos and still learning # keep up the good work guy
thank you very much!!! your tutorials are very useful!!!
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.
Thank you , i this was helpfull for my class lab.
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
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
how can i view the details again in those textboxes ,considering id as primary key,
how to convert it while retrieving it from database?
Amazing tutorial.. Thanks
the datetimepicker nice example
Thankyou this helped a lot
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.
Thank u very much :') you are beatiful programmer
hello, What kind of data do you use in the date field of sql server?
same question
He's using VARCHAR I think, not quite sure tho..
May be date time
me han servido de mucho tus vídeos gracias, thanks for uploading your knowledge
such an amazing one! helped me a lot thank you so much
ok what if i want to read that date i put in DOB in to my app?
thank you bro
thank you, this video help me a lot
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
Watch my channel for IT videos
DOB is an abbreviation Date Of Birth and accordingly represent Date field
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.
Great tutorial. Thanks. Could you help me saving leap year in a database? Many thanks
thanks you very much
what is the data type of DOB attribute in the database?
i also need to know that xD
Ikado Xdell Heran Buddhika The data type used in DOB is DATETIME.
Thanks bhaii❤🙏
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
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
Gracias, saludo desde Honduras
Thanks a lot🔥
Gracias bro
Thanks :-) It's Work
Thanks very much !!!!!!
Thanks bro.
Thank u 😊
Thank You sir....
hi may i know how u make the login page?
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
that's good will be succssed
what is data type in sql server of date?
Datetime
thank u
How about the code for radio button?
help a lot !!!
Thanks !!!!
I want a distinguished institute in c# asp.mvc , India. Please detail the title. I will come from outside India
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"
please could anybody tell me how to insert date from date and time picker in MS Access DB ?
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.
how to change language of DateTimePicker to Rusian in c#.net
Use parametrized query :-/
thx so much!!!
Awesome
May I ask that the data type of attribute "DOB" is what? time or nchar(10)?
Can any one reply me...Thank you
~~
yes I have same doubt
i have a problem but it's done now
do something for your fan
how to use this in C# in SQL server 2008
I lov u
can i have a copy of your codes?
mine is creating multiple names
can you send for ,me the source please
Any tutorial that teaches people to use string concatenation rather than parameters when saving to a database is a bad tutorial.
abudalalalalalala
porque si es aleman el tipo que explica el video, lo programa en inglés, no les basto con perder la guerra? jajaja
Thank you very mach
thanks bro