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

asp.net c# ÏëÒªµ÷ÓÃoracle spoolµ¼³öÎļþ

ÎÒÏëÔÚwebÖÐ ÓÃspool ´ÓoracleÖе¼³ö exel±í¸ñ  ´úÂëдºÃÁË ´æÔڽű¾ µ«²»»áµ÷Óýű¾
ÓÃÁ˸ö±¿·½·¨ oraclecommend a=£¨¡° set colsep' '¡±£¬conn£© Ò»ÌõÒ»ÌõÖ´ÐР
ÓÃsql/plusÔËÐнű¾Ã»ÎÊÌ⣬µ«ÊÇÔÚÍøÒ³Öв»Ê¶±ðÎÒдµÄÓï¾ä  Ϊʲô Ôõô°ì  £¿ ÊDz»ÊÇÎÒµÃÔÙÌî¼Óij¸öÍ·Îļþ  £¿
»¹Êǵôò¿ªsql/plus°¡   
ÇóÖú
.net²»¶® Ö»ÄܰﶥÁË¡£¡£¡£

    ¶¥................ 5555



ÎÒÊÔÊÔ´æ´¢¹ý³Ì  »¹ÓбðµÄ·½·¨Â𣿠ÓÐÈËÖªµÀÔõôµ÷Óýű¾Âð 

UPVVVVVVVVVVVVVVVVVVVVVVVVVV


ÒýÓÃ
ÎÒÏëÔÚwebÖÐ ÓÃspool ´ÓoracleÖе¼³ö exel±í¸ñ  ´úÂëдºÃÁË ´æÔڽű¾ µ«²»»áµ÷Óýű¾
ÓÃÁ˸ö±¿·½·¨ oraclecommend a=£¨¡° set colsep' '¡±£¬conn£© Ò»ÌõÒ»ÌõÖ´ÐР
ÓÃsql/plusÔËÐнű¾Ã»ÎÊÌ⣬µ«ÊÇÔÚÍøÒ³Öв»Ê¶±ðÎÒдµÄÓï¾ä  Ϊʲô Ôõô°ì  £¿ ÊDz»ÊÇÎÒµÃÔÙÌî¼Óij¸öÍ·Îļþ  £¿
»¹Êǵôò¿ªsql/plus°¡   
ÇóÖú
oraclecommend

ÒýÓÃ
½¨Ò飺²»Ê¹Óà spool

(1) ÏȽ«Êý¾Ý´Ó Oracle Öвéѯ³öÀ´£¬´æÈë DataSet
(2) ÔÙ½«Êý¾Ý´Ó DataSet µ¼³öΪ Excel£¬·½·¨ºÜ¶à£¬´óÖÁ·ÖΪÈýÀࣺ
    i. HTML table ÐÎʽ»ò csv¸ñʽ µÄ αExcel
      ²Î¿¼´úÂë http://www.cnblogs.com/evernory/archive/2004/09/22/45580.html
                http://www.cnblogs.com/freeliver54/archive/2009/02/23/1396373.html

    ii.µ÷ÓÃExcelµÄCOM×é¼þµ¼³öÕæExcelÎļþ£¨È±ÏÝ£º·þÎñÆ÷¶Ë±ØÐë°²×° MS Office¡¢Íê


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

Êý¾Ý±íÉú³ÉÌØ¶¨¸ñʽµÄxml - .NET¼¼Êõ / ASP.NET

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽÎļþ
<folder state="unchecked" label="È«²¿">
¡¡¡¡<folder state="unchecked" isBra ......

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»ù´¡£¬¿ÉÒÔ˵ÊÇĿǰֻÓÐÀíÂÛ֪ʶ£¬µ«ÊÇÔÚʵ¼Ê¾ßÌå²Ù×÷µÄʱºò£¬×ÜÊÇÓöµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ