xml存入dataset问题
--------------------编程问答-------------------- http://www.alixixi.com/web/a/2008050848800.shtml --------------------编程问答-------------------- 可以Update指定節點 --------------------编程问答-------------------- strSql.AppendLine(" if EXISTS(SELECT USER_ID ");strSql.AppendLine(" FROM CMDB_User_Setting ");
strSql.AppendLine(" WHERE Personal_Setting.exist('/Root/Personal_Setting/Page_Size')=1 AND User_Id='" + strUser_Id + "') ");
strSql.AppendLine(" UPDATE CMDB_User_Setting ");
strSql.AppendLine(" SET Personal_Setting.modify('replace value of (/Root/Personal_Setting/Page_Size/text())[1] with \"" + strPage_Size + "\"') ");
strSql.AppendLine(" WHERE User_Id= '" + strUser_Id + "' ");
strSql.AppendLine(" ELSE ");
strSql.AppendLine(" UPDATE CMDB_User_Setting ");
strSql.AppendLine(" SET Personal_Setting.modify(' ");
strSql.AppendLine(" insert <Page_Size>" + strPage_Size + "</Page_Size> ");
strSql.AppendLine(" into (/Root/Personal_Setting)[1]') ");
strSql.AppendLine(" WHERE Personal_Setting.exist('/Root/Personal_Setting')=1 AND User_Id='" + strUser_Id + "' ");
补充:.NET技术 , C#