4
Reply

Date time cant insert in database

prince raj

prince raj

Jul 1 2014 6:49 AM
963
 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. 

Answers (4)