110,545
社区成员
发帖
与我相关
我的任务
分享
foreach (DataRow dr in objDataset1.Tables[0].Rows)
{
DataRow nwdr=tempData.Tables[0].NewRow();
nwdr["DQ_NUM"]=dr["DQ_NUM"];
nwdr["DQ_NAME"] = dr["DQ_NAME"];
nwdr["DQ_TEXT"] = dr["DQ_TEXT"];
tempData.Tables[0].Rows.Add(nwdr);
}
"DELETE FROM DUMMY_DOMAIN WHERE ((DQ_NUM = :p1) AND ((:p2 = 1 AND DQ_NAME IS NULL) OR (DQ_NAME = :p3)) AND ((:p4 = 1 AND DQ_TEXT IS NULL) OR (DQ_TEXT = :p5)))"
"UPDATE DUMMY_DOMAIN SET DQ_NUM = :p1, DQ_NAME = :p2, DQ_TEXT = :p3 WHERE ((DQ_NUM = :p4) AND ((:p5 = 1 AND DQ_NAME IS NULL) OR (DQ_NAME = :p6)) AND ((:p7 = 1 AND DQ_TEXT IS NULL) OR (DQ_TEXT = :p8)))"
"INSERT INTO DUMMY_DOMAIN (DQ_NUM, DQ_NAME, DQ_TEXT) VALUES (:p1, :p2, :p3)"