update datetimepicker

[mrijet]

Hi, can anyone help me to guide on how to update using datetimepicker?

Here is my sql syntax :-

UPDATE table set Date='" + datetimepicker1.Text + "' WHERE ID='" + ID.Text + "';

After I run the message prompat said Syntax Missing..

ASAP me if got solution

[Ali Saleem]

1. Add a timer to your form.

2. Set timer interval to 1000 (milliseconds)

3. Set Enabled property to True

4. Update the DateTimePicker value in the Tick event of the timer as below

 private void timer1_Tick(object sender, EventArgs e)
        {
            dateTimePicker1.Value = DateTime.Now; 
        }

[adriancs]

I assumed that the value of dateTimePicker1.Value is something like this (MM-dd-yyyy):

12-23-2015

Then you can get the datetime value like this

string[] sa = dateTimePicker1.Value.Split('-');
int month = Convert.ToInt(sa[0]);
int day = Convert.ToInt(sa[1]);
int year = Convert.ToInt(sa[2]);
DateTime dateTime1 = new DateTime(year, month, day);
string datestr = dateTime1.ToString("yyyy-MM-dd HH:mm:ss");
int id = Convert.ToInt(ID.Text);
 
string sql = string.Format("UPDATE table set `Date`='{0}' WHERE ID={1};",
datestr, id);