Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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¸ñʽ£¬È»ºóͨ¹ý´æ´¢¹ý³Ì°Ñ¸Ã²ÎÊý×öΪÊä³ö²ÎÊý¾Í¿ÉÒÔÁË£¬

¸ãʲôЦÂï


ѧϰÁË¡£¡£¡£


Ïà¹ØÎÊ´ð£º

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

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

C# code:

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

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

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

±éÀúÒ»¸öxml²¢Êä³öÖ¸¶¨½ÚµãµÄÖµ - .NET¼¼Êõ / C#

ÎÒÓÐÒ»¸öÀàËÆµÄxmlµÄ string£¬Ïëͨ¹ý±éÀúÔõô¸öxml Êä³öÎÒÏëÒªµÄelementµÄÖµ
xml Ϊ£º
<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
  <RequestType>DISCOVER_XML_ME ......

ÇóÒ»¸ö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ºÅ