OleDbCommand cmd = new OleDbCommand("UPDATE myTable SET myDate = ? WHERE id = ?",myConn); OleDbParameter p = cmd.Parameters.Add("?myDate",OleDbType.Date); //p.Value = //What should this be?or
OleDbCommand cmd = new OleDbCommand("UPDATE myTable SET myDate = {} WHERE id = 1",myConn);I would rather use parameters if there is a way.