4
Answers

Date time cant insert in database

prince raj

prince raj

10y
1k
1
 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)
0
Govinda Rajulu Yemineni

Govinda Rajulu Yemineni

NA 1.5k 233.1k 9y
Hi Amit,
 
please refer the following URL
 
http://forums.asp.net/t/1787686.aspx?How+to+post+a+xml+value+to+web+api+ 
0
Amit Joshi

Amit Joshi

NA 100 11k 9y
Any reference links?