²Ù×÷XML£¬¶ÔXMLµÄÔöɾ¸Ä²é²Ù×÷¡£asp.net C#
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Xml;
namespace jiufen.Web.code
{
public class OperatingXML
{
XmlDocument xmlDoc = new XmlDocument();
//load xml file
private void LoadXml()
{
xmlDoc = new XmlDocument();
xmlDoc.Load(HttpContext.Current.Server.MapPath("xml/User.xml"));//xmlµÄ¸ùĿ¼
}
//Ìí¼Ó½Úµã
public void AddElement()
{
LoadXml();
XmlNode xmldocSelect = xmlDoc.SelectSingleNode("user");
XmlElement el = xmlDoc.CreateElement("person"); //Ìí¼Óperson½Úµã
el.SetAttribute("name", "ÖܽÜÂ×"); //Ìí¼Óperson½ÚµãµÄÊôÐÔ"name"
el.SetAttribute("sex", "ÄÐ"); //Ìí¼Óperson½ÚµãµÄÊôÐÔ "sex"
el.SetAttribute("age", "52"); //Ìí¼Óperson½ÚµãµÄÊôÐÔ "age"
XmlElement xesub1 = xmlDoc.CreateElement("pass"); //Ìí¼Óperson½ÚµãµÄÀïµÄ½Úµã
xesub1.InnerText = "22";//ÉèÖÃÎı¾½Úµã
el.AppendChild(xesub1);
XmlElement xesub2 = xmlDoc.CreateElement("Address");
xesub2.InnerText = "À¥Ã÷";//ÉèÖÃÎı¾½Úµã
el.AppendChild(xesub2);
xmldocSelect.AppendChild(el);
xmlDoc.Save(HttpContext.Current.Server.MapPath("xml/User.xml"));
}
//Ð޸Ľڵã
public void UpdateElement()
{
LoadXml();
XmlNodeList nodeList = xmlDoc.SelectSingleNode("user").ChildNodes;//»ñÈ¡bookstore½ÚµãµÄËùÓÐ×Ó½Úµã
foreach (XmlNode xn in nodeList)//±éÀúËùÓÐ×Ó½Úµã
{
XmlElement xe = (XmlElement)xn;//½«×Ó½ÚµãÀàÐÍת»»ÎªXmlElementÀàÐÍ
if (xe.GetAttribute("name") == "ÖܽÜÂ×")//Èç¹ûnameÊôÐÔÖ
Ïà¹ØÎĵµ£º
Èç¹û¶Ô½çÃæÃÀ¹Û³ÌÐò±È½Ï¸ß£¬ÊÖд´úÂëÊDz»¿É±ÜÃâµÄ¡£
µ«Èç¹û×öµÄÊÇһЩÏñÖ»ÊÇΪÁËÏÔʾ¡¢¿ØÖÆÖ®ÀàµÄ³ÌÐò£¬¿ÉÄܸü¿ìµÄ°Ñ³ÌÐòµ·¹Ä³öÀ´¾ÍºÃÁË¡£
wxwidgetsÓÐÕâÑùµÄÒ»¸ö¹¦ÄÜ£¬¾ÍÊÇÄÜÓÃxmlд³É½çÃæ¾ÍÄÜÏÔʾ
±à¼xrcµÄ¹¤¾ßÊÇwxformbuilder,¿ªÔ´Ãâ·ÑµÄ£¬Ò²×ã¹»ÓÃÁË£¬ÎÒÒ»¿ªÊ¼Ã»ÕÒµ½ÔõôÉú³Éxrc,ºóÀ´Ä³´ÎżȻ¿´µ½ÁËÏÂÃæ....ÔÀ´ÓÐc ......
±¾ÎĽéÉÜASP.NET´íÎó´¦Àí£¬ÒÔ¼°½éÉÜÈç¹ûÄúµÄÓ¦ÓóÌÐòÊÔͼµÇ¼Êý¾Ý¿âʱûÓгɹ¦£¬ÔòÏÔʾµÄ´íÎóÐÅÏ¢²»Ó¦¸Ã°üÀ¨ËüÕýÔÚʹÓõÄÓû§Ãû¡£
Òª´´½¨Ò³ÖеÄÈ«¾Ö´¦Àí³ÌÐò£¬Çë´´½¨ Page_Error ʼþµÄ´¦Àí³ÌÐò¡£Òª´´½¨ASP.NETÓ¦ÓóÌÐò·¶Î§µÄ´íÎó´¦Àí³ÌÐò£¬ÇëÔÚ Global.asax ÎļþÖн«´úÂëÌí¼Óµ½ Application_Error ·½·¨¡£Ö»ÒªÄúµÄÒ³»òÓ¦ ......
ʹÓÃVS2005¹¤¾ßXSD.exe(SDK\v2.0\Bin\xsd.exe)×Ô¶¯Éú³ÉʵÌåÀࣺ
xsd /c /namespace:myCompany /language:CS temp1.xsd
Ò²¿ÉÒÔÉú³ÉDataSetÀàÐ͵ÄÀà:
xsd /dataset /language:CS temp1.xsd
( ÀàÎļþºÍXSDÖ®¼ä¿ÉÒÔÏ໥ת»»£¬Ò²¾ÍÊÇ˵£¬ÄãÒ²¿ÉÒÔÏÈÉú³ÉÀ࣬Ȼºó×Ô¶¯Éú³ÉXSD)
×Ô¶¯¶ÁÈ¡XMLÊý¾Ý ......
/*
Êý¾Ý¿â²éѯXML½á¹¹£¬FOR XML PATH Óï¾äµÄÓ¦ÓÃ
*/
FOR XML PATH Óï¾äµÄÓ¦ÓÃ:
CREATE TABLE TempTable(UserID int , UserName nvarchar(50));
insert into TempTable (UserID,UserName) values (1,'a')
insert into TempTable (UserID,UserName) values (2,'b')
select UserID,UserName from TempTable FOR ......
Integration with the XML Data Type
With the introduction of the XML data type, we wanted to also give FOR XML the ability to generate an instance of XML directly (more precisely, it generates a single row, single column rowset where the cell contains the XML data type instance).
Because of the bac ......