How to retrieve time from mysql database and display in datetimepicker in C#

Question

0.00/5 (No votes)

See more:

mysql table as below

day start_time
1 08:00
2 08:00

I want to display the star_time in datetimepicker and value got updated if the user change time in datetimepicker.

What I have tried:

C#

private void ShowData()
{
    /*retrieve from database*/
    dataTbl = new DataTable();
    DALWorktime dalWorktime = new DALWorktime();
    dataTbl = dalWorktime.GetWorkTime();


    DateTime dt1 = new DateTime(2016, 3, 28, 8, 0, 0);
    MainWT_dtpicker_startDay1.Value = dt1;

Posted 28-Mar-16 6:35am

Member 12421315

Updated 28-Mar-16 16:43pm

VR Karthikeyan

v2

Add a Solution

Comments

VR Karthikeyan 28-Mar-16 13:01pm

What is your front end? WPF or Windows Forms?

Member 12421315 28-Mar-16 13:03pm

Windows Form

VR Karthikeyan 28-Mar-16 13:17pm

Do you want to set datetime dynamically from database in DateTimePicker?

Member 12421315 28-Mar-16 13:30pm

yes

VR Karthikeyan 28-Mar-16 22:43pm

See solution 1

1 solution

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)

VR Karthikeyan · Accepted Answer · 2016-03-28T16:43:00

Hi, just modify your code like following,

C#

dataTbl = new DataTable();
DALWorktime dalWorktime = new DALWorktime();
dataTbl = dalWorktime.GetWorkTime();
//Consider am using start time of Day 1
string StartTime = dataTbl.Rows[0][1].ToString().Trim();
string[] HourAndMinute = StartTime.Split(':');
int Hour = Convert.ToInt32(HourAndMinute[0]);
int Minute = Convert.ToInt32(HourAndMinute[1]);
int Seconds =  0; //default

int Year = DateTime.Now.Year;
int Month = DateTime.Now.Month;
int Day = DateTime.Now.Day;

DateTime dt1 = new DateTime(Year, Month, Day, Hour, Minute, Seconds);
MainWT_dtpicker_startDay1.Value = dt1;