Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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Éý¼¶µ½asp.net£¬ºÃ¶à½á¹¹¶¼²»ÖªµÀÈçºÎת»»

aspÏÂÃæ£¬µ±Òª¸ù¾Ý²»Í¬µÄȨÏÞÏÔʾһЩ¹¦Äܰ´Å¥µÄ»°»áд³É
<%
if ȨÏÞ=1 then
%>
<input type="submit" name="Submit" value="Ìá½»" />
<%
end i ......

asp.netÖÐ×Ô¶¨ÒåÀà¿âµÄÎÊÌâ

Èçͼ

ÎÒµÄÒ»¸öSolutionÀï°üº¬Á½¸öProject£¬Ò»¸öÊÇC#Àà¿â¹¤³Ì£¬Ò»¸öÊÇASP.NETÓ¦Óã¬Á½¸ö¹¤³Ì¶¼ÊÇͨ¹ýLinq to SqlÀ´²Ù×÷Êý¾Ý¿â£¬ÏÖÔÚµÄÎÊÌâÊÇÔÚ¸ø¿Í»§Ê¹ÓõÄʱºò£¬Ã»·¨Áé»îÅäÖÃSql·þÎñÆ÷µÄÐÅÏ¢£¬²éÁËÏ£¬Ê¹ÓÃDe ......

asp.netÖеĹÖÒìÎÊÌ⣿

asp.netÖÐAÁ´½Ó´«ÖÐÎÄÖµ£¬½ÓÊÕʱÂÒÂ룡

ÔÚÓÐЩµçÄÔÉÏÄÜÕý³£½ÓÊÕ£¬µ«ÓÐЩµçÄÔÉÏÈ´²»ÄÜÕý³£½ÓÊÕ£¬

ÇëÎʸ÷λÓÐûÓÐʲô·½·¨£¿
ÓÃsession£¬»òÕ߸ü¸Ä±àÂ룬

default.aspx
C# code:

this.Redirec ......

asp.net×Ô¶¯Éú³É´úÂë

³õѧasp.net,дÈý²ã¼Ü¹¹£¬¸Ð¾õºÜÃÔã¡£¸Ð¾õдµÄ¶¼ÊÇÒ»ÑùµÄ¶«Î÷£¬È´ÒªÀ˷Ѻó¤Ê±¼ä£¬Ìý˵ÓÐ×Ô¶¯Éú³É´úÂëµÄ¶«Î÷£¬ÏëѯÎÊһϴó¼Ò£¬´ó¼ÒÔÚÏîÄ¿ÖÐÊÇÔõôдÕâЩ´úÂëµÄ¡£


ÁíÍâÌý˵php¿ò¼ÜÐ´ÍøÕ¾ºÜÈÝÒ×£¬´úÂë¶¼Ê ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ