asp ÖÐÊý¾Ýµ¼³öΪ word £¬excl £¬text £¬µÈ¸ñʽÎļþ
ÕâÊÇ´Ó·½·¨Ö±½Ó¸´ÖƵģ¬
²ÎÊý fileTypeÊÇÎļþ¸ñʽ
²ÎÊýfiledNameÊÇд³öºóÎļþµÄÎļþÃû¡£
²ÎÊýsuffixÊÇд³öºóÎļþµÄÎļþºó׺Ãû¡£
Response.Clear(); //Çå¿Õ »º³åÇøµÄËùÓÐÊä³öÊý¾Ý
Response.Charset = "utf-8";//ÉèÖÃÊä³öÊä³öÁ÷×Ö·ûÀàÐÍ
Response.ContentType = fileType;ÉèÖÃÊä³öÁ÷µÄ file MIMEÀàÐÍ
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(fileName) + suffix);//½«HTTP Í·Ìí¼Óµ½Êä³öÁ÷£¬“+”ÒÔǰÊǹ̶¨µÄ ×Ö·û´®Á¬½ÓÊÇΪÁËдÎļþÃûºÍÎļþºó׺Ãû
Response.Write("<html><head><Meta http-equiv=\"Content-Type\"content=\"text/html;charset=utf-8\"></head><body>");
Response.Write("<h1>"+article.Title+"</h1><p/>"+article.Context);
Response.Write("</body></html>");
//ÎļþÄÚÈÝ
Response.End();
//¹Ø±Õ
µ±µ¼³öµÄÎļþΪ Îı¾¸ñʽʱ Response.Write(" ")ÖоͲ»±ØÐ´ÈëHTML´úÂ룬Èç¹ûдÈëÁË£¬Îı¾ÄÚÈÝ»á³öÏÖ HTML
Response.ContentType ="application/ms-excel";ÊÇexcel
Response.ContentType ="Content-Disposition";ÊÇword
Ïà¹ØÎĵµ£º
<%
If Not IsNull(Request("fileName")) Then r = DownLoadFile(Request("fileName"))
Function DownLoadFile(fileName)
Dim s,fso,f,fLen
fileName = Server.MapPath(fileName)
'create stream
Set s = Server.CreateObject("ADODB.Stream")
s.Open()
s.Type = 1
Set fso = Server.CreateObject ......
ÔÚInterDevÖÐʵÏÖÍøÉϹºÎïÍÆ³µ(1)
¡¡±¾ÎĽ«½éÉÜÔÚInterDevÖÐʵÏÖÍøÉÏÉ̵깺Îï³µ¹¦Äܵķ½·¨£¬¾ßÌå²½ÖèÈçÏ£º
¡¡¡¡Ò»¡¢ Êý¾Ý¿â½á¹¹£º
¡¡¡¡²úÆ·Êý¾Ý±í(Products): ´æ·Å²úÆ·ÐÅÏ¢
²úÆ·Ãû ProductName
²úÆ·±àºÅ ProductID
µ¥¼Û Price
·ÖÀà±àºÅ CategoryID
¡¡¡¡ Cart£º¹ºÎï³µÊý¾Ý±í£¬ÁÙʱ´æ·Å¿Í»§µÄ¶ ......
ÓÃASP½¨Á¢Õ¾ÄÚÐÅÏ¢ËÑË÷ϵͳ
¡¡¡¡¼ÙÈçÄãÓµÓÐÒ»¸öÅÓ´óµÄÍøÕ¾£¬ÄÚÈÝÓֶ࣬ÄÇôÀ´·ÃÕßÍùÍùºÜÄÑÕÒµ½×Ô¼ºËùÐèÒªµÄ¶«¶«£¬ÕâʱºòÄã¾ÍÐèÒªÒ»¸öÕ¾ÄÚËÑË÷À´°ïÖúÀ´·ÃÕ߸ü¿ìµÄÕÒµ½Ë÷ÒªµÄ×ÊÁÏÁË£¡ÏÖÔÚÄã¾Í¿ÉÒÔÓÃaspÇáÒ×µÄʵÏÖÕâÖÖ¹¦ÄÜ£¬ºÎ¿öÏÖÔÚÖ§³ÖaspµÄÕ¾µãÕâô¶à£¬ÀûÓÃÕâ¸öËÑË÷ÒýÇæ¿ÉÒÔËÑË÷µ½ÄãµÄÖ÷Ò³ÀïÃæÈκÎÒ»¸öÎļþ ......
ASPÍòÓ÷ÖÒ³³ÌÐò
¡¡¡¡ÕâÖ»ÊǸöaspС¼¼ÇÉÀàµÄ¶«Î÷£¬ËüËäÈ»ÊʺÏÔÚÿ¸ö²»Í¬ÎļþÃûÀïµ÷ÓÃÕâ¸öº¯Êý£¬µ«ÊÇÒ²ÊÇÓÐǰÌáµÄ£¬ÏÂÃæÈÃÎÒÃÇÀ´×Ðϸ¿´¿´ÆäÖеÄÔί¡£
¡¡¡¡ÏÂÃæÕâ¶ÎÊÇ»ù±¾µÄ·ÖÒ³´úÂ룺
£¼% sql = "select……………………Ê¡ÂÔÁËsqlÓï¾ä
¡¡Set rs=Server ......
ºǫ́Êý¾Ý¿â£º
[Microsoft Access]
Óë
[Microsoft Sql Server]
¸ü»»Ö®ºó£¬ASP´úÂëӦעÒâÒªÐ޸ĵÄһЩµØ·½£º
[Ò»]Á¬½ÓÎÊÌ⣨¾ÙÀý)
[Microsoft Access]
constr = "DBQ=c:\data\clwz.mdb; DRIVER={Microsoft Access Driver (*.mdb)}"
[Microsoft Sql Server]
constr = "DRIVER={SQL Server};SERVER=host;DATA ......