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¡¢Íê
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý select ²¿ÃÅ,ÐÕÃû from tb ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽÎļþ <folder state="unchecked" label="È«²¿"> ¡¡¡¡<folder state="unchecked" isBra ......
C# code: SqlConnection conn = CsDB.sqlcon(); SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......
±¾ÈËÊDzËÄñÒ»¸ö£¬Æ½Ê±Òª×öÉúÒ⣬µ«ÊÇÕÒÁ˺ܶàÈË×öÍøÕ¾£¬¾ù±»ÆÁË¡£×öµÃ²»Èý²»ËÄ£¬ÏÖÔÚ¾öÐÄ×Ô¼ºÀ´×öÒ»¸ö£¬ÒÑѧϰASP.NETÏà¹ØµÄÍøÒ³ÖÆ×÷֪ʶ£¬ÓÐDW»ù´¡£¬¿ÉÒÔ˵ÊÇĿǰֻÓÐÀíÂÛ֪ʶ£¬µ«ÊÇÔÚʵ¼Ê¾ßÌå²Ù×÷µÄʱºò£¬×ÜÊÇÓöµ ......