当前位置:编程学习 > C#/ASP.NET >>

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#
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,