°ïÎÒ¿´¿´Õâ¸öSQLÓï¾ä

C# code:
insert into dom_data_value(COMPANYID,USENO,DATANO,datatime)values('" + companyid + "','" + System.Convert.ToString(n_useno) + "','" + Stemp + "',to_date('" + date + "','yyyy-mm-dd hh24:mi:ss'))";

Ä¿Ç°Õâ¸öSQLÖ»Ö§³ÖORCALCE
ÈçºÎ
Ð޸ijÉACCESS£¬ SQL SERVER ÓõÄÓ¦¸Ã·Ö±ðÔõôд

---

String.Format(
"insert into  dom_data_value(COMPANYID,USENO,DATANO,datatime)
value('{0}','{1}','{2}','{3}'",companyid ,n_useno,Stemp,DateTime.Now.ToShortDateString())

---

"insert into  dom_data_value(COMPANYID,USENO,DATANO,datatime) values('" + companyid + "','" + System.Convert.ToString(n_useno) + "','" + Stemp + "','" + date + "')";
DateTime.Parse(date);
»òString.Format

---

µ¥ÒýºÅºÍË«ÒýºÅ»»Ò»Ï¾ÍÓ¦¸Ã¿ÉÒÔÁË£¡£¡

---

insert into  dom_data_value(COMPANYID,USENO,DATANO,datatime)values("'"+companyid + "','" + System.Convert.ToString(n_useno) + "','" + Stemp + "',to_date('" + date + "','yyyy-mm-dd hh24:mi:ss'))";

---

ÒýÓÃ

µ¥ÒýºÅºÍË«ÒýºÅ»»Ò»Ï¾ÍÓ¦¸Ã¿ÉÒÔÁË£¡£¡

¡£¡£¡£Õâ¸öSQLûÓÐÎÊÌâ Ô