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

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+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

asp µ÷ÓÃjavaдµÄwebservice - Web ¿ª·¢ / ASP

ÔÚaspÀïÔõôµ÷ÓÃjavaдµÄwebservice·½·¨£¬Óкܶ෽·¨
- <message name="RtPnrIn">
  <part name="bstrPnrNO" type="s:string" /> 
  <part name ......

asp.netµ¼³öEXCELÎÊÌ⣡ - .NET¼¼Êõ / ASP.NET

C# code:

SqlConnection conn = CsDB.sqlcon();
SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......

WapµÄÒ»¸ö¾ÞÍ·ÌÛµÄÎÊÌ⣡ - .NET¼¼Êõ / ASP.NET

ÎÒÓÃasp.net¿ª·¢wapÕ¾µã£¬Íê³ÉºóÈ¥http://validator.w3.org/ÕâÀïÑéÖ¤ÎÒµÄWapÒ³ÃæÊÇ·ñ±ê×¼£¬ÆäËüÎÊÌâ¶¼¸ÄºÃÁË£¬
¾ÍÊ£ÕâÒ»¸ö´íÎóÁË£¬°´×ÖÃæÒâ˼Àí½âÊÇ˵nameÊôÐÔÒÑ´æÔÚ£¬ÀàËÆÕâÑùµÄ´íÎó»¹Óв»ÄÜÓÃborder ,align,sizeµ ......

asp.net Ò³ÃæÏÞʱÌá½» ÈçºÎʵÏÖ - .NET¼¼Êõ / ASP.NET

1.asp.net×öµÄÒ»¸ö´ðÌâÒ³Ãæ£¬ÈçºÎʵʱÏÞʱºó×Ô¶¯Ìá½»£¬Çë´ó¼Ò¸øµã˼·
ÏÞʱµÄʱ¼äÐÅÏ¢´æ·ÅÔÚÊý¾Ý¿âÖÐ
2.Èç¹û´ðÌâʱ¼äÉèÖõĽϳ¤£¬ÈçºÎ·½Ê½session³¬Ê±ºóÒ³ÃæÎÞЧ
лл
ÓÃjs·½·¨À´¿ØÖÆ
»Ø¸´ÄÚÈÝÌ«¶ÌÁË¡£¡£

js ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ