Datepickerdate to be saved in the database.

Question

3.00/5 (1 vote)

See more:

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;

C#

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.

Posted 29-Jan-13 3:12am

Member 8054539

Updated 29-Jan-13 3:16am

CHill60

v2

Add a Solution

Comments

[no name] 29-Jan-13 9:27am

Dnt forget to say thanx who help u buddy.. its easy to copy n paste soln which u got frm smeone else...

[no name] 29-Jan-13 11:29am

ok thanks.how to save the date time picker date in database when i click the button.

please help me.
Rgds & thanks
narasiman

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)

chester_it21 · Answer 1 · 2013-01-29T08:10:00

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

C#

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