Syntax error in UPDATE statement
<p>What is wrong with this code? I did everything but I still get </p>

<blockquote>
  <p>Syntax error in UPDATE statement</p>
</blockquote>

<p>Please help. Thank you in advance.</p>

<pre><code>OleDbConnection conn = default(OleDbConnection);

OleDbCommand cmd = default(OleDbCommand);

conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=DemoDB.accdb");

string sql = "UPDATE APPOINTMENTS Set ([CustomerID]=" + txtCid.Text + ", [DateTime]= " + dateTimePicker5.Text + ", [Time]=" + txtNewTime.Text + " WHERE [CustomerID]=" + txtCid.Text + ");";

conn.Open();

cmd = new OleDbCommand(sql, conn);

cmd.ExecuteNonQuery();//execute the sql command

MessageBox.Show("Appointment Changed Successful");

//close the connectionstring
conn.Close();
</code></pre>