ASP.NETÈçºÎµ¼³öexcel£¨Ò»£©
ÔÎÄ£ºÁõÎä|ASP.NETÈçºÎµ¼³öexcel£¨Ò»£©
ASP.NETÖе¼³öexcelµÄ·½·¨ºÜ¶à£¬×î¼òµ¥µÄ¾ÍÊÇÀûÓ÷þÎñÆ÷¿Ø¼þµÄRenderControl·½·¨£¬Ëû¿ÉÒÔ°Ñ·þÎñÆ÷¿Ø¼þµÄÄÚÈÝ×÷ΪÁ÷Êä³öµ½¿Í»§¶Ë£¬¿ÉÒÔÓø÷½·¨Êä³öÕû¸öÒ³Ãæ£¬Ò²¿ÉÒÔÊä³öµ¥¶ÀµÄ¿Ø¼þ¡£µ¥±ØÐë×¢ÒâʹÓø÷½·¨Ê±±ØÐëÖØÔØ VerifyRenderingInServerForm º¯Êý£¬·ñÔò¾Í»á³ö´í¡£ÒÔÏÂÊDzο¼´úÂ룺
DEMO.ASPX:
ASP.NET-Code:
<asp:GridView ID="gv1" runat="server" AutoGenerateColumns="false">
<Columns>
<asp:BoundField DataField="Name" HeaderText="Name" />
<asp:BoundField DataField="Date" HeaderText="Date"
DataFormatString="{0:yyyy-MM-dd}" />
<asp:BoundField DataField="Number" HeaderText="Number"
DataFormatString="{0:#,###.00}" />
</Columns>
</asp:GridView>
<asp:Button ID="btnExport" runat="server" Text="µ¼³ö"
OnClick="btnExport_Click" />
DEMO.ASPX.CS:
C#-Code:
class Item
{
string _name;
public string Name
{
set { _name = value; }
get { return _name; }
}
DateTime _date;
public DateTime Date
{
set { _date = value; }
get { return _date; }
}
decimal _number;
public decimal Number
{
&nb
Ïà¹ØÎĵµ£º
ÔÚc# / ASP.netÖÐÎÒÃÇ¿ÉÒÔͨ¹ýʹÓÃDataTimeÕâ¸öÀàÀ´»ñÈ¡µ±Ç°µÄʱ¼ä¡£Í¨¹ýµ÷ÓÃÀàÖеĸ÷ÖÖ·½·¨ÎÒÃÇ¿ÉÒÔ»ñÈ¡²»Í¬µÄʱ¼ä£ºÈ磺ÈÕÆÚ£¨2008-09-04£©¡¢Ê±¼ä£¨12£º12£º12£©¡¢ÈÕÆÚ+ʱ¼ä£¨2008-09-04 12£º11£º10£©µÈ¡£
//»ñÈ¡ÈÕÆÚ+ʱ¼ä
DateTime.Now.ToString(); // 2008- ......
Asp.net ×Ô¶¯·¢ËÍÓʼþµÄ·½·¨
½ñÌìÓÐÒ»¸öÄ£¿éÐèÒª×Ô¶¯·¢ËÍÓʼþµÄ¹¦ÄÜ£¬¾ÍËæ±ãдÁËÒ»¸ö£¬¼Ç¼һÏÂ×÷Ϊ»ýÀÛ¡£
Ò»¡¢Ê×ÏÈÐèÒªÅäÖÃweb.configÎļþ£º
<system.net>
<mailSettings>
<smtp from="Emailname">
<network ho ......
Õû¸öSQLºÍAsp.net(vb.net)Ò»Æð´ò°üµÄÈ«¹ý³ÌдһÏ¡£
Ò».×¼±¸±ØÒªµÄÎļþ
1. SQL½Å±¾Îļþ£¬Éú³ÉÒÔºó°²×°¹ý³ÌÖÐÐèÒªµÄ±íºÍ´æ´¢¹ý³ÌµÈµÈ£»
Éú³ÉÖ®ºó£¬¾ÍÔÝʱ°ÑËüÃüÃûΪdb.sql(×¢Òâ´óСд)
2.LisenceFile.rtfµÄ°²×°Îļþ£¬ÒòΪÎÒµÄϵͳÊǸöÈ˵쬶øÇÒfreeµÄ£¬ËùÒÔ¾ÍûÓÐ×ö¡£Õâ¸öÒÔºóÒ²ÊÇÒªÓõ½µÄ¡£
¶þ.ÔÚ×Ô¼ºÏÖÓеÄÏîÄ¿Àïà ......
ÔÚweb¿ª·¢ÖÐ,¾³£ÒªÓõ½¿Ø¼þµÄOnClientClickÓëOnClickʼþ.
Èç¹ûʹÓò»µ±,¾³£»áÓöµ½Ò»Ð©ÒâÁÏÖ®ÍâµÄÊÂÇé·¢Éú,ÈÃÈËÃþ²»×ÅÍ·ÄÔ.ÏÂÃæ¾Í½«ÎÒµÄһЩСС×ܽáµÀÀ´:
Ê×ÏÈÎÒÃÇÒªÁ˽âÕâÁ½¸öʼþ:
OnClientClickÊǿͻ§¶Ëʼþ·½·¨.Ò»°ã²ÉÓÃJavaScriptÀ´½øÐд¦Àí.Ò²¾ÍÊÇÖ±½ÓÔÚIE¶ËÔËÐÐ.Ò»µã»÷¾ÍÔËÐÐ.
OnClickʼþÊÇ·þÎñÆ÷¶Ëʼþ´¦Àí ......