ÔõÑùÓÃsqlÓï¾äÖ±½ÓÉú³ÉXMLÎļþ - .NET¼¼Êõ / ASP.NET
ÔõÑùÓÃsqlÓï¾äÖ±½ÓÉú³ÉXMLÎļþ?
select* from tab for xml ÒýÓà select* from tab for xml ÍÛ£¬Ò»Â¥£¬ÕâÊÇÕæµÄÂð£¿ÕæÓÐÕâÖÖÓ÷¨Âð£¿ÔõôÓð¡ ÎÒÖ»ÖªµÀ£¬dataset.toxml() C# code: ²»ÖªµÀÔõôֱ½ÓÉú³Éxml Ê×ÏÈÄãÒªµ½´¦µÄ½á¹ûÒª·ûºÏxmlµÄ¸ñʽ°É¡£¡£ ¹À¼ÆÔÚºǫ́ÓôúÂëÀ´ÊµÏÖ¼òµ¥ ͬÒâ3Â¥£¬»òÕßÉú³ÉTable ÔÚתXML declare @str varchar(max) set @str='<xml><ul>xmlÎļþ</ul></xml>' ÓòÎÊý×éºÏ³Éxml¸ñʽ£¬È»ºóͨ¹ý´æ´¢¹ý³Ì°Ñ¸Ã²ÎÊý×öΪÊä³ö²ÎÊý¾Í¿ÉÒÔÁË£¬ ¸ãʲôЦÂï ѧϰÁË¡£¡£¡£
Ïà¹ØÎÊ´ð£º
C# code: SqlConnection conn = CsDB.sqlcon(); SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle) ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄÇ°2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
±¾ÈËÊDzËÄñÒ»¸ö£¬Æ½Ê±Òª×öÉúÒ⣬µ«ÊÇÕÒÁ˺ܶàÈË×öÍøÕ¾£¬¾ù±»ÆÁË¡£×öµÃ²»Èý²»ËÄ£¬ÏÖÔÚ¾öÐÄ×Ô¼ºÀ´×öÒ»¸ö£¬ÒÑѧϰASP.NETÏà¹ØµÄÍøÒ³ÖÆ×÷֪ʶ£¬ÓÐDW»ù´¡£¬¿ÉÒÔ˵ÊÇÄ¿Ç°Ö»ÓÐÀíÂÛ֪ʶ£¬µ«ÊÇÔÚʵ¼Ê¾ßÌå²Ù×÷µÄʱºò£¬×ÜÊÇÓöµ ......
Private Sub Command1_Click() Dim MyString() As String Open "a.xml" For Binary As #1 ' ´ò¿ª¸Õ´´½¨µÄÎļþ¡£ ReDim MyString(LOF(1) - 1) Put #1, , MyRecord ' ¶ÁÈëËùÓÐ×Ö·ûµ½±äÁ¿ÖÐ ......
×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID 1,Name1....test1,1,99 1,Name1....test1,3,99 1,Name2....test2,1,101 1,Name2....test2,3,101 1,Name3....test3,2,101 1,Name1....test1,4,101 ÏëÒªµÄ½á¹ûÊÇ: 1,Na ......