Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Êý¾Ý¿âÅúÁ¿¸üУ¬Ìí¼Ó£¡ÓйØ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 
¸üпÉÒÔ½è¼øÉÏÃæµÄÌí¼Ó²Ù×÷£¬ 


Ïà¹ØÎĵµ£º

XMLÖеķǷ¨×Ö·û¼°¹ýÂË·½·¨

xmlÖÐÓÐÒÔÏÂ×Ö·û²»ÄܳöÏÖ£¬·ñÔò£¬xml½«²»Äܱ»ÕýÈ·½âÎö£º
&><'
Èç¹ûÔÚxmlÖгöÏÖÁË·Ç·¨×Ö·ûÄØ±ØÐ뽫Æä¹ýÂ˵ô£¡¹ýÂ˵ķ½·¨ºÜ¼òµ¥£¬Ìæ»»¾Í¿ÉÒÔÁË£º
ÀýÈçÔÚphp xml_parser_create ÖУ¬¾Í¿ÉÒÔÕâô×ö£º
$parser = xml_parser_create(); //´´½¨Ò»¸öparser±à¼­Æ÷
xml_set_element_handler($parser, "startElement", " ......

VC½âÎöXML ʹÓÃCMarkupÀà½âÎöXML

VC½âÎöXML--ʹÓÃCMarkupÀà½âÎöXML
(Ò») ÏȽ²Ò»ÏÂXMLÖеÄÎïÊâ×Ö·û£¬ÊÖ¶¯ÌîдʱעÒâһϡ£
×Ö·û                   ×Ö·ûʵÌå
&              &nb ......

C#²Ù×÷xmlÎļþÈëÃÅ(ºó¸½Ê¾ÀýÔ´´úÂë)

          ~/    ÔÚrunat=serverµÄ¿Ø¼þÖУ¬×Ô¶¯µÄ±»½âÎöΪRequest.ApplicationPathµÄÖµ£¬Êǵ±Ç°Ó¦ÓóÌÐò¼¶³ÌÐòµÄĿ¼     ÔÚÀý×ÓÖÐÊÇ£º/WebSite
          ./»òÕßʲô¶¼²»Ð´£º±íʾµ± ......

»ùÓÚXMLµÄWeb·Ö²¼Ê½Êý¾Ý½»»»¼¼Êõ

Ò»¡¢WDDXµÄ²úÉú
    WDDX£¬Ó¢ÎÄÈ«³ÆÎªWeb Distributed Data
Exchange£¬ÊÇÒ»ÖÖ»ùÓÚXMLµÄWeb·Ö²¼Ê½Êý¾Ý½»»»¼¼Êõ¡£WDDX×îÔçÊÇÃÀ¹úAllaire¹«Ë¾µÄ³ÌÐò¼¼ÊõÉè¼ÆÊ¦Simeon
SimeonovΪÁ˽â¾öColdFusionÖÐÉæ¼°µ½µÄ·Ö²¼¼ÆËãÎÊÌâ¶ø½¨Á¢µÄ¡£Ëæ×ʤ×÷µÄ¿ªÕ¹£¬WDDXÖð½¥Ñݱä³ÉΪһÖÖ¿ÉÓÃÓÚ²»Í¬µÄÓ¦Óû·¾³Öн»»»¸´ÔӵĽṹ ......

SQL 2005ÖÐÓÃXML nodes()º¯ÊýÈ¡´úOPENXML

SQL Server 2005ΪXMLÌṩ±¾µØÖ§³Ö;ÏÖÔÚ¿ÉÒÔÔÚOPENXML½ÚµãÖÐʹÓÃÒ»¸ö´øÓÐnodes()º¯ÊýµÄXML×Ö¶ÎÀàÐͰÑÒ»¸öXMLÎļþת»¯ÎªÒ»¸öÐм¯¡£ÈÃÎÒÃÇÀ´¿´Ò»¸öʹÓÃOPENXMLµÄ¼òµ¥Àý×Ó£¬²¢ÏÔʾÈçºÎ°ÑËüת»¯ÎªÔÚSQL Server 2005ÖÐʹÓÃXML×Ö¶ÎÀàÐͺÍnodes()º¯Êý¡£
¡¡¡¡ÎªÁËʹÎÒÃǵÄÀý×Ó¼òµ¥»¯£¬ÎÒÃǽ«¼ÙÉèÎÒÃÇÐèÒªÖ´ÐÐijÖÖ»ùÓڲɹº¶©µ¥ÁÐ±íµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ