XML ²éѯ¡¢Ìí¼Ó¡¢Ð޸ġ¢É¾³ý
Query:
XmlDocument doc = new XmlDocument();
doc.Load(Server.MapPath(".\\db\\dbGuest.xml"));
//UserÊÇXML¸ù½Úµã,Name×Ö½Úµã
lbEmail.Text =
doc.SelectSingleNode("//User[Name='"+ddlName.SelectedItem.Text+"']").ChildNodes.Item(2).InnerText;
Delete:
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(Server.MapPath(".\\db\\dbGuest.xml"));
XmlNodeList
xnl=xmlDoc.SelectSingleNode("dbGuest").ChildNodes;
foreach(XmlNode xn in xnl)
{
XmlElement xe=(XmlElement)xn;
XmlNodeList node = xe.GetElementsByTagName("Name");
if(node.Count>0)
{
if(node[0].InnerText==ddlName.SelectedItem.Text)
xe.RemoveAll();//ɾ³ý¸Ã½ÚµãµÄÈ«²¿ÄÚÈÝ
break;
}
}
xmlDoc.Save(Server.MapPath(".\\db\\dbGuest.xml"));
Add:
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(Server.MapPath(".\\db\\dbGuest.xml"));
XmlNode
root=xmlDoc.SelectSingleNode("dbGuest");//²éÕÒ<dbGuest>
XmlElement xe1=xmlDoc.CreateElement("User");//´´½¨Ò»¸ö<User>½Úµã
XmlElement xesub1=xmlDoc.CreateElement("Name");
xesub1.InnerText="Guset";//ÉèÖÃÎı¾½Úµã
xe1.AppendChild(xesub1);//Ìí¼Óµ½<User>½ÚµãÖÐ
XmlElement
xesub2=xmlDoc.CreateElement("City");
xesub2.InnerText="ÉϺ£";
xe1.AppendChild(xesub2);
XmlElement
xesub3=xmlDoc.CreateElement("Email");
xesub3.InnerText="ss@2
Ïà¹ØÎĵµ£º
ǰ¶Îʱ¼äÓÃjQuery×öÁ˸öСÁ·Ï°£¬»ñÈ¡±¾µØµÄxmlÊý¾Ý£¬ÔÚfirefoxÏÂÃæ²âÊÔûÎÊÌ⣬µ«ÊÇÔÚIEÏÂÃæ×ÜÊÇ»ñÈ¡Êý¾Ýʧ°Ü£¬ÉÏÍøÕÒÁ˺ܾÃҲûÕÒµ½ÊÇÔõô»ØÊ¡£ÓôÃÆÁ˺ܳ¤Ò»¶Îʱ¼ä£¬½ñÌìÓпÕÓÖ°ÑÕâ¸öÎÊÌâÄóöÀ´Ñо¿ÁËÏ£¬×îºóÖÕÓÚÕÒµ½ÔÒòÁË£¬°ÑÒ³Ãæ·Åµ½·þÎñÆ÷È¥ä¯ÀÀ¾ÍOKÁË¡£ÄѵÀÊÇȨÏÞÎÊÌ⣿²»ÖªµÀÔõô»ðºüÔÚ±¾µØÄ¿Â¼¿ÉÒÔ»ñÈ¡Êý¾Ý³É¹¦¡£ ......
Martin C. Brown (questions@mcslp.com), ¿ª·¢ÈËÔ±ºÍ×÷¼Ò
2008 Äê 6 ÔÂ 16 ÈÕ
ʹÓñ¾ÎĽéÉÜµÄ 10 ¸ö¼¼Çɸü¼ÓÇáËɵش¦Àí XML£¬´Ó¶ø¼õÉÙ´íÎó²¢Ìá¸ßЧÂÊ¡£
¼ò½é
ÈËÃǶ¼ºÜϲ»¶ XML ÒÔ¼°ËüËùÌṩµÄÁé»îÐԺͻ¥²Ù×÷ÐÔ£¬µ«ÊÇ£¬Í¨¹ýʹÓÃһЩ¼¼ÇÉ£¬¿ÉÒÔʹÓë XML µÄ»¥²Ù×÷ºÍÓë XML Ò»ÆðʹÓõŤ¾ß¸ü¼Ó¼òµ¥¡£ÔÚ´¦Àí XML Ê±Ñø³ÉһР......
ÎÄÕµ¼º½ SQL Server 2005 ѧϰ±Ê¼ÇϵÁÐÎÄÕµ¼º½
ÔÚSQl 2005 For XMl ¼òµ¥²éѯ(Raw£¬Auto£¬Pathģʽ)(1) ÀïÎÒÃÇ˵Á˹ØÓÚPath£¬RawºÍAutoģʽµÄÓ÷¨£¬ÆäʵÀïÃæ²»½ö½ö ÊÇÕâЩ¼òµ¥µÄ²Ù×÷£¬»¹ÓÐһЩÆäËüµÄÌØÐÔ£¬±ÈÈç˵Type»òOpenXml·½·¨£¬sp_xml_preparedocument´æ´¢¹ý³Ì µÈÕâЩÔö¼ÓµÄ¶«¶«£¬ÎÒÃÇÀ´Ò» ......
¡¡¡¡ÔÚÇ°ÃæÎÒÃÇѧϰÁËʹÓÃGlibµÄ¸ß³ÌÀ¦°ó·½Ê½µÄmethodµÄÊÕ·¢£¬ÏÖÔÚѧϰsingalµÄÊÕ·¢£¬xmlÀý×ÓÈçÏÂ
<?xml version="1.0" encoding="UTF-8" ?>
<node name="/com/wei/MyObject">
<interface name="com.wei.MyObject.Sample">
< ......
´´½¨¿ÉÐòÁл¯µÄÀ࣬»òÕß´´½¨ÓÃÓÚ´¦Àí XML ÐòÁл¯ÀàµÄÀà¡£ Èç¹ûÄúÓµÓÐÃèÊöÒª¼ÓÔØ»ò±£´æµÄ XML Îļþ¸ñʽµÄ XML ¼Ü¹¹¶¨Òå (XSD)£¬ÇëʹÓà Xsd.exe ¹¤¾ß×Ô¶¯´´½¨ÕâЩÀà¡£ »¹¿ÉÒÔÊÖ¶¯´´½¨ÕâЩÀà¡£ ÈôҪʹÓà Xsd.exe ¹¤¾ß´´½¨¿ÉÐòÁл¯µÄÀ࣬Çë°´ÕÕÏÂÁв½Öè²Ù×÷£º
½«ÒÔÏÂÃèÊö¶©µ¥µÄ XSD ¼Ü¹¹±£´æÎª Po.xsd Îļþ£º
<xsd:sche ......