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
Ïà¹ØÎĵµ£º
×î½üÔÚasp.net Óõ½µÄsqlserver´æ´¢¹ý³Ì·ÖÒ³ÖÐÏÔʾÊý¾ÝʱÓöµ½¹ØÓÚÅÅÐòÎÊÌâ¡£
ÍøÉϵÄһЩ·ÖÒ³´æ´¢¹ý³ÌÖ»Ö§³ÖÅÅÐòÁÐΪint ÀàÐÍ£¬¶ÔÓÚʵ¼Ê¿ª·¢Öкܶàʱºò¶¼ÐèÒª¶ÔDateTimeÀàÐÍ£¬varcharÀàÐͽøÐÐÅÅÐò¡£
ÏÂÃæ·ÖÏíһϿÉÒÔÖ§³ÖÈÎÒâÊý¾ÝÀàÐ͵ÄÁнøÐÐÅÅÐòµÄ´æ´¢¹ý³Ì¡£
Create PROCEDURE sp_viewByPage
@TblName var ......
ÔÚʹÓÃAJAX½øÐгÌÐò¿ª·¢µÄʱºò£¬Ò»Ö±¶¼»áÃæ¶ÔÒ»¸ö»º´æµÄÎÊÌ⣡£¡
¼´ÊÇ£¬ÉÏ´ÎÇëÇóµÄʱºò£¬ÒòΪÄãµÄSQLÓï¾ä»òÕ߯äËûÔÒò£¬webserviceÖзµ»ØÖµÎª¿Õ£¬²»ÊÇÄãÏëÒªµÄ½á¹û¼¯£¬ÔÚÄã·¢ÏÖwebserviceÖÐÓï¾äÌå³ö´íºó£¬½øÐÐÐ޸ģ¬ÖØÐ²âÊÔ£¬ÈÔÈ»ÊÇÉϴεķµ»Ø½á¹û£¡¸Ð¾õ¾ÍÏñÄãµÄÐÞ¸ÄÍêÈ«ÎÞЧ¡£¡£
Æäʵ£¬ÕâÊÇÔÚAJAXµ ......
¿ØÖÆÍøÕ¾·Ö±æÂÊ ÎÒÃÇ¿ÉÒÔ Óà 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" /> ......
Õû¸öSQLºÍAsp.net(vb.net)Ò»Æð´ò°üµÄÈ«¹ý³ÌдһÏ¡£
Ò».×¼±¸±ØÒªµÄÎļþ
1. SQL½Å±¾Îļþ£¬Éú³ÉÒÔºó°²×°¹ý³ÌÖÐÐèÒªµÄ±íºÍ´æ´¢¹ý³ÌµÈµÈ£»
Éú³ÉÖ®ºó£¬¾ÍÔÝʱ°ÑËüÃüÃûΪdb.sql(×¢Òâ´óСд)
2.LisenceFile.rtfµÄ°²×°Îļþ£¬ÒòΪÎÒµÄϵͳÊǸöÈ˵쬶øÇÒfreeµÄ£¬ËùÒÔ¾ÍûÓÐ×ö¡£Õâ¸öÒÔºóÒ²ÊÇÒªÓõ½µÄ¡£
¶þ.ÔÚ×Ô¼ºÏÖÓеÄÏîÄ¿Àïà ......
PRB£ºÔÚʹÓà Response.End¡¢Response.Redirect »ò Server.Transfer ʱ³öÏÖ ThreadAbortException
Ö¢×´
Èç¹ûʹÓà Response.End¡¢Response.Redirect »ò Server.Transfer ·½·¨£¬½«³öÏÖ ThreadAbortException Òì³£¡£Äú¿ÉÒÔʹÓà try-catch Óï¾ä²¶»ñ´ËÒì³£¡£
ÔÒò
Response.End ·½·¨ÖÕÖ¹Ò³µÄÖ´ÐУ¬²¢½«´ËÖ´ÐÐÇл»µ½Ó¦ÓóÌÐò ......