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µÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡
Ëæ±ã¸ãÒ»D°æ°É£¬
ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
´úÂëÈçÏ Çë¸ßÊÖ Ö¸µãÏ лл
ajax_http.js
-------------
function getXMLHTTP() {
var xmlhttp;
if (window.ActiveXObject) {
//IE
try {
......
ÐèÇóÈçÏ£º
ѧԺ academy£¨aid,aname£©
°à¼¶ class£¨cid,cname,aid£©
ѧÉú stu(sid,sname,aid,cid)
סËÞÇø region(rid,rname)
ËÞÉáÂ¥ build(bid,rid,bnote) bnoteÊÇ¡®ÄС¯/¡®Å®¡¯
ËÞÉá dorm(did,rid,bid£¬bedn ......
ÎÒ×î½ü×öÁËÒ»¸öÍøÕ¾ÊǹØÓÚ²úƷչʾµÄ ~ Õû¸öÍøÕ¾Í¼Æ¬¶¼Õ¼ÓÃÁËÒ»´ó°ë
ÕâÑùµÄ»°·ÃÎÊËٶȾͷdz£Âý ÓÐʲô°ì·¨¿ÉÒÔ½â¾öÂð£¿
Âé·³´ó¼Ò¶à¶à¸øµãÒâ¼û £¡ ÓÐʲô¾¡¹Ü˵
3Q´ó¼Ò
htmlÒ³Ãæ.
Õâ¸ö,¼ÈÈ»Ö÷Ò ......