in c# when i write a query to update there occurs an error "Syntex Error in UPDATE query"
my code is as
- string query="UPDATE Employee_Table StartTime='"+txt_StartTime.Text+"',EndTime='"+txt_endTime.Text+"'where id="+txt_id.Text+";";
where Employee_Table is a table in Acces
the field StartTime is of date/time data types and EndTime is also date/time.
where is the syntax eror in my query................it is urgent please help me to solve this. Thanks