asp.net c# ÏëÒªµ÷ÓÃoracle spoolµ¼³öÎļþ
ÎÒÏëÔÚwebÖÐ ÓÃspool ´ÓoracleÖе¼³ö exel±í¸ñ ´úÂëдºÃÁË ´æÔڽű¾ µ«²»»áµ÷Óýű¾
ÓÃÁ˸ö±¿·½·¨ oraclecommend a=£¨¡° set colsep' '¡±£¬conn£© Ò»ÌõÒ»ÌõÖ´ÐÐ
ÓÃsql/plusÔËÐнű¾Ã»ÎÊÌ⣬µ«ÊÇÔÚÍøÒ³Öв»Ê¶±ðÎÒдµÄÓï¾ä Ϊʲô Ôõô°ì £¿ ÊDz»ÊÇÎÒµÃÔÙÌî¼Óij¸öÍ·Îļþ £¿
»¹Êǵôò¿ªsql/plus°¡
ÇóÖú
.net²»¶® Ö»ÄܰﶥÁË¡£¡£¡£
¶¥................ 5555
ÎÒÊÔÊÔ´æ´¢¹ý³Ì »¹ÓбðµÄ·½·¨Â𣿠ÓÐÈËÖªµÀÔõôµ÷Óýű¾Âð
UPVVVVVVVVVVVVVVVVVVVVVVVVVV
oraclecommend
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
ÎÒÓÃjqueryÎÞË¢ÐÂÉÏ´«Í¼Æ¬ºó·µ»Øjson¸ñʽµÄÊý¾Ý±¨´í
£¨Êµ¼ÊÉÏͼƬÊÇÉÏ´«³É¹¦µÄÁË£¬Ö»ÊÇ·µ»Øjson¸ñʽ×ܶÁ²»µ½£¬×ÜÊDZ¨´í£©
ÎÒµ÷ÊÔÉÏ´«µÄashxÒ³ÈçÏÂ
ÎÞ·¨ÏÔʾ XML Ò³¡£
ʹÓà Ñùʽ±íÎÞ·¨²é¿´ XML ÊäÈë¡£Çë¸ü ......
ÆäʵÕâ¸öÎÊÌâ¿ÉÒÔÕÒÀÏʦ»Ø´ð£¬Õâ²»·Å¼ÙÁËÂð£¬ÎÊÎʸ÷λ¸ßÊÖ¡£
¾ø¶ÔÓÐ £¬ASP¡¢netÀïÓкöàµÄÂß¼Åжϵȶ¼ÐèÒªwinform»ù´¡
C#ÓïÑÔ
Ado.net C/S½á¹¹
Asp.net B/S½á¹¹
Á©¶¼ÊÇ΢Èí³öµÄ£¬¶¼ÄÜÓÃC#½øÐпª·¢ ......