我现在用C#向数据库里新增记录,
CADOConn m_ado = new CADOConn();
m_ado.Open();
// 获取当前时间
System.DateTime now = new System.DateTime();
now = System.DateTime.Now;
String sql = "INSERT INTO Process (ID,PID,YINGXIANGMINGCHENG,CPU,NeiCun,LUJING,JILUSHIJIAN_P) VALUES(WLWSYS.S_Process.NEXTVAL, '" + pInfo[i].ProcessID.ToString() + "','" + pInfo[i].ProcessName + "','" + pInfo[i].ProcessorTime.ToString() + "','" + pInfo[i].WorkingSet + "','" + pInfo[i].ProcessPath + "','" + now.ToString() + "')";
m_ado.ExecuteSQL(sql);
m_ado.Close();
//////////////
不知道哪里出错,就是写不进出,然后抛出异常,说缺失逗号。
CADOConn m_ado = new CADOConn();
m_ado.Open();
// 获取当前时间
System.DateTime now = new System.DateTime();
now = System.DateTime.Now;
String sql = "INSERT INTO Process (ID,PID,YINGXIANGMINGCHENG,CPU,NeiCun,LUJING,JILUSHIJIAN_P) VALUES(WLWSYS.S_Process.NEXTVAL, '" + pInfo[i].ProcessID.ToString() + "','" + pInfo[i].ProcessName + "','" + pInfo[i].ProcessorTime.ToString() + "','" + pInfo[i].WorkingSet + "','" + pInfo[i].ProcessPath + "','" + now.ToString() + "')";
m_ado.ExecuteSQL(sql);
m_ado.Close();
//////////////
不知道哪里出错,就是写不进出,然后抛出异常,说缺失逗号。
第一个插入值没有引上"'+WLWSYS.S_Process.NEXTVAL+'"