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Îļþ
Ö®ËùÒÔÒªÒýÈëXPathµÄ¸ÅÄĿµÄ¾ÍÊÇΪÁËÔÚÆ¥ÅäXMLÎĵµ½á¹¹Ê÷ʱÄܹ»×¼È·µØÕÒµ½Ä³Ò»¸ö½ÚµãÔªËØ¡£¿ÉÒÔ°ÑXPath±È×÷Îļþ¹ÜÀí·¾¶£ºÍ¨¹ýÎļþ¹ÜÀí·¾¶£¬¿ÉÒÔ°´ÕÕÒ»¶¨µÄ¹æÔò²éÕÒµ½ËùÐèÒªµÄÎļþ£»Í¬Ñù£¬ÒÀ¾ÝXPathËùÖƶ¨µÄ¹æÔò£¬Ò²¿ÉÒԺܷ½±ãµØÕÒµ½XML½á¹¹ÎĵµÊ÷ÖеÄÈκÎÒ»¸ö½Úµã.
¡¡¡¡²»¹ý£¬ÓÉÓÚXPath¿ÉÓ¦Ó ......
var xmlDom; //XML DOM object
var xmlFile="ff.xml"; //xml file name
loadXML = function(fileRoute){
xmlDoc=null;
if (window.ActiveXObject){
xmlDoc = new ActiveXObject('Msxml2.DOMDocument');
xmlDoc.async=false;
xmlDoc.load(fileRoute);
}else if (document.implementation &a ......
ÔÌù£ºhttp://topic.csdn.net/u/20100412/14/f6941844-e9bf-4ed7-a0c2-bef03d775783.html?70615
declare @data xml=
'<root>
<SaleMan>
<SaleManId>1</SaleManId>
<SaleManCode>001</SaleManCode>
<Nodes>
<Node>
< ......
ʵÏÖ¹¦ÄÜ£º¸ù¾ÝÅäÖÃÎļþ£¨XXXX.ini£©ÖеÄÄÚÈݶÔXMLÖнڵã½øÐвÙ×÷£¬Èç¹ûXMLÖдæÔÚÓëÅäÖÃÎļþÖÐÏàͬµÄ½Úµã£¬Ôò¸ù¾ÝÅäÖÃÎļþ½«XMLÎļþÖÐÏàÓ¦½ÚµãµÄÖµ½øÐиüУ»Èç¹ûXMLÎļþÖв»´æÔÚÅäÖÃÎļþÖгöÏֵĽڵ㣬ÔòÔÚXMLÖн«Ð½ڵ㼰ֵ½øÐвåÈë²Ù×÷¡£
¡ôXMLÎĵµ½á¹¹ÈçÏÂ
//------------------------------------------------------ ......
Ê×ÏÈдһ¸öhtml userxmljquery.html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Óû§Ð£ÑéajaxʵÀý</title>
& ......