Êý¾Ý¿âÅúÁ¿¸üУ¬Ìí¼Ó£¡ÓйØXMLµÄ²Ù×÷
µÃµ½Ò»¸öÐèÒª´¦ÀíµÄXMl
private string GetSaveItem()
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml("<menuCollection/>");
foreach (TreeNode node in trvAccessRight.CheckedNodes)
{
if (node != trvAccessRight.Nodes[0])
{
XmlElement content = xmlDoc.CreateElement("menuItem");
content.SetAttribute("menuID", node.Value);
xmlDoc.DocumentElement.AppendChild(content);
}
}
return xmlDoc.OuterXml;
}
½«ÒÔÉϵĻñµÃµÄXMl×Ö·û´®µ±²ÎÊý´«Èë´æ´¢¹ý³ÌÖУ¬
´æ´¢ÈçÏÂд
ALTER PROCEDURE [dbo].[usp_UserGroup_SetRight]
(@GroupID INT ,@ChangedBy VARCHAR(50) ,@MenuXml XML)
AS
BEGIN
--SET XACT_ABORT ON
BEGIN TRY
BEGIN TRANSACTION
--delete
DELETE
from tbl_SysUserGroupRight
WHERE GroupId = @GroupID
--insert
INSERT INTO tbl_SysUserGroupRight
(
GroupId
,MenuID
,ChangedBy
,ChangedOn
)
SELECT @GroupID
,menuList.row.value(N'@menuID' ,'VARCHAR(50)') AS MenuID
,@ChangedBy
,GETDATE()
from @MenuXml.nodes('/menuCollection/menuItem') AS menuList(row)
COMMIT TRANSACTION
RETURN 1
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION
RETURN 0
END CATCH
¸üпÉÒÔ½è¼øÉÏÃæµÄÌí¼Ó²Ù×÷£¬
Ïà¹ØÎĵµ£º
VC½âÎöXML--ʹÓÃCMarkupÀà½âÎöXML
(Ò») ÏȽ²Ò»ÏÂXMLÖеÄÎïÊâ×Ö·û£¬ÊÖ¶¯ÌîдʱעÒâһϡ£
×Ö·û ×Ö·ûʵÌå
& &nb ......
Ô´xmlÎļþ
<?xml version="1.0" encoding="iso-8859-1"?>
<books>
<stock>
<name>The Picasso Code</name>
<author>Dan Blue</author>
<category>Fiction</category>
<description>Cubist paintings reveal a secret society of people ......
~/ ÔÚrunat=serverµÄ¿Ø¼þÖУ¬×Ô¶¯µÄ±»½âÎöΪRequest.ApplicationPathµÄÖµ£¬Êǵ±Ç°Ó¦ÓóÌÐò¼¶³ÌÐòµÄĿ¼ ÔÚÀý×ÓÖÐÊÇ£º/WebSite
./»òÕßʲô¶¼²»Ð´£º±íʾµ± ......
DOMÊÇ»ùÓÚÆ½Ì¨¡¢ÓïÑÔÎ޹صĹٷ½W3C±ê×¼¡£»ùÓÚÊ÷µÄ²ã´Î£¬ÆäÓŵãÊÇ¿ÉÒÔÒÆÖ²£¬±à³ÌÈÝÒ×£¬¿ª·¢ÈËÔ±Ö»ÐèÒªµ÷Óý¨Ê÷µÄÖ¸Áî¡£ÆäȱµãÊǼÓÔØ´óÎļþ²»ÀíÏë¡£
¡¡¡¡SAXÊÇ»ùÓÚʼþÄ£Ð͵ģ¬ËüÔÚ½âÎö XML ÎĵµµÄʱºò¿ÉÒÔ´¥·¢Ò»ÏµÁеÄʼþ£¬µ±·¢ÏÖ¸ø¶¨µÄtagµÄʱºò£¬Ëü¿ÉÒÔ¼¤»îÒ»¸ö»Øµ÷·½·¨£¬¸æË߸÷½·¨Öƶ¨µÄ±êÇ©ÒѾÕÒµ½¡£ÀàËÆÓëÁ÷ýÌåµÄ½ ......
1. »ù´¡£º¶ÔXML½øÐмòµ¥µÄ²éѯ, ²åÈë, ɾ³ý, ±à¼²Ù×÷
ÔÚÊý¾ÝÁ¿²»ÊǺܴóµÄÇé¿öÏ£¬¿ÉÒÔÓÃxml´úÌæÊý¾Ý¿â´æ´¢Êý¾Ý£¬µ«ÊÇÒª¶¨ÒåxsdÎļþÀ´ÑéÖ¤xmlÎļþ£¬±£Ö¤xmlÊý¾Ý¸ñʽ¡£
ÒÔÏÂÍøÒ³½éÉÜÁËÈçºÎÀûÓÃC#ʵÏÖxmlµÄ²éѯ£¬²åÈ룬ɾ³ýºÍ¸üвÙ×÷£¬Õâ±íÃ÷xml¿ÉÒÔ´úÌæÊý¾Ý¿â´æ´¢Ò»¶¨Á¿µÄÊý¾Ý¡£
http://blog.csdn.net/cmoonc/archive/20 ......