0 however you take Column name "Date".
date is a reserved keyword.
You need to use square brackets around it to use in a query.
-------------------------------
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 + "')";-------------------------------
If it is possible, I strongly suggest to change these names because you will have this problem everytime you hit this table.
Access 2007 reserved words and symbols
http://office.microsoft.com/en-us/access-help/access-2007-reserved-words-and-symbols-HA010030643.aspx Accepted 0 Thanks
Vasu Gadhiya
its my fault to use keyword as Column name.
0 Hi prince ,
You can try to insert DateTime.Today instead of DateTime.Now
0 I think you need to check with the format of datetime that your are inserting