Q:

Datetimepicker value cannot be stored in Access Database

I am new to MS-Access and C# and I am having a problem in inserting a new record into my database from my DateTimePicker as the c# program is giving the following error:

Insert into statement is not correct.

So I was wondering: how can I solve this problem?
private void btn_insert_Click(object sender, EventArgs e)
{
    try
    {
        connection.Open();
        OleDbCommand command = new OleDbCommand();
        command.Connection = connection;
        command.CommandText = "insert into BP (Name,DateTime,Systolic,Diastolic) VALUES('" + txt_Name.Text + "', '" + dateTimePicker1.Text + "' ," + txt_systolic.Text + "," + txt_diastolic.Text + ");";
        command.ExecuteNonQuery();
        MessageBox.Show("Changes made Succesfully");
        connection.Close();
    }
    catch (Exception ex)
    {
        MessageBox.Show("ERROR " + ex);
    }
    connection.Close();
}

A:

You must pass a properly formatted string expression for your date value and use the correct Access SQL syntax, and Name is reserved word, thus:
command.CommandText = "insert into BP ([Name],DateTime,Systolic,Diastolic) VALUES('" + txt_Name.Text + "', #" + dateTimePicker1.Value.ToString("yyyy'/'MM'/'dd hh':'mm':'ss") + "# ," + txt_systolic.Text + "," + txt_diastolic.Text + ");";

