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
Ïà¹ØÎĵµ£º
string file = "c:\\work.xml";
private void btnCearte_Click(object sender, EventArgs e)
{
XmlDocument doc = new XmlDocument();
  ......
XML=¿ÉÀ©Õ¹±ê¼ÇÓïÑÔ(eXtensible Markup Language).
¿ÉÀ©Õ¹±ê¼ÇÓïÑÔXMLÊÇÒ»ÖÖ¼òµ¥µÄÊý¾Ý´æ´¢ÓïÑÔ£¬Ê¹ÓÃһϵÁмòµ¥µÄ±ê¼ÇÃèÊöÊý¾Ý£¬¶øÕâЩ±ê¼Ç¿ÉÒÔÓ÷½±ãµÄ·½Ê½½¨Á¢£¬ËäÈ»XMLÕ¼ÓõĿռä±È¶þ½øÖÆÊý¾ÝÒªÕ¼Óøü¶àµÄ¿Õ¼ä£¬µ«XML¼«Æä¼òµ¥Ò×ÓÚÕÆÎÕºÍʹÓá£
XMLµÄ¼òµ¥Ê¹ÆäÒ×ÓÚÔÚÈκÎÓ¦ÓóÌÐòÖжÁдÊý¾Ý£¬ÕâʹXMLºÜ¿ì³ÉΪÊý¾Ý½»»»µÄ ......
ʲôÊÇ XML?
XML Ö¸¿ÉÀ©Õ¹±ê¼ÇÓïÑÔ£¨EXtensible Markup Language£©
XML ÊÇÒ»ÖÖ±ê¼ÇÓïÑÔ£¬ºÜÀàËÆ HTML
XML µÄÉè¼Æ×ÚÖ¼ÊÇ´«ÊäÊý¾Ý£¬¶ø·ÇÏÔʾÊý¾Ý
XML ±êǩûÓб»Ô¤¶¨Òå¡£ÄúÐèÒª×ÔÐж¨Òå±êÇ©¡£
XML ±»Éè¼ÆÎª¾ßÓÐ×ÔÎÒÃèÊöÐÔ¡£
XML ÊÇ W3C µÄÍÆ¼ö±ê×¼
XML Óë HTML µÄÖ÷Òª²îÒì
XML ²»ÊÇ HTML µÄÌæ´ú¡£
XML ºÍ HTML Ϊ² ......
2009-12-19¿¼ÁËCETÓ¢ÓÐÄÇéºÜ²î£¬¹À¼ÆÓÖ²»¹ýµÄ£¬°¥£¡Ó¢ÎIJ
ÓÚÊÇ¿´¿´Ê飬¿´¿´×Ô¼º¸ÐÐËȤµÄÊé
½ñÌìÏÂÎ磬Ñо¿ÁËÕû¸öÏÂÎçµÄСÄÑÌ⣬ÔÚ8µã40·ÖÖÕÓڸ㶨ÁË£¡¶Ç×Ó¶ö£¬»¹Ã»³Ô·¹£¬»¹Ã»Ï´Ô裬¿Ë·þÁËÒ»¸ö²»¶®µÄСÄÑÌ⣬ÐÄÀíÓеãÌå»á£¬ÏëÔÚÕâÀïÁôµã¼ÍÄ·½±ã±ðÈËÒÔºóѧϰ¡£ÓÚÊǺõ£¬ÎÒдÁË£º
£¨ÄÇЩ¿ªÑµÁ·Æ÷µÄÏà¹Ø½éÉÜÎҾͲ»ÔÙ ......
ʵÏÖ¹¦ÄÜ£º¸ù¾ÝÅäÖÃÎļþ£¨XXXX.ini£©ÖеÄÄÚÈݶÔXMLÖÐ½Úµã½øÐвÙ×÷£¬Èç¹ûXMLÖдæÔÚÓëÅäÖÃÎļþÖÐÏàͬµÄ½Úµã£¬Ôò¸ù¾ÝÅäÖÃÎļþ½«XMLÎļþÖÐÏàÓ¦½ÚµãµÄÖµ½øÐиüУ»Èç¹ûXMLÎļþÖв»´æÔÚÅäÖÃÎļþÖгöÏֵĽڵ㣬ÔòÔÚXMLÖн«Ð½ڵ㼰ֵ½øÐвåÈë²Ù×÷¡£
¡ôXMLÎĵµ½á¹¹ÈçÏÂ
//------------------------------------------------------ ......