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

xmlÎļþ²Ù×÷С½á selectsinglenode·½·¨ÖеÄxpath

×î³£¼ûµÄXMLÊý¾ÝÀàÐÍÓУºElement, Attribute£¬Comment, Text.
  Element, Ö¸ÐÎÈç<Name>Tom<Name>µÄ½Úµã¡£Ëü¿ÉÒÔ°üÀ¨£ºElement, Text, Comment, ProcessingInstruction, CDATA, and EntityReference.
  Attribute, Ö¸ÔÚ<Employee id=”12345”>ÖеĴÖÌ岿·Ö¡£
  Comment£¬Ö¸ÐÎÈ磺<!-- my comment --> µÄ½Úµã¡£
  Text£¬Ö¸ÔÚ<Name>Tom<Name>µÄ´ÖÌ岿·Ö¡£
  ÔÚXMLÖУ¬¿ÉÒÔÓÃXmlNode¶ÔÏóÀ´²ÎÕÕ¸÷ÖÖXMLÊý¾ÝÀàÐÍ¡£
  2.1 ²éѯÒÑÖª¾ø¶Ô·¾¶µÄ½Úµã£¨¼¯£©
  objNodeList = objDoc.SelectNodes(“Company/Department/Employees/Employee”)
  »òÕß
  objNodeList = objNode.SelectNodes(“/Company/Department/Employees/Employee”)
  ÒÔÉÏÁ½ÖÖ·½·¨¿É·µ»ØÒ»¸öNodeList¶ÔÏó£¬Èç¹ûÒª·µ»Øµ¥¸ö½Úµã¿ÉʹÓÃSelectSingleNode·½·¨£¬¸Ã·½·¨Èç¹û²éѯµ½Ò»¸ö»ò¶à¸ö½Úµã£¬·µ»ØµÚÒ»¸ö½Úµã£»Èç¹ûûÓвéѯµÄÈκνڵ㷵»Ø Nothing¡£ÀýÈ磺
  objNode = objNode.SelectSingleNode(“/Company/Department/Employees/Employee”)
  If Not (objNode is Nothing) then
   ‘- Do process
  End If
  2.2 ²éѯÒÑÖªÏà¶Ô·¾¶µÄ½Úµã£¨¼¯£©
  ¿ÉʹÓÃÀàËÆÓÚÎļþ·¾¶µÄÏà¶Ô·¾¶µÄ·½Ê½À´²éѯXMLµÄÊý¾Ý
  objNode = objDoc.SelectSingleNode(“Company/Department”)
  objNodeList = objNode.SelectNodes(“../Department)
  objNode = objNode.SelectNode(“Employees/Employee”)
  2.3 ²éѯÒÑÖªÔªËØÃûµÄ½Úµã£¨¼¯£©
  ÔÚʹÓò»¹æÔòµÄ²ã´ÎÎĵµÊ±£¬ÓÉÓÚ²»ÖªµÀÖмä²ã´ÎµÄÔªËØÃû£¬¿ÉʹÓÃ//·ûºÅÀ´Ô½¹ýÖмäµÄ½Úµã£¬²éѯÆä×Ó£¬Ëï»ò¶à²ã´ÎÏÂµÄÆäËûËùÓÐÔªËØ¡£ÀýÈ磺
  objNodeList = objDoc.SelectNodes(“Company//Employee”)
  2.4 ²éѯÊôÐÔ£¨attribute£©½Úµã
  ÒÔÉϵĸ÷ÖÖ·½·¨¶¼·µ»ØÔªËØ£¨element)½Úµã£¨¼¯£©£¬·µ»ØÊôÐÔ£¨attribute£©£¬Ö»ÐèÒª²ÉÓÃÏàÓ¦µÄ·½·¨£¬ÔÚÊôÐÔÃûǰ¼ÓÒ»¸ö@·ûºÅ¼´¿É£¬ÀýÈ磺
  objNodeList = objDoc.SelectNodes(“Compan


Ïà¹ØÎĵµ£º

ʹÓÃXMLÔÚSQL ServerÉÏ´´½¨¼ÆËãÁÐ

¡¡ÔÚSQL ServerÊý¾Ý¿âÖУ¬µ±ÄãÏëʹÓÃÒ»¸öÊý¾Ý£¬¶øÕâ¸öÊý¾Ý²»±£´æÔÚ±íÖУ¬¼ÆËãÁкÜÓÐÓá£ÀýÈ磬ÄãÓÐÒ»ÕÅ±í£¬Ëü°üÀ¨ÁÐdollar amounts, wholesale pricesºÍretail prices¡£Äã¿Ï¶¨²»ÏëÔÚÿ´Î²éѯ±íʱÀ´¼ÆËãÄÇÁ½ÁÐÖ®¼äµÄ²îÖµ£¬ÄãÏ£Íû½«ÆäÖµ±£´æÔÚµÚÈýÁÐÖУ¬ÈÃÆä×Ô¶¯¼ÆËãǰÁ½ÁÐÖ®¼äµÄ²îÖµ¡£¶ø´ËÁоÍÊǼÆËãÁС£
¡¡¡¡ÔÚSQL ServerÖ ......

.NET¶ÔÏóµÄXMLÐòÁл¯ºÍ·´ÐòÁл¯

 ÐòÁл¯µÄ¸ÅÄî
ÐòÁл¯ÊÇÖ¸Ò»¸ö¶ÔÏóµÄʵÀý¿ÉÒÔ±»±£´æ£¬±£´æ³ÉÒ»¸ö¶þ½øÖÆ´®£¬µ±È»£¬Ò»µ©±»±£´æ³É¶þ½øÖÆ´®£¬ÄÇôҲ¿ÉÒÔ±£´æ³ÉÎı¾´®ÁË¡£
±ÈÈ磬һ¸ö¼ÆÊýÆ÷£¬ÊýֵΪ2£¬ÎÒÃÇ¿ÉÒÔÓÃ×Ö·û´®“2”±íʾ¡£
Èç¹ûÓиö¶ÔÏ󣬽Ð×öconnter£¬µ±Ç°ÖµÎª2£¬ÄÇô¿ÉÒÔÐòÁл¯³É“2”£¬·´ÏòµÄ£¬Ò²¿ÉÒÔ´Ó“2&rdquo ......

vc++¶ÁÈ¡xmlÎļþÖеÄÊôÐÔÖµ

¼ÙÉèxmlÎļþÊÇ
  <?xml version="1.0" encoding="gb2312" ?>
- <books auth="wren">
- <book id="B01">
  <name>¹þÀï²¨ÌØ </name>
  <price>10 </price>
  <memo>ÕâÊÇÒ»±¾ºÜºÃ¿´µÄÊé¡£ </memo>
  </book>
- <boo ......

XML±Ê¼ÇÒ»

XMLµÄ²úÉú?
XMLµÄÈ«³ÆÊÇExtensible Markup Language,Òâ˼ÊÇ¿ÉÀ©Õ¹µÄ±ê¼ÇÓïÑÔ£¬ËüÊDZê׼ͨÓñê¼ÇÓïÑÔ(Standard Generalized Markup Language, SGML)µÄÒ»¸ö×Ó¼¯¡£SGML¹¦Äܷdz£Ç¿´ó£¬ÊÇ¿ÉÒÔ¶¨Òå±ê¼ÇÓïÑÔµÄÔªÓïÑÔ¡£
W3C×éÖ¯ÓÚ2004Äê2ÔÂ4ÈÕ£¬·¢²¼ÁËXML1.1µÄÍÆ¼ö±ê×¼£¬ÕâÊÇ×îеÄXML°æ±¾£¬²»¹ýĿǰ´ó¶àÊýµÄÓ¦Óû¹ÊÇ»ùÓÚXML1.0µÄ ......

XSLTת»»XMLʵÀý

ת×Ô½­±ß¹ÂÄñ: http://blog.csdn.net/jbgh608/archive/2007/08/31/1767414.aspx
W3school µÄxsl½Ì³Ì£º http://www.w3school.com.cn/xsl/index.asp
²úÆ·¼¸ÄêǰʹÓÃASP£¬ºóÀ´Éý¼¶µ½.Net 1.1£¬ÔÙÉý¼¶µ½2.0£¬Ò»Ö±¶¼ÓÐÓÃXSLTת»»XMLÉú³ÉÍøÒ³µÄ·½Ê½£¬ÉÔ΢ÕûÀíÏ¡£
    XML file:
<?xml version="1.0"& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ