如何从mysql数据库中检索时间并在C＃中的datetimepicker中显示 [英] How to retrieve time from mysql database and display in datetimepicker in C#

问题描述

mysql表格如下



day start_time

1 08:00

2 08:00



如果用户在datetimepicker中更改时间，我想在datetimepicker中显示star_time并更新值。



我尝试过：

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:

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;

推荐答案

您好，只需修改您的代码如下，

Hi, just modify your code like following,

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;

这篇关于如何从mysql数据库中检索时间并在C＃中的datetimepicker中显示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！