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 Óõ½µÄsqlserver´æ´¢¹ý³Ì·ÖÒ³ÖÐÏÔʾÊý¾ÝʱÓöµ½¹ØÓÚÅÅÐòÎÊÌâ¡£
ÍøÉϵÄһЩ·ÖÒ³´æ´¢¹ý³ÌÖ»Ö§³ÖÅÅÐòÁÐΪint ÀàÐÍ£¬¶ÔÓÚʵ¼Ê¿ª·¢Öкܶàʱºò¶¼ÐèÒª¶ÔDateTimeÀàÐÍ£¬varcharÀàÐͽøÐÐÅÅÐò¡£
ÏÂÃæ·ÖÏíһϿÉÒÔÖ§³ÖÈÎÒâÊý¾ÝÀàÐ͵ÄÁнøÐÐÅÅÐòµÄ´æ´¢¹ý³Ì¡£
Create PROCEDURE sp_viewByPage
@TblName var ......
¿ØÖÆÍøÕ¾·Ö±æÂÊ ÎÒÃÇ¿ÉÒÔ Óà frameset
ËäÈ» asp.net²»Ö§³ÖÕâ¸öÊôÐÔ µ«Êǹ¦ÄÜÊÇ¿ÉÒÔʵÏÖµÄ
Èç £º
<frameset name="main" rows="105,*" frameborder="no" border="0" framespacing="0">
<frame src="xx.aspx" name="topFrame" scrolling="No" noresize="noresize" id="topFrame" title="topFrame" /> ......
ÔÚasp.netÀïÃæ£¬ºÜ¶àʱºòʹÓÃsessionÀ´±£´æÒ»Ð©¶ÔÏ󣬱ÈÈç˵¹ºÎï³µµÈµÈ£¬Óкܶàʱºò£¬¾ÍËãÄãÉèÖÃÁËsession³¬Ê±µÄʱ¼ä£¬session»¹ÊÇ»áÎÞÔµÎ޹ʵĶªÊ§£¬ÕâÀïÓÐÒ»ÖֱȽϼòµ¥µÄ·½·¨¿ÉÒÔÉèÖÃsession¶ªÊ§µÄʱ¼ä¡£
ÔÚweb.configÀïÃæÈçÏÂÅäÖÃ
<sessionState
& ......
Õû¸öSQLºÍAsp.net(vb.net)Ò»Æð´ò°üµÄÈ«¹ý³ÌдһÏ¡£
Ò».×¼±¸±ØÒªµÄÎļþ
1. SQL½Å±¾Îļþ£¬Éú³ÉÒÔºó°²×°¹ý³ÌÖÐÐèÒªµÄ±íºÍ´æ´¢¹ý³ÌµÈµÈ£»
Éú³ÉÖ®ºó£¬¾ÍÔÝʱ°ÑËüÃüÃûΪdb.sql(×¢Òâ´óСд)
2.LisenceFile.rtfµÄ°²×°Îļþ£¬ÒòΪÎÒµÄϵͳÊǸöÈ˵쬶øÇÒfreeµÄ£¬ËùÒÔ¾ÍûÓÐ×ö¡£Õâ¸öÒÔºóÒ²ÊÇÒªÓõ½µÄ¡£
¶þ.ÔÚ×Ô¼ºÏÖÓеÄÏîÄ¿Àïà ......