put a date in date time picker

Question

0.00/5 (No votes)

See more:

VB

how can i put a date in my datetimepiker from a request sql

Posted 18-Aug-11 0:55am

amineel9

Add a Solution

Comments

Prerak Patel 18-Aug-11 6:58am

Not clear

amineel9 18-Aug-11 6:59am

i take my data from my sql data base and i would to put a date in a date time picjer how can i do it ?

4 solutions

Solution 4

modifparam.DateTimePicker1.Value = dtr.GetDateTime(5).ToShortDateString
that's the solution it's work thks you all :)

Posted 18-Aug-11 1:26am

amineel9

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2011-08-18T00:59:00

Solution 1

Read the value from the database in your usual manner, and set the DateTimePicker Value property:

C#

myDateTimePicker.Value = new DateTime(1994, 11, 17);

Posted 18-Aug-11 0:59am

OriginalGriff

Comments

amineel9 18-Aug-11 7:04am

i test DateTimePicker1.Text = dtr.getdatetime(5) but it does'nt work

OriginalGriff 18-Aug-11 7:10am

Read the answer: myDateTimePicker.Value not myDateTimePicker.Text

Abhinav S · Accepted Answer · 2011-08-18T01:00:00

Solution 2

This[^] may help.

Posted 18-Aug-11 1:00am

Abhinav S

Suresh Suthar · Accepted Answer · 2011-08-18T01:01:00

Solution 3

I think you want to put Date value from your database to DateTimePicker control, if I am not wrong.

You can do this by assigning your Date value to DateTimePicker's Value property like this

VB

DateTimePicker.Value =Convert.ToDateTime(DataRow(0)("date"))

Posted 18-Aug-11 1:01am

Suresh Suthar

Updated 18-Aug-11 1:02am

v2

Comments

amineel9 18-Aug-11 7:17am

but i take a date from a data readre you see?