Datepickerdate to be saved in the database.

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;
      }

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.

Tags: C#