ASP Ôõô ²Ù×÷ EXCEL£¬¶ÁÈ¡ ºÍ дÈë - Web ¿ª·¢ / ASP
Çë½Ì¸÷λ´óÏÀ£º
ASP Ôõô ²Ù×÷ EXCEL£¬¶ÁÈ¡ ºÍ дÈë
×îºÃÓдúÂë
ûÓÐÈ˰¡£¿
»¹ÊÇ·ÖÉÙ°¡£¿
ÕâЩ×ÊÁÏÓðٶÈgoogleһϾÍÊÇÒ»´ó¶Ñ¡£¡£ Ëæ±ãÕÒ¸öÀ´Ñо¿Ï¾ÍÄܵõ½×Ô¼ºµÄ½á¹û
±ÈÈçÕâ¸ö£ºhttp://tieba.baidu.com/f?kz=6668708
ÎÒÒ²°Ù¶Ègoogle¹ý£¬µ«ÊÇÓдíÎó
¸Õ²ÅÔÚ·þÎñÆ÷Éϰ²×°ÁËOffice µÄExcelºó£¬¾Í¿ÉÒÔÁË£¬
лл
ÆäʵºÜÏëÖªµÀ Excel.Application ÊÇÒýÓõÄÄĸö ³ÌÐò¼¯
¸úAccess²î²»¶àµÄ,Ö»²»¹ý±íÓÃ[]À¨ÆðÀ´
ÓÃExcel.ApplicationµÄÊÇVBA,ASPÖ±½Ó¿ÉÒÔÓÃODBC¡¢ADO·ÃÎÊExcel.
<%@ LANGUAGE= "VBSCRIPT " %>
<%option explicit%>
<HTML>
<HEAD>
<meta content= "text/html; charset=gb2312 " http-equiv= "Content-Type ">
<TITLE> Éú³ÉEXCELÎļþ </TITLE>
</HEAD>
<body>
<a href= "dbtoexcel.asp?act=make "> Éú³ÉEXCELÎļþ </a>
<hr size=1 align=left width=300px>
<%
if Request( "act ") = " " then
Response.Write "Éú³ÉEXCELÎļþ "
else
dim conn,strconn
strconn= "driver={SQL Server};ser
Ïà¹ØÎÊ´ð£º
aspÐéÄâÖ÷»úʵÏÖα¾²Ì¬µÄ·½·¨£º
1¡¢ ÖØÐ´url²ÎÊý
Step1: ½¨Á¢Ç°Ì¨Îļþindex.asp£¬ÐÞ¸Äurl²ÎÊýÐÎʽ¡£ÓÉÓÚ¶ÁÈ¡Êý¾Ý¿âÖеļǼ²»ÊÇרÌâµÄÖØµã£¬¹ÊÖ±½Ó¸ø³ö:
<!--#include file="config.asp" -->
&l ......
¾ÍÊÇÒ»¸ö°´Å¥£¬µã»÷Ö®ºó´ò¿ª¶Ô»°¿ò£¬È»ºóѡȡͼƬ¡£¾ÍÕâÑùÉÏ´«¡£¡£
ÔõôʵÏÖ¡£ÔÚÍøÉÏËѵ½ÄÇô¶àµÄ´úÂ룬ȫÊǺܶàµÄÄÇÖÖ£¬²»ÖªµÀ£¬¿´²»ÏÂÈ¥¡£
ËùÒÔÔÚÕâÀïÏëÇë´ó¸ç´ó½ã°ï°ïæ¡£
ʹÓÃ×Ô´øµÄfileupload¿Ø¼þ¿ÉÒÔʵÏÖ ......
¹ØÓÚÍøÕ¾°²È«µÄÎÊÌ⣡
ÎÒÁ˽⵽µÄÍøÕ¾°²È«ÎÊÌâ°üÀ¨£º
sql×¢Èë©¶´ºÍ±©¿â©¶´»¹ÓÐÉÏ´«Â©¶´
³ýÁËÕâЩ»¹ÓÐÆäËûµÄ©¶´Ã´£¿
×¢Èë©¶´¿ÉÒÔͨ¹ý¹ýÂËÀ´·ÀÖ¹
±©¿â©¶´Ôõô·ÀÖ¹
»¹ÓÐÈËÉÏ´«µÄľÂíÊÇ.gif
ÕâÖÖ©¶´Ôõôȥ± ......
<tr>
<td width="700" valign="top" align="left">
<!--¼ÓÔØÊý¾Ý¿â²úÆ·Áбí°üº¬·ÖÒ³´úÂ뿪ʼ -->
<tabl ......
¹ØÓÚ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× ......