Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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ÎļþÁË¡£

¶¥Ò»ÏÂ


Ïà¹ØÎÊ´ð£º

ASPÅжϵÄÎÊÌâ,ÓôÃÆÁË!Åжϲ»³öÀ´!

HTML code:

dim jf
set conn=server.createobject("adodb.connection")
connstr="Driver={Sql Server};Server="&Sqlip&";Database="&Sqldb&";Uid="& ......

ASP¼òµ¥ÎÊÌâ

conn.asp

<%
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source="&server.MapPath("Connt ......

ASP¶à±í²éѯ£¬Ò»¶Ô¶à

ÎÒÒª²éѯÁ½ÕűíµÄÊý¾Ý£¬Ò»ÕűíÒ»ÌõÊý¾Ý¶ÔÓ¦ÁíÒ»ÕűíµÄ¶àÌõÊý¾Ý£¬SQLÊý¾Ý¿â
±í1£º                ±í2£º
id  name ...          ctrI ......

¼Ùǰ×îºóÒ»ÌûASPµ÷ÓÃVB×é¼þ

ÎÒÓÃ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 ......

ASPÊÇÔõÑùÅжÏÒ»¸öÓû§ÊÇ·ñÁ¬½ÓµÄÄØ

ÎÒÔÚÒ»¸öä¯ÀÀÆ÷Àï,ÓõÚÒ»¸öÓû§µÇ¼ÁËÒ»¸öÍøÕ¾,È»ºóµã"Í˳öµÇ¼",È»ºóÓÖÓõڶþ¸öÓû§µÇ¼ÁËÕâ¸öÍøÕ¾,ÔÙµã"Í˳ö"

×¥°ü¿´µ½µÄ½á¹ûÊÇ,µÚÒ»´Î·¢Ë͵ÄPOSTÇëÇóÖÐ,httpÍ·²¿Ã»ÓдøCOOKIE×Ö¶Î,·þÎ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ