Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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.netǶÌ×Ò»¸öaspÒ³Ãæºó³öÏÖµÄÎÊÌâ

ÎÒÔÚÒ»¸öASPXÒ³ÃæÖÐÓà <!-- #include file="top.asp"-->ǶÌ×ÁËÒ»¸öaspÒ³Ãæ£¬µ«ÔÚµã»÷°´Å¥Ìá½»±íµ¥µÄʱºòûÓÐÈκη´Ó¦£¬ÊDz»ÊÇÁ½¸öFORMµÄÔ­ÒòÔì³ÉµÄ£¬top.aspÀïÃæÒ²ÓÐÒ»¸öform£¬°ÑǶÌ×È¥µôµÄ»°£¬ÔËÐÐ ......

asp.netÍøÕ¾ÎÊÌâÇë½Ì

ÎÒÓÃÏÂÃæµÄ·½Ê½µ¯³ö¶Ô»°¿ò
RegisterStartupScript("js", " <script>alert('¶Ô²»ÆðÄúûÓиÃȨÏÞ') </script>");

È»ºóÎÒÔÙË¢ÐÂÒ³Ãæ£¬Ò³Ãæ»áÌáʾ£º¡°²»ÖØÐ·¢ËÍÐÅÏ¢ ......

asp.net

asp.netÔõÑùÁ¬½ÓÊý¾Ý¿â°¡£¿»¹ÐèʹÓÃVB.NET±à³Ì£¿
¿´¿´ADO.NET°É£¬ÕâÊǺËÐÄ

ÔÚWeb.configÖÐдÁ¬½Ó×Ö·û´®£¬ÄãÔÚÀàÀïдҲÐÐ

  ллÀ²£¬ÎһῴµÄ¡£

²»ÐèʹÓÃVB.NET±à³Ì£¬ÐèÒªADO.net

·½·¨Óкܶ࣬×Ô¼ ......

Asp.netÈçºÎ×öÒ³Ãæ¿ò¼Ü

±¾È˳õѧAsp.net£¬ÓÃVS2008£¬ÒÔǰÓÃJSP×öÒ³Ãæ¿ò¼Üʱ£¬ÊÇÓÃFramesetµÄ£¬µ«ÊÇVS2008µÄAsp.netʹÓÃXHTML1.0£¬²»Ö§³ÖFrameset¡£´ó¼ÒÔÚ×ö×óÓÒÒ³Ãæ»òÕßÉÏÏÂÒ³ÃæÊ±£¬ÊÇÔõô×öµÄÄØ£¿
Ôõô²»Ö§³Ö¡£
ÎÒÕâ¸ö¾ÍÊÇÒ»¸ö¿ò¼ÜÒ³¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ