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·ÖÖپͿÉÒÔ
Ïà¹ØÎÊ´ð£º
aspÏÂÃæ£¬µ±Òª¸ù¾Ý²»Í¬µÄȨÏÞÏÔʾһЩ¹¦Äܰ´Å¥µÄ»°»áд³É
<%
if ȨÏÞ=1 then
%>
<input type="submit" name="Submit" value="Ìá½»" />
<%
end i ......
Èçͼ
ÎÒµÄÒ»¸öSolutionÀï°üº¬Á½¸öProject£¬Ò»¸öÊÇC#Àà¿â¹¤³Ì£¬Ò»¸öÊÇASP.NETÓ¦Óã¬Á½¸ö¹¤³Ì¶¼ÊÇͨ¹ýLinq to SqlÀ´²Ù×÷Êý¾Ý¿â£¬ÏÖÔÚµÄÎÊÌâÊÇÔÚ¸ø¿Í»§Ê¹ÓõÄʱºò£¬Ã»·¨Áé»îÅäÖÃSql·þÎñÆ÷µÄÐÅÏ¢£¬²éÁËÏ£¬Ê¹ÓÃDe ......
asp.netÖÐAÁ´½Ó´«ÖÐÎÄÖµ£¬½ÓÊÕʱÂÒÂ룡
ÔÚÓÐЩµçÄÔÉÏÄÜÕý³£½ÓÊÕ£¬µ«ÓÐЩµçÄÔÉÏÈ´²»ÄÜÕý³£½ÓÊÕ£¬
ÇëÎʸ÷λÓÐûÓÐʲô·½·¨£¿
ÓÃsession£¬»òÕ߸ü¸Ä±àÂ룬
default.aspx
C# code:
this.Redirec ......
³õѧasp.net,дÈý²ã¼Ü¹¹£¬¸Ð¾õºÜÃÔã¡£¸Ð¾õдµÄ¶¼ÊÇÒ»ÑùµÄ¶«Î÷£¬È´ÒªÀ˷Ѻó¤Ê±¼ä£¬Ìý˵ÓÐ×Ô¶¯Éú³É´úÂëµÄ¶«Î÷£¬ÏëѯÎÊһϴó¼Ò£¬´ó¼ÒÔÚÏîÄ¿ÖÐÊÇÔõôдÕâЩ´úÂëµÄ¡£
ÁíÍâÌý˵php¿ò¼ÜÐ´ÍøÕ¾ºÜÈÝÒ×£¬´úÂë¶¼Ê ......