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.