¹ØÓÚASPµ¼³öEXCEL±í¸ñÎÊÌâ.
HTML code:
<%
Response.Buffer = TRUE
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "content-disposition", "inline; filename = "¿Í»§ÐÅÏ¢±í.xls"
%>
ÎÒÓÃÉÏÃæÕâÖÖ·½·¨µ¼³öEXCEL±í¸ñ,ΪʲôֻÄܵ¼³ö1000ÐÐ,²»ÄÜÔÙ¶àÁËÂð?ÎÒ¿âÀïµÄÊý¾Ý²»Ö¹Ò»Ç§Ðа¡.
ÎÒ¾õµÃ²»ÊÇ Response µÄÎÊÌ⣬ÊDz»ÊÇÊý¾Ý¿âÅäÖ㬻òÊý¾Ý¿âÓï¾ä²»¶Ô£¿
²é³öÀ´È·ÊµÊÇ´óÓÚһǧÐеÄ,µ«ÏÂÔØÏÂÀ´,¾ÍÖ»ÓÐһǧÐÐÊý¾Ý.
´úÂëµ÷ÊÔʱ Êý¾ÝÔÚÓÚ1000Ìõ£¬Êä³ö³ÉexcelʱֻÓÐ1000Ìõ£¿Ã»ÓÐÓöµ½ÕâÖÖÇé¿ö¡£
ÎÒ¶¼ÊÇÓà <table> <tr> <td> </td> </tr> </table> ÕâÖÖ¸ñʽֱ½Ó±£´æΪxls Ò²¿ÉÒÔ±»excelÖ±½Ó´ò¿ª
µ«È·Êµ±£´æΪXLSºóÖ»ÓÐһǧÌõÊý¾ÝŶ
¿ÉÒÔÊÔÊÔÔÚexcelÖÐ×öºÃÎļþ£¬È»ºó±£´æ³Éhtm£¬ÔÚÐ޸ijÉaspÕâÑùµÄ°ì·¨¡£ÎÒ×öÁËûÅöµ½1000ÐÐÕâÑùµÄÎÊÌâ¡£
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ£¬ÎÒÏÖÔÚÓÐÒ»¸öÓÃaspдµÄÁÄÌìÊÒ£¬ÏÖÔÚµÄÏëÌí¼ÓÒ»¸ö¹¦ÄÜ£¬¾ÍÊǵ±ÓÐÈËÉÏÏßµÄʱºò£¬·¢³öÌáʾ£¬±ÈÈçÉùÒôÏìһϣ¬ÏÖÔÚÏëÓÃjavaʵÏÖÕâ¸ö¹¦ÄÜ£¬ÇëÎÊ´ó¼ÒÔõôʵÏÖ£¿
ллÁË£¬ÎÒ»á¼Ó·ÖµÄ
aspºÍjavaÕûºÏµ½Ò»ÆðÈ¥£¿ºÎ±Ø ......
¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......
SQL code:
rs.open "select * from guide where city_name='±±¾©' order by pai desc",conn,1,1
do while not rs.eof or rs.bof
¡£¡£
¡£¡£
¡£¡£
rs.movenext
loop
Õâ¸ösqlÓï¾äÔÚwapÕ¾Àï ±¾ÉíÓÐ ......
¹ØÓÚasp.net md5 32λ¼ÓÃܽâÃÜ
ÓÐûÓÐÈË¿ÉÒÔд¸öÀà¡£
²¢Ïêϸ½âÊÍһϣ¬±¾È˺ܲ»Àí½â32λmd5
C# code:
public string md5(string str,int code)
2{
3 if(code==16) //16λMD5¼ÓÃÜ£¨È¡32λ¼ÓÃܵÄ9~25× ......
<table border= "0 " cellspacing= "0 " cellpadding= "0 ">
<BH_CHANNELS ID= "OWNER " CHILDTYPE= "aaa " ......