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·ÖÖپͿÉÒÔ
Ïà¹ØÎÊ´ð£º
ÐÂÈËÒ»¸ö£¬²»¶®£¬Ï£Íû´ó¼Ò¶à¶àÖ¸µã
ÎÒËæÒâн¨Ò»¸öÍøÕ¾£¨2.0ºÍ3.5µÄ¶¼ÊÔ¹ý£©£¬Ö»·ÅÉÏÒ»¸ö¿Ø¼þ£¬È»ºó¾ÍÖ±½ÓÔËÐÐÁË£¬ÂíÉϾÍÌø³öÒ»¸ö³ö´íµÄÒ³Ãæ£¬´ó¸ÅÊÇ˵
¡°/WebSite1¡±Ó¦ÓóÌÐòÖеķþÎñÆ÷´íÎó¡£
--- ......
ллÁË£¬¸ßÊÖÃÇ¿ìÀ´°¡~
¹À¼ÆÃ»²å¼þʲôµÄ²»Ðаɡ£
ÎÒÒ²Òª лл¸÷λ·¢ÎÒÒ»·Ýliujintaohfbb@163.com
ллÁË Ò»¶¨Òª·¢ÎÒ°¡
¶÷ÕÒµ½ÁË,±ðÍüÁ˶
401533349@163.com
http://download.csdn.n ......
cmd.CommandText = "update detailesid set num=num+1 where id=" + id + " and detailesid= "+ RadioButtonList1.SelectedValue.ToString();
cmd.ExecuteNonQuery();
ÎÒ×öÁËÒ»¸ ......
ÎÒ×öÁËÒ»¸öÍøÕ¾·ÅÔÚ·þÎñÆ÷ÉÏ£¬Ç°¼¸Ìì¶¼¿ÉÒÔ·ÃÎʲ¢ÇÒËÙ¶È»¹ÐУ¬Ôõôµ½½ñÌì·ÃÎÊËÙ¶ÈÌØÂý£¬µ½×îºÃ¶¼·ÃÎʲ»ÁËÀ²¡£Çë¸ßÊÖÖ¸½Ì
ÄÇÒ²Ö»ÄÜ˵·þÎñÆ÷µÄÎÊÌâ¡£
Èç¹û²»ÊÇÔÚ·þÎñÆ÷ÉÏ ËÙ¶ÈÔõôÑùÄØ
Ò²ÐíÊÇÄãµÄ·þÎ ......
ÎÒ×öÁËÒ»¸öasp.netµÄÍøÒ³£¬µ«½çÃæÌ«ÄÑ¿´£¬ÓÃʲô¹¤¾ß¿ÉÒÔÃÀ»¯Ï£¿
Ò»°ã¾ÍÊÇcssºÍflashÁË.
»òÕßÓÃһЩµÚÈý·½µÄasp.net¿Ø¼þ.
ÎÒµÄÒ³ÃæÔÚ´óÒ»µãµÄÏÔʾÆÁÉϲ»»á×Ô¶¯ÉìËõ£¬Ôõô°ì£¿
ÃÀ¹¤°¡£¬CSS£¬²»»á°É£¬´´½¨Ò ......