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

SQL Server2005 xml×Ö¶ÎʹÓ÷½·¨ 1¶Ô¶à±í¼Ç¼¶ÁÈ¡

ÔÚSQL Server2005ÖÐÓÐFOR XML Ó÷¨£¬¿ÉÒÔ½²Ò»¸ö±í×÷Ϊһ¸ö×ֶΡ£
ÎÒµÄÉè¼ÆÏë·¨Ö÷ÒªÊÇÓÃÔÚ1¶Ô¶àµÄ¹ØÏµÖбí¶ÁÈ¡µÄÎÊÌâ¡£
±íA ±íB
ÔÚAÖÐÓÐÒ»Ìõ¼Ç¼¶øÔÚBÖÐÓжàÌõ¼Ç¼¿ÉÒÔ²ÎÕÕÏÂÃæµÄд·¨£º£¨ÎÒµÄÏîÄ¿ÖÐÓõ½µÄ£¬ÐÞ¸ÄÁË×Ö¶ÎÖ÷ÒªÊÇÑÝʾÓã©
select A.*,
(SELECT a,  CAST(G_Univalence AS NVARCHAR(48)) AS G_Univalence,
--×¢ÒâÁôÏÂËûµÄÒâÒåÖ»ÊÇmoney×Ö¶ÎÔÚfor xmlÖÐËü²ÉÓÿÆÑ§¼ÆÊý·¨ÏÔʾ,ÔÚÓ¦ÓÃÖв»ºÃ´¦Àí
 from B WHERE B.CB_ID = A.BP_ID FOR XML RAW,TYPE,ROOT('GrainConstraint')) AS GrainConstraint 
--ʹÓÃTYPE·µ»Ø xml×Ö¶ÎÀàÐÍ
from A
ÔÚºǫ́£¬Ê¹ÓÃSqlDataReader¶ÁÈ¡xml×Ö¶Î,GetSqlXml()£¬²ÎÕÕÏÂÃæµÄ´úÂë.
  public static bool ToDataTable(SqlXml sxSource, DataTable dt)
        {
            XmlReader xmlReader = sxSource.CreateReader();
            string tempName;
            int nColumnIndex;
            Type type;
            while (xmlReader.Read()) //ÿ´ÎÑ­»·1Ìõ¼Ç¼
            {
                switch (xmlReader.NodeType)
                {
                    case XmlNodeType.Element:
                        if (xmlReader.LocalName == "row")
                        {
          &n


Ïà¹ØÎĵµ£º

XPath,XMLÎĵµ,SelectNodes()ͨÅä·û˵Ã÷


ÀûÓÃXPath¶ÁÈ¡XmlÎļþ
Ö®ËùÒÔÒªÒýÈëXPathµÄ¸ÅÄĿµÄ¾ÍÊÇΪÁËÔÚÆ¥ÅäXMLÎĵµ½á¹¹Ê÷ʱÄܹ»×¼È·µØÕÒµ½Ä³Ò»¸ö½ÚµãÔªËØ¡£¿ÉÒÔ°ÑXPath±È×÷Îļþ¹ÜÀí·¾¶£ºÍ¨¹ýÎļþ¹ÜÀí·¾¶£¬¿ÉÒÔ°´ÕÕÒ»¶¨µÄ¹æÔò²éÕÒµ½ËùÐèÒªµÄÎļþ£»Í¬Ñù£¬ÒÀ¾ÝXPathËùÖÆ¶¨µÄ¹æÔò£¬Ò²¿ÉÒԺܷ½±ãµØÕÒµ½XML½á¹¹ÎĵµÊ÷ÖеÄÈκÎÒ»¸ö½Úµã.
¡¡¡¡²»¹ý£¬ÓÉÓÚXPath¿ÉÓ¦Ó ......

xmlÓëdataset£¨datatable£©»¥×ª

ÒýÓÃÀà¿â£º
 using System;
 using System.Data;
 using System.IO;
 using System.Xml;
using System.Text;
// ÏàÓ¦C#´úÂ룺
private string ConvertDataTableToXML(DataTable xmlDS)
{
MemoryStream stream = null;
XmlTextWriter writer = null;
try
......

OpenCVѵÁ··ÖÀàÆ÷ÖÆ×÷xmlÎĵµÖ®Ò»

2009-12-19¿¼ÁËCETÓ¢ÓÐÄÇéºÜ²î£¬¹À¼ÆÓÖ²»¹ýµÄ£¬°¥£¡Ó¢ÎIJ
ÓÚÊÇ¿´¿´Ê飬¿´¿´×Ô¼º¸ÐÐËȤµÄÊé
½ñÌìÏÂÎ磬Ñо¿ÁËÕû¸öÏÂÎçµÄСÄÑÌ⣬ÔÚ8µã40·ÖÖÕÓڸ㶨ÁË£¡¶Ç×Ó¶ö£¬»¹Ã»³Ô·¹£¬»¹Ã»Ï´Ô裬¿Ë·þÁËÒ»¸ö²»¶®µÄСÄÑÌ⣬ÐÄÀíÓеãÌå»á£¬ÏëÔÚÕâÀïÁôµã¼ÍÄ·½±ã±ðÈËÒÔºóѧϰ¡£ÓÚÊǺõ£¬ÎÒдÁË£º
£¨ÄÇЩ¿ªÑµÁ·Æ÷µÄÏà¹Ø½éÉÜÎҾͲ»ÔÙ ......

xml»ù´¡

Ò»XML ½âÎöÆ÷
´ó¶àÊýä¯ÀÀÆ÷¶¼ÓжÁÈ¡ºÍ²Ù×÷ XML µÄÄÚ½¨ XML ½âÎöÆ÷¡£
½âÎöÆ÷°Ñ XML ת»»Îª JavaScript ¿É·ÃÎʵĶÔÏó¡£
½âÎö XML
ËùÓÐÏÖ´úä¯ÀÀÆ÷¶¼ÓжÁÈ¡ºÍ²Ù×÷ XML µÄÄÚ½¨ XML ½âÎöÆ÷¡£
½âÎöÆ÷°Ñ XML ÔØÈëÄڴ棬Ȼºó°ÑËüת»»Îª¿Éͨ¹ý JavaScript ·ÃÎ浀 XML DOM ¶ÔÏó¡£
Äú½«ÔÚ±¾½Ì³ÌµÄÏÂÒ»½ÚÖÐѧϰ¸ü¶àÓÐ¹Ø XML DOM µÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ