asp.netϺǫ́³£Ó÷ÖÒ³½â¾ö·½°¸µÄ˼¿¼
SQL
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
--°¢»áéªsosuo8.com¸ù¾ÝÍøÂçÉϵĴúÂë½øÐÐÁËÐ޸쬰æÈ¨¹éÔ×÷ÕßËùÓÐ2009-4-5
--°¢»áéª×öÁËÒ»´ÎÉý¼¶£¬2009-9-27
--ÐÞ¸ÄÊä³ö×ܼǼÊý
ALTER PROCEDURE [dbo].[pagination]
@tblName nvarchar(1000), -- ±íÃû
@fldName nvarchar(1000), -- ÐèÒª·µ»ØµÄÁÐ
@orderfldName nvarchar(255), -- ÅÅÐòµÄ×Ö¶ÎÃû
@PageSize int, -- Ò³³ß´ç
@PageIndex int, -- Ò³Âë
@OrderType bit, -- ÉèÖÃÅÅÐòÀàÐÍ, ·Ç 0 ÖµÔò½µÐò
@strWhere nvarchar(1500), -- ²éѯÌõ¼þ (×¢Òâ: ²»Òª¼Ó where)
@isCount bit--ÉèÖÃÊÇ·ñ·µ»Ø¼Ç¼×ÜÊý£¬0²»·µ»Ø¡¢1·µ»Ø
AS
declare @strSQL nvarchar(4000) -- Ö÷Óï¾ä
declare @strTmp nvarchar(110) -- ÁÙʱ±äÁ¿
declare @strOrder nvarchar(400) -- ÅÅÐòÀàÐÍ
--declare @timediff datetime --ºÄʱ
begin
--select @timediff = Getdate()
--if @strWhere !=''
if @isCount = 1
exec('select count(*) from ' + @tblName + ' where '+@strWhere)
Else
if @OrderType != 0
begin
set @strTmp = '<(select min'
set @strOrder = ' order by ' + @orderfldName +' desc'
--Èç¹û@OrderType²»ÊÇ0£¬¾ÍÖ´ÐнµÐò£¬Õâ¾äºÜÖØÒª£¡
end
else
begin
set @strTmp = '>(select max'
set @strOrder = ' order by ' + @orderfldName +' asc'
end
if @PageIndex = 1
begin
if @strWhere != ''
set @strSQL = 'select top ' + str(@PageSize) +' '+@fldName+ ' from ' + @tblName + ' where ' +
Ïà¹ØÎĵµ£º
Ê×Ò³£º
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head ......
ÔÚweb configÖÐ ×÷ÈçÏÂÅäÖãº
<connectionStrings>
<add name="ydycon" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=|DataDirectory|ydy.mdb" providerName="System.Data.OleDb"/>
</connectionStrings>
ÔÚ.netÎļþÖÐÓ¦ÓÃÁ´½Ó ......
ASP.NET ÅäÖýڼܹ¹°üº¬¿ØÖÆ ASP.NET Web Ó¦ÓóÌÐòÐÐΪµÄÔªËØ¡£Èç¹ûΪÊôÐÔÖ¸¶¨ÁËĬÈÏÖµ£¬Ôò¸ÃĬÈÏÖµÊÇÔÚ Machine.config ÎļþÖÐÉèÖõ쬏ÃÎļþµÄ·¾¶ÊÇ systemroot\Microsoft.NET\Framework\versionNumber\CONFIG\Machine.config¡£
<configuration>
<location>
......
substring
public String substring(int beginIndex)·µ»ØÒ»¸öеÄ×Ö·û´®£¬ËüÊÇ´Ë×Ö·û´®µÄÒ»¸ö×Ó×Ö·û´®¡£¸Ã×Ó×Ö·û´®Ê¼ÓÚÖ¸¶¨Ë÷Òý´¦µÄ×Ö·û£¬Ò»Ö±µ½´Ë×Ö·û´®Ä©Î²¡£
ÀýÈ磺
"unhappy".substring(2) returns "happy"
"Harbison".substring(3) returns "bison"
"emptiness".substring(9) returns "" (an empty string)
² ......
×î½üд³ÌÐòÒ»Ö±³öÎÊÌ⣬ÒÔǰһ¸öÕ¾Èý¼¸Ìì¾ÍÇáËɸ㶨£¬ÏÖÔÚÒ»¸öÄ£¿é¾³£¸ã°ëÌ죬NND
ÏÂÎ翪·¢¿áÒ×»¯×±Æ·É̳Ç(http://www.koyee.net)Ò»¸ö±íµ¥Ìá½»¹¦ÄÜÄ£¿é£¬±¾µØÈκÎÎÊÌⶼûÓÐÁË£¬´«µ½·þÎñÆ÷Éϱ¾ÒÔΪûÊÂÁË£¬ºóÀ´Ò»¼ì²éËùÓеÄÑéÖ¤¿Ø¼þ¶¼²»Æð×÷ÓÃÁË£¬Ö±½Ó¶¼Ìá½»¹ýÈ¥ÁË£¬ÓôÃÆ£¬ÔÒÔΪ³ÌÐò±»¸Ä´íÁË£¬¼ì²é±¾µØ»¹ÊÇûÈκÎÎÊÌ⣬¼ ......