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

SQL 2000·ÖÒ³ - .NET¼¼Êõ / ASP.NET

sql2000´æ´¢¹ý³Ì·ÖÒ³£¬ÄÜ·µ»Ø×ܼǼÊý
×Ô¼ºÕ¼ ɳ·¢

ÍøÉÏ´ó¶Ñ

Ò²µÃmark

create procedure procedureName
@pageIndex int,
@pageSize int,
@pageCount int output,
@count int output
as
set @count=(select count(1) from tableName)
if(@count%@pageSize=0)
begin
  set @pageCount=@count/@pageSize
end
else
begin
  set @pageCount=@count/@pageSize
end
declare @delete int
set @delete=(@pageIndex-1)*@pageSize
declare @sql nvarchar(200)
set @sql='select top '+cast(@pageSize as varchar(12))+' * from tableName where id not in (select top '+cast(@delete as varchar(12))+' id from tableName)'
execute sp_executesql @sql
Ò²¿ÉÒÔ¸ù¾Ý×Ô¼ºµÄÐèÒª¶àÉ趨һЩ²ÎÊýµÄ ÎÒÕâÀïÊÇÒ»¸ö¼òµ¥µÄ·ÖÒ³´æ´¢¹ý³Ì ²»ÊÇͨÓõÄ

ÊýÁ¿½ÏС¿ÉÒÔ²ÉÓÃsql·ÖÒ³¶ÁÈ¡£º 

  Á½¸ö²ÎÊý£º PageSize£ºÃ¿Ò³µÄÐÐÊý PageIndex£ºÒ³Êý
  string sql = select count(*) from ±íÃû;select top " + PageSize + " * from ±íÃû where id not in (select top " + (PageIndex - 1) * PageSize + " id from ±íÃ÷ order by id) order by id

  ÔÚºǫ́£º
  ViewState["pageindex"] ±£´æµ±Ç°µÄÒ³Êý ViewState["pagecount"] ±£´æ×ܵÄÒ³Êý 
  decimal Sum= decimal.Parse(ds.Tables[0].Rows[0][0].ToString()) »ñÈ¡×ܵÄÐÐÊý
  int pagecount = int.Parse(Math.Ceiling(Sum/pagesize).ToString()) »ñÈ¡×ܵÄÒ³Êý


Ïà¹ØÎÊ´ð£º

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......

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

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

js ......

asp.netÈçºÎÌá¸ß·ÃÎÊËÙ¶È - .NET¼¼Êõ / ASP.NET

ÎÒ×î½ü×öÁËÒ»¸öÍøÕ¾ÊǹØÓÚ²úƷչʾµÄ ~ Õû¸öÍøÕ¾Í¼Æ¬¶¼Õ¼ÓÃÁËÒ»´ó°ë  
ÕâÑùµÄ»°·ÃÎÊËٶȾͷdz£Âý ÓÐʲô°ì·¨¿ÉÒÔ½â¾öÂð£¿
Âé·³´ó¼Ò¶à¶à¸øµãÒâ¼û £¡ ÓÐʲô¾¡¹Ü˵ 
3Q´ó¼Ò
htmlÒ³Ãæ.

Õâ¸ö,¼ÈÈ»Ö÷Ò ......

¹ØÓÚSqlµÄÎÊÌâ - .NET¼¼Êõ / ASP.NET

½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º
DECLARE @STR NVARCHAR(MAX)
SET @STR='SELECT * from SALE_PROD'
ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿
Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡


¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡

Ö±½ÓÖ´ÐоÍÐÐÁË

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