asp.net·ÖÒ³ Àà¡£
˸øÒ»¸ö°¡£¿
google aspnetpager·ÖÒ³¿Ø¼þ
·ÖÒ³´æ´¢¹ý³Ì
aspnetpager,×Ô´øµÄ¿Ø¼þdatapager
Select TOP Ò³´óС *
from TestTable
Where (ID >
(Select MAX(id)
from (Select TOP Ò³´óС*Ò³Êý id
from ±í
orDER BY id) AS T))
orDER BY ID
²Î¿¼
create procedure Pager
@sqlstr nvarchar(4000),
@currentpage int,
@pagesize int
as
set nocount on
declare @P1 int,
@rowcount int
exec sp_cursoropen @P1 output,@sqlstr,@scrollopt=1,@ccopt=1,@rowcount=@rowcount output
select ceiling(1.0*@rowcount/@pagesize) as ×ÜÒ³Êý--,@rowcount as ×ÜÐÐÊý,@currentpage as µ±Ç°Ò³
set @currentpage=(@currentpage-1)*@pagesize+1
exec sp_cursorfetch @P1,16,@currentpage,@pagesize
exec sp_cursorclose @P1
set nocount off
aspnetpager
aspnetpager
aspnetpager
aspnetpager Õâ¸ö·ÖÒ³µÄ¿Ø¼þÊDZȽϺÃÓõģ¡ÍøÉÏÒ²±È½ÏÁ÷Ðеģ¡¿´¿´ÄãµÄÊý¾ÝÁ¿´ó²»´ó£¬Èç¹û´óµÄ»°ÄÇô¿ÉÒÔ½áºÏ´æ´¢¹ý³ÌÒ»ÆðʹÓ㬲»È»µÄ»°¾ÍÖ±½ÓÓúÃÁË£¡ÕæµÄºÜ·½±ã£¡
Èç¹ûÊý¾Ý¿âµÄÊý¾ÝÁ¿ºÜ´óµÄ»°¾ÍʹÓÃSQL½øÐзÖÒ³£¬
ÕâÑùЧÂʸߵ㣬
Èç¹ûÊý¾Ý¿â²»ÊǶàµÄ»°¾ÍʹÓÃÄÚÖõÄPageDateSource,
Èç¹û²»ÖªµÀÔõôʹÓõϰ¿ÉÒÔ×Ô¼ºÐ´Ò»¸ö·ÖÒ³Àࣺ
ÎÞ·ÇÊÇ´ÓÊý¾Ý¿âÀïÈ¡³öËùÓеÄÊý¾Ý´æ·ÅÔÚ¼¯ºÏÄÚ£¬
È»ºó¸ú¾ÝÒ³µÄË÷Òý¶Ô¸Ã¼¯ºÏ½øÐнؽø£¬
×Ô¼º½ø½ø£¬2·ÖÖپͿÉÒÔ
Ïà¹ØÎÊ´ð£º
ÎÒÔÚÒ»¸öASPXÒ³ÃæÖÐÓà <!-- #include file="top.asp"-->ǶÌ×ÁËÒ»¸öaspÒ³Ãæ£¬µ«ÔÚµã»÷°´Å¥Ìá½»±íµ¥µÄʱºòûÓÐÈκη´Ó¦£¬ÊDz»ÊÇÁ½¸öFORMµÄÔÒòÔì³ÉµÄ£¬top.aspÀïÃæÒ²ÓÐÒ»¸öform£¬°ÑǶÌ×È¥µôµÄ»°£¬ÔËÐÐ ......
ÎÒÓÃÏÂÃæµÄ·½Ê½µ¯³ö¶Ô»°¿ò
RegisterStartupScript("js", " <script>alert('¶Ô²»ÆðÄúûÓиÃȨÏÞ') </script>");
È»ºóÎÒÔÙË¢ÐÂÒ³Ãæ£¬Ò³Ãæ»áÌáʾ£º¡°²»ÖØÐ·¢ËÍÐÅÏ¢ ......
asp.netÔõÑùÁ¬½ÓÊý¾Ý¿â°¡£¿»¹ÐèʹÓÃVB.NET±à³Ì£¿
¿´¿´ADO.NET°É£¬ÕâÊǺËÐÄ
ÔÚWeb.configÖÐдÁ¬½Ó×Ö·û´®£¬ÄãÔÚÀàÀïдҲÐÐ
ллÀ²£¬ÎһῴµÄ¡£
²»ÐèʹÓÃVB.NET±à³Ì£¬ÐèÒªADO.net
·½·¨Óкܶ࣬×Ô¼ ......
±¾È˳õѧAsp.net£¬ÓÃVS2008£¬ÒÔǰÓÃJSP×öÒ³Ãæ¿ò¼Üʱ£¬ÊÇÓÃFramesetµÄ£¬µ«ÊÇVS2008µÄAsp.netʹÓÃXHTML1.0£¬²»Ö§³ÖFrameset¡£´ó¼ÒÔÚ×ö×óÓÒÒ³Ãæ»òÕßÉÏÏÂÒ³ÃæÊ±£¬ÊÇÔõô×öµÄÄØ£¿
Ôõô²»Ö§³Ö¡£
ÎÒÕâ¸ö¾ÍÊÇÒ»¸ö¿ò¼ÜÒ³¡ ......