今天下午调试程序出问题了,sql插入就是错误:原来把插入的datatime值没用单引号括起来
如下:
"insert into rangeResult (api_id,range_ID,yhr_Resulttime) values( "+ myDatatable.Rows[rowN][0] + " ," + range_ID + " ,'" + DateTime.Now + " ')";
今天下午调试程序出问题了,sql插入就是错误:原来把插入的datatime值没用单引号括起来
如下:
"insert into rangeResult (api_id,range_ID,yhr_Resulttime) values( "+ myDatatable.Rows[rowN][0] + " ," + range_ID + " ,'" + DateTime.Now + " ')";