asp ÈçºÎʵÏÖ Êý¾Ý¿âÅÅÐò,²¢ÇÒ·ÖÒ³ÏÔʾ???
ÕÛÌÚNÌìÁË,¸ã²»¶¨,Çë¸ßÊִͽÌ~!лл~!
ÎÒÓõÄÊÇC#,´úÂëÇëÓÃC#д,VB,µÄ¿´²»Ì«¶®,ллÁË~!
¶ÔÊý¾Ý¿âÅÅÐòºóÈçºÎѡȡÆäÖÐÁ¬ÐøµÄÒ»¶Î?
ÈçºÎʵÔÚ·ÖÃæÏÔʾ?
лл~!@
ÅÅÐòÓÃorder by¾Í¿ÉÒÔ°É¡¡
ÓÿؼþGridView
°´ÕÕÏòµ¼ÉèÖþÍÐÐÁË£¬ºÜÈÝÒ׵ġ£
WITH OrdersByOrderIDASC AS
(
SELECT OrderID,
CustomerID,
OrderDate,
ROW_NUMBER() OVER(ORDER BY orderID ASC) AS ×ֶαàºÅ
from dbo.Orders WITH(NOLOCK)
)
SELECT * from OrdersByOrderIDASC WITH(NOLOCK) WHERE ×ֶαàºÅBETWEEN 100 AND 110
SQL code:
--·ÖÒ³´æ´¢¹ý³Ì,ÔÚC# Öе÷Óà ´«ÈëÏàÓ¦µÄ²ÎÊý ¾Í¿ÉÒÔȡָ¶¨Ò³ºÍ´óСµÄÊý¾ÝÁË
Create PROCEDURE [dbo].[Pagination](
@PageSize INT, --ÿҳµÄ¼Ç¼ÌõÊý
@PageNumber INT, --µ±Ç°Ò³Ãæ
@QuerySql VARCHAR(8000),--²¿·Ö²éѯ×Ö·û´®,Èç* from Test order by id desc
@KeyField VARCHAR(500))--Ò»°ãÓÃÖ÷¼ü
AS
BEGIN
if @PageNumber is null or @PageNumber<1
Begin
Set @PageNumber=1
End
DECLARE @SqlTable AS VARCHAR(8000)
DECLARE @SqlText AS VARCHAR(8000)
SET @SqlTable =N'Select Top ' + CAST(@PageNumber * @PageSize AS VAR
Ïà¹ØÎÊ´ð£º
<form id="form1" runat="server">
<div>
<script type="text/javascript">
function oo(a){
document.getEleme ......
ÎÒÓÐÒ»¸öaspÔ´Â룬µ«ÊdzöÏÖÒ»¸öÎļþ£¬ÎÒÓÃasp½âÃܶ¼ÊÇÂÒÂë
Çë½Ì
VBScript code:
??
%# , #&')*)-0-(0%()(?
(((((((((((((((((((((((((( ......
Çë¸÷λ¸ßÊÖ°ï½â¾ö,¼±!!!
<script language="JavaScript" type="text/javascript">
function CheckInput(){
if (document.frm.loginname.length =0){
alert('ÇëÕý ......
ÓÐËÄܸø½²½²£¬Ôõô×öÂð£¿
ллÀ²£¡
¸ÊÌØÍ¼ ÊÇɶ£¿
½âÌâ˼·.¿´Ò»Ï½ø¶ÈÌõµÄÏÔʾ..
ÆäʵÄã¾ÍŪһ¶Ñtable ÿ¸ötableµÄ¿í¶È²»Í¬.µ×É«²»Í¬¼´¿É
µ±È»ÓÃdiv¿ØÖÆÎ»ÖøüºÃ
ÄãŪ100¸ötable¸ù¾Ý½ø¶ÈÆäÖÐǰ20¸ö·Ö¸øµ ......
IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)
'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......