关于datetimepicker的问题 [英] question about datetimepicker

问题描述

嗨

我已经为员工插入日常工作（日期+时间）创建表格

工作开始时间是上午8:00

和工作结束时间是18:00 PM

我有两个datetimepicker

datetimepicker1被称为StartTimePicker用于开始时间

datetimepicker2被调用EndTimePicker为结束时间

在StartTimePicker的属性中我设置Format = custom和

自定义格式= 08:00 MM / dd / yyyy

in EndTimePicker的属性我设置了Format = custom和

custom foramt = 18:00 MM / dd / yyyy

我为插入行创建了以下类

hi
I have created form from insert daily job (date + time )for employees
start time for job is 8:00 AM
and end time for job is 18:00 PM
I have two datetimepicker
datetimepicker1 is called StartTimePicker for start time
datetimepicker2 is called EndTimePicker for end time
in properties for StartTimePicker I set Format= custom and
custom format = 08:00 MM/dd/yyyy
in properties for EndTimePicker I set Format = custom and
custom foramt = 18:00 MM/dd/yyyy
I created the following class for insert rows

 public static bool Addtimerow(DateTime starttime, DateTime endtime )
        {
            bool b;
            string strconn = AlShehabi.Properties.Settings.Default.NewSalariesDBConnectionString;
            SqlConnection conn = new SqlConnection(strconn);

            if (conn.State == ConnectionState.Closed)
            {
                conn.Open();
            }

            SqlCommand cmd = new SqlCommand("INSERT INTO JobHours(Worker_ID)            
Select Worker_ID FROM Workers;", conn);
       
            int i = cmd.ExecuteNonQuery();

            if (i <= 0)
                b = false;
            else
                b = true;
            conn.Close();
            return b;
        }

whent btnadd_click事件我想在JobHours表中添加所有工人姓名和工作的开始时间（日期+时间）和工作的结束时间

例如

whent btnadd_click event I want to add in JobHours table all workers names and starttime for job (date +time ) and endtime for job
for example

Mark 3/15/2014 08:00 3/15/2014 18:00 
Jack 3/15/2014 08:00 3/15/2014 18:00 

等

当btnadd_click事件我写的时候

and so on
when btnadd_click event I wrote

private void btnadd_Click(object sender, EventArgs e)
        {
           DateTime Start_Work = StartTimePicker.Value;
            DateTime End_Work = EndTimePicker.Value;
            if (dailyworkerhours.Addtimerow(Start_Work,End_Work))
            gridviewjobhours.EndEdit();
}

代码有效但我的问题是当btnadd_click

工作人员名字被插入到gridview中而没有工作和结束时间的开始时间工作

例如

马克

杰克

如何解决这个问题？

the code works but my problems is when btnadd_click
workers names is inserted in the gridview without starttime for job and endtime for job
for example
Mark
Jack
how to solve this problem?

推荐答案

试用代码

DateTime start1 = starttime.Value;

start1 = new DateTime（start1.Year，start1.Month，start1 .Day）;

DateTime end1 = endtime .Value;

end1 = new DateTime（end1.Year，end1.Month，end1.Day）;



string start = start1.ToString（MM / dd / yyyy）;

string end = end1.ToString（MM / dd / yyyy）;



使用这些Start1和end1值并尝试

try code
DateTime start1 = starttime.Value;
start1 = new DateTime(start1.Year, start1.Month, start1.Day);
DateTime end1 = endtime .Value;
end1 = new DateTime(end1.Year, end1.Month, end1.Day);

string start = start1.ToString("MM/dd/yyyy");
string end = end1.ToString("MM/dd/yyyy");

Use these Start1 and end1 value and try

这篇关于关于datetimepicker的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！