aspµ¼³ö
ÀûÓÃaspÀ´µ¼³öÎļþµ½excel£¬²»ÐèÒªoffice×é¼þ£¬ÈçºÎ×ö£¿Ð»Ð»£¡ÄÜÌṩ¸ö²Î¿¼µÄÍøÖ·¡£¡£
http://www.mscto.com/aspnet/2009021435632.html
Â¥Éϵģ¬ÎÒ²»ÐèÒªÓÃowc£¬´ïµ½µ¼³öµ½excelµÄ¹¦ÄÜ£¬²¢ÇÒÄÜͨ¹ý´úÂëÀ´×Ô¶¨Òåµ¼³öµÄÑùʽµÄ¡£
ÔÚÎļþÍ·²¿Ìí¼Ó
<%response.ContentType ="application/vnd.ms-excel"%>
<% Response.AddHeader "Content-Disposition", "attachment; filename=ÎļþÃû"%>
ÒýÓÃ
ÔÚÎļþÍ·²¿Ìí¼Ó
<%response.ContentType ="application/vnd.ms-excel"%>
<% Response.AddHeader "Content-Disposition", "attachment; filename=ÎļþÃû"%>
¾Í´ï²»µ½¿ÉÒÔ¼°¶¨ÖÆ×Ô¼ºÑùʽµÄexcelÎļþÁË¡£
¶¥Ò»ÏÂ
Ïà¹ØÎÊ´ð£º
HTML code:
dim jf
set conn=server.createobject("adodb.connection")
connstr="Driver={Sql Server};Server="&Sqlip&";Database="&Sqldb&";Uid="& ......
ÎÒÓÐÒ»¸öaspÔ´Â룬µ«ÊdzöÏÖÒ»¸öÎļþ£¬ÎÒÓÃasp½âÃܶ¼ÊÇÂÒÂë
Çë½Ì
VBScript code:
??
%# , #&')*)-0-(0%()(?
(((((((((((((((((((((((((( ......
ÎÒ×°µÄÊÇwindows7 £¬Êý¾Ý¿âÏëÓÃsql server 2008Á¬asp£¬²»¹ýÎÒ²»ÖªµÀsql server 2008µÄÓû§ÃûºÍÃÜÂëÁË£¬ÏëÓÃwinÑéÖ¤£¬ÊÔÁ˼¸±éû³É¹¦£¬Çë´ó¼Ò°ïæ¡£
˳±ãÎÊһϣ¬ÎÒÔõôÄܲé³öÀ´×Ô¼ºsql 2008µÄÓû§Ã ......
ÎÒÓÃVB°´MVCµÄ¹¹¼Üд×é¼þ¹©ASPµ÷ÓÃ
BLL²ã
VB code:
Private Dal As New moonPotato_DAL
Public Sub inSertUser(Model As moonPotato_Model)
Dal.InSertCls (Model)
End Sub
ASPÖе÷ÓÃ
VB c ......
Function listPages(LinkFile)
if not (rs.eof and rs.bof) then
gopage=currentpage
totalpage=n
blockPage=Int((gopage-1)/10)*10+1
If LCase(Request.ServerVariables("HT ......