Date time cant insert in database

Question

 hello, i cant insert in database.

if i remove date in insert query its work completely.

 

string query = "insert into income_new(Cid, rs, rate, period, date) values ('" + cid + "','" + txt_Rs.Text.Trim() + "','" + txt_Rate.Text.Trim() + "','" + txt_Period.Text.Trim() + "','" + DateTime.Now + "')";

 

and datatype of date in access database is Date/Time. so...

 

----------

thanks in advance.