asp ·Ò³ÔõôʵÏÖ£¿ - .NET¼¼Êõ / ASP.NET
asp ·Ò³ÔõôʵÏÖ£¿
·ÖÒ³¿ÉʹÓ÷ÖÒ³¿Ø¼þÈçaspnetpager
ûÕÒµ½´Ë¿Ø¼þ£¡£¡£¡£¡£¡
µÚÈý·½×é¼þ ÐèÒªÔÚÍøÉÏÈ¥ÏÂÔØ http://www.webdiyer.com/Controls/AspNetPager/Downloads
²»Óÿؼþ Ôõô×ö°¡£¡
hehe
²»Óÿؼþ¿ÉÒÔ×Ô¼ºÐ´·ÖÒ³¿Ø¼þ£¬ÔÚ´æ´¢¹ý³ÌÖÐÿ´Î»ñȡָ¶¨Ò³ÊýµÄÊý¾Ý²¢·µ»Ø¡£Ò²¿ÉÒÔÓÃgridview×Ô´øµÄ·ÖÒ³¹¦ÄÜ£¬Õâ¸ö²»ÓÃд´úÂë¡£
²»Óÿռä¾ÍÓô洢¹ý³Ì·ÖÒ³°É¡£¡£¡£
C# code:
²âÊÔ£º15ÍòÌõÊý¾Ý,ÓÃʱ1s.
--=====µ÷ÓÃʾÀý====
declare @str varchar(200);
set @str = 'select * from t_user order by id'
exec pagination @str,4,2
--=====´æ´¢¹ý³Ì======
create procedure pagination
@sqlstr nvarchar(4000), --²éѯ×Ö·û´®
@currentpage int, --µÚNÒ³
@pagesize int --ÿҳÐÐÊý
as
set nocount on
declare @P1 int, --P1ÊÇÓαêµÄid
@rowcount int
exec sp_cursoropen @P1 output,@sqlstr,@scrollopt=1,@ccopt=1,@rowcount=@rowcount output
declare @totalPage int --×ÜÒ³Êý
set @totalpage = ceiling(1.0*@rowcount/@pagesize)
--Åжϵ±Ç°Ò³ÊÇ·ñ´óÓÚ×ÜÒ³Êý,Èç¹û´óÓÚ×ÜÒ³Êý.µ±Ç°Ò³¾ÍÊÇ×îºóÒ»Ò³
if (@currentpage>=@totalpage)
set @currentpage = @totalpage
if(@currentpage<1) --Èç¹ûµ±Ç°Ò³Ð¡ÓÚ1,ÔòĬÈϵ±Ç°Ò³ÊÇ1
set @currentpage=1
print 'µ±Ç°Ò³'
print @currentpage
select @totalpage as ×ÜÒ³Êý,@currentpage as µ±Ç°Ò³ ,@rowcount as ×ܼǼÊý--,@rowcount as ×ÜÐÐÊý,@current
Ïà¹ØÎÊ´ð£º
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
ÔÚaspÀïÔõôµ÷ÓÃjavaдµÄwebservice·½·¨£¬Óкܶ෽·¨
- <message name="RtPnrIn">
<part name="bstrPnrNO" type="s:string" />
<part name ......
C# code:
SqlConnection conn = CsDB.sqlcon();
SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......
ÎÒÓÃasp.net¿ª·¢wapÕ¾µã£¬Íê³ÉºóÈ¥http://validator.w3.org/ÕâÀïÑéÖ¤ÎÒµÄWapÒ³ÃæÊÇ·ñ±ê×¼£¬ÆäËüÎÊÌâ¶¼¸ÄºÃÁË£¬
¾ÍÊ£ÕâÒ»¸ö´íÎóÁË£¬°´×ÖÃæÒâ˼Àí½âÊÇ˵nameÊôÐÔÒÑ´æÔÚ£¬ÀàËÆÕâÑùµÄ´íÎó»¹Óв»ÄÜÓÃborder ,align,sizeµ ......
1.asp.net×öµÄÒ»¸ö´ðÌâÒ³Ãæ£¬ÈçºÎʵʱÏÞʱºó×Ô¶¯Ìá½»£¬Çë´ó¼Ò¸øµã˼·
ÏÞʱµÄʱ¼äÐÅÏ¢´æ·ÅÔÚÊý¾Ý¿âÖÐ
2.Èç¹û´ðÌâʱ¼äÉèÖõĽϳ¤£¬ÈçºÎ·½Ê½session³¬Ê±ºóÒ³ÃæÎÞЧ
лл
ÓÃjs·½·¨À´¿ØÖÆ
»Ø¸´ÄÚÈÝÌ«¶ÌÁË¡£¡£
js ......