Datepickerdate将保存在数据库中。 [英] Datepickerdate to be saved in the database.

问题描述

我有两个日期时间选择器，命名如下;

dt_startweek和dt_endweek为两个datetimepicker。





当我在dt_endweek选择器中点击dt_startweek选择器21ddate，在第5天26日显示在dt_endweek。



代码如下;

i have two date time picker named as follows;
dt_startweek and dt_endweek as two datetimepicker.


when i click the dt_startweek picker 21stdate in the dt_endweek picker five days 26th date to be displayed in the dt_endweek.

for that code as follows;

private void dt_startweek_ValueChanged(object sender, EventArgs e)
{
        DateTime dt = dt_startweek.Value;
        dt=dt.AddDays(5.0);
        dt_endweek.Value = dt;
        DateTime startdate = dt_startweek.Value;
        DateTime enddate = dt_endweek.Value;
      }

以上代码工作正常没问题。





then我有一个名为load的按钮，当我点击加载按钮时，datepicker日期将在数据库中保存5天。



将日期保存到数据库中。如何编写代码保存到数据库中。



帮助我。



日期基础设计为跟随;



Fac_sch_date日期时间（数据类型）



输出我想在表中如下;



21/1/2013

22/1/2013

23/1/2013

24/1/2013

25/1/2013

26/1/2013





当我点击加载按钮时，上述日期将保存在数据库中。



我在dt_startweek中选择的日期该日期保存在数据库中。



请帮助我。

the above code is working fine no problem.


then i have one button called load when i click the load button that datepicker date 5 days to be saved in the data base.

for that saving the date into the database.how can i write code to save in the database.

help me.

Date base design as follows;

Fac_sch_date Date time (Data type)

output i want in the table as follows;

21/1/2013
22/1/2013
23/1/2013
24/1/2013
25/1/2013
26/1/2013


the above date to be saved in the data base when i click the load button.

what date i choose in the dt_startweek that date to be saved in the database.

please help me.

推荐答案

为什么不使用升oop，当你想做事件插入数据库时​​，

是这样的：

why not use the loop, when you want to do event Insert into database,
like this :

protected void Button1_Click(object sender, EventArgs e)
        {
            var dtime = dt_startweek.Value;
            var data = new ArrayList();
            for (var i = 0; i < 6; i++)
            {
                var xx = dtime.AddDays(i);
                data.Add(xx);
                // do for insert into database in here,can too..
            }
// OR
//Your first capacity in each variable, then enter one of the database into your
            var x1 = data[0];// date 21 from arraylist index [0]
            var x2 = data[1];// date 22
            var x3 = data[2];// date 23
            var x4 = data[3];// date 24
            var x5 = data[4];// date 25
            var x6 = data[5];// date 26

  // OR Like This

            var d1 = dtime;
            var d2 = dtime.AddDays(1);
            var d3 = dtime.AddDays(2);
            var d4 = dtime.AddDays(3);
            var d5 = dtime.AddDays(4);
            var d6 = dtime.AddDays(5);

        }

这个寓言只是示例代码..它只是作为前缀铺平道路的前缀她的逻辑，与你的编码相关

This parable is only sample code it .. just as a prefix to pave the way forward her your logic, associated with your coding

这篇关于Datepickerdate将保存在数据库中。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！