SqlServer(分页查询+ajax)

<pre><code>

if exists(select * from sys.objects where name='Proc_Loction_GetPageList')

begin
drop proc Proc_Loction_GetPageList
end

go

create proc Proc_Loction_GetPageList(@currentPage int, @sizePage int,@total int out)
as
begin
set @total=(select count(Id) from [dbo].[Procut_TaxSpecies])--得到数据总条数
select top (@sizePage) * from (select row_number() over(order by Id) as rowNumber,* from [dbo].[Procut_TaxSpecies])
as t where t.rowNumber>@sizePage*(@currentPage-1);
end

--执行存储过程

select * from
[dbo].[Procut_Taxation]

select * from [dbo].[Procut_TaxSpecies]

declare @total int
exec Proc_Loction_GetPageList 3,3,@total output
print @total

--在vs中执行这个存储过程，并获取存储过程的输出参数
--[csharp] view plain copy 在CODE上查看代码片派生到我的代码片
public class HomeController : Controller
{
public ActionResult Index()
{
string conStr = ConfigurationManager.ConnectionStrings["salesConStr"].ConnectionString;

    SqlParameter totalPara = new SqlParameter("@total", SqlDbType.Int); //用于接收存储过程的输出参数（获取数据的总条数）  
    totalPara.Direction = ParameterDirection.Output; //声明这个参数是一个输出参数  

    using (SqlConnection conn = new SqlConnection(conStr))  
    {  
        string sqlStr = "Proc_Loction_GetPageList"; //Proc_Loction_GetPageList是存储过程名称  
        SqlCommand cmd = new SqlCommand(sqlStr, conn);  
        cmd.CommandType = CommandType.StoredProcedure; //指明我这里要执行的是存储过程  

        SqlParameter[] para=new SqlParameter[]  
        {  
            new SqlParameter("@currentPage", 3),//当前页  
            new SqlParameter("@sizePage", 10) //页大小  
        };  

        cmd.Parameters.AddRange(para);  //将参数加入到cmd命令中               
        cmd.Parameters.Add(totalPara);  

        conn.Open(); //打开与数据库的连接  

        SqlDataReader reader = cmd.ExecuteReader();  

        List<location> list = new List<location>();  
        while (reader.Read()) //逐行读取数据  
        {  
            location obj = new location()  
            {  
                locId = Convert.ToInt32(reader["locId"]),  
                locName = reader["locName"].ToString(),  
                parentId = Convert.ToInt32(reader["parentId"]),  
            };  
            list.Add(obj);  
        }  
    }  
    var total = totalPara.Value; //获取输出参数（获取数据的总条数）  

    return View();  
}  

}

http://blog.csdn.net/fanbin168/article/details/41366291
</pre></code>

http://blog.csdn.net/fanbin168/article/details/42795691
Here is an example of AppleScript: tell application "Foo" beep end tell