ASP.NETµÄHTMLTableÔÑùµ¼³öµ½Excel
ÎÄÕ³ö´¦£ºhttp://www.cnblogs.com/tomcat112906/articles/922639.html
ASP.NETµÄHTMLTableÔÑùµ¼³öµ½Excel
js´úÂë £º function PrintTableToExcelEx(objTab)
{
try
{
var xls = new ActiveXObject( "Excel.Application" );
}
catch(e)
{
alert( "Äú±ØÐë°²×°Excelµç×Ó±í¸ñÈí¼þ£¬Í¬Ê±ä¯ÀÀÆ÷ÐëʹÓÓActiveX ¿Ø¼þ”£¬ÄúµÄä¯ÀÀÆ÷ÐëÔÊÐíÖ´Ðпؼþ¡£ Çëµã»÷¡¾°ïÖú¡¿Á˽âä¯ÀÀÆ÷ÉèÖ÷½·¨£¡");
return false;
}
xls.visible = true;
var xlBook = xls.Workbooks.Add;
var xlsheet = xlBook.Worksheets(1);
var CurX = 1;
&nbs
Ïà¹ØÎĵµ£º
ÓÐÈËÒ²ÎÊÁ˸öÔÚÏßͳ¼ÆµÄÎÊÌ⣬ÎҵļûÒâÊÇÕâÑùµÄ£º
ÔÚApplication_StartʼþÖмÓÈëÒÔÏ´úÂ룺
Application.Lock();
Application.["UserCount"]=0;
Application.Unlock();
Session_Startʼ ......
ÔÚASP.NETÖУ¬Îļþ´¦ÀíµÄÕû¸ö¹ý³Ì¶¼ÊÇÎ§ÈÆ×ÅSystem.IO Õâ¸öÃû³Æ¿Õ¼äÕ¹¿ªµÄ¡£Õâ¸öÃû³Æ¿Õ¼äÖоßÓÐÖ´ÐÐÎļþ¶Á¡¢Ð´ËùÐèÒªµÄÀà¡£±¾ÎÄ´Ó×î»ù±¾µÄ²Ù×÷¿ªÊ¼£¬½âÊÍÔÚASP.NETÖÐÎļþ´¦ÀíµÄ¸ÅÄ°üÀ¨Èç´ÓÒ»¸öÎļþÖжÁÈ¡ÄÚÈÝ¡¢ÈçºÎÏòÒ»¸öÎļþÖÐдÈëÄÚÈݺÍÈçºÎɾ³ýÒ»¸öÎļþ¡£¡¡¡¡
Ç°ÃæÒѾÌáµ½£¬ÒªÏëÔÚASP.NET Ò³ÃæÖнøÐÐÎļþ´¦Àí£¬±ØÐ ......
SQL
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
--°¢»áéªsosuo8.com¸ù¾ÝÍøÂçÉϵĴúÂë½øÐÐÁËÐ޸쬰æÈ¨¹éÔ×÷ÕßËùÓÐ2009-4-5
--°¢»áéª×öÁËÒ»´ÎÉý¼¶£¬2009-9-27
--ÐÞ¸ÄÊä³ö×ܼǼÊý
ALTER PROCEDURE [dbo].[pagination]
@tblName nvarchar(1000), -- ±íÃû
......
Default.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
< ......
±¾ÈË¿ª·¢ASP.NETÒÑÓÐÁ½Äê¶àÁË¡£Ì¸ÆðASP.NETÕæÊÇÈÃÎÒ»¶Ï²ÈÃÎÒÓÇ¡£×òÌìÓÖ³öÏÖÁËÄǸöÆæ¹ÖµÄÎÊÌ⣬¾ÍÊÇÔÚÒ³ÃæÍêȫдºÃºó£¬ÖØÐÂÉú³Éʱ±¨:XXX(Ò³ÃæÃû)²»°üº¬(XXX)µÄ¶¨Òå¡£ÔÚCSÎļþÏÂÊÇ¿ÉÒÔÓà this.xxx д³öÀ´µÄ£¬Ò³ÃæÉÏҲûÎÊÌâ¡£ÔÚ½â¾ö·½°¸ÖÐÖØÐÂÉú³ÉÒ³ÓÖ¿ÉÒÔ£¬ÖØÐÂÉú³ÉÍøÕ¾¾Í»á±¨Õâ¸ö´íÎó¡£½«this.XXX ......