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

ÔõÑùÓÃ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¸ñʽ£¬È»ºóͨ¹ý´æ´¢¹ý³Ì°Ñ¸Ã²ÎÊý×öΪÊä³ö²ÎÊý¾Í¿ÉÒÔÁË£¬

¸ãʲôЦÂï


ѧϰÁË¡£¡£¡£


Ïà¹ØÎÊ´ð£º

asp.netµ¼³öEXCELÎÊÌ⣡ - .NET¼¼Êõ / ASP.NET

C# code:

SqlConnection conn = CsDB.sqlcon();
SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄÇ°2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......

ÇóÖú£ºÕÒASP.NETÍøÒ³ÖÆ×÷¸ßÊÖ£¬Óб¨³ê¡£

±¾ÈËÊDzËÄñÒ»¸ö£¬Æ½Ê±Òª×öÉúÒ⣬µ«ÊÇÕÒÁ˺ܶàÈË×öÍøÕ¾£¬¾ù±»Æ­ÁË¡£×öµÃ²»Èý²»ËÄ£¬ÏÖÔÚ¾öÐÄ×Ô¼ºÀ´×öÒ»¸ö£¬ÒÑѧϰASP.NETÏà¹ØµÄÍøÒ³ÖÆ×÷֪ʶ£¬ÓÐDW»ù´¡£¬¿ÉÒÔ˵ÊÇÄ¿Ç°Ö»ÓÐÀíÂÛ֪ʶ£¬µ«ÊÇÔÚʵ¼Ê¾ßÌå²Ù×÷µÄʱºò£¬×ÜÊÇÓöµ ......

vb¶ÁÈ¡ÓÃwordת»»³ÉµÄxmlÀïµÄÊý¾Ý - VB / »ù´¡Àà

Private Sub Command1_Click()
Dim MyString() As String
Open "a.xml" For Binary As #1 ' ´ò¿ª¸Õ´´½¨µÄÎļþ¡£
ReDim MyString(LOF(1) - 1)
  Put #1, , MyRecord ' ¶ÁÈëËùÓÐ×Ö·ûµ½±äÁ¿ÖÐ ......

ÇóÒ»¸öSQLÓï¾ä - MS-SQL Server / »ù´¡Àà

×Ö¶Î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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ