ADO調用分頁查詢存儲過程的實例講解

----------使用存儲過程編寫一個分頁查詢-----------------------
set nocount off --關閉SqlServer消息
--set nocount on --開啟SqlServer消息
go
create proc usp_getMyStudentsDataByPage
--輸入?yún)?shù)
@pagesize int=7,--每頁記錄條數(shù)
@pageindex int=1,--當前要查看第幾頁的記錄
--

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace _02通過Ado.Net調用存儲過程
{
 public partial class Form1 : Form
 {
 public Form1()
 {
 InitializeComponent();
 }
 private int pageIndex = 1;//當前要查看的頁碼
 private int pageSize = 7;//每頁顯示的記錄條數(shù)

 private int pageCount;//總頁數(shù)
 private int recordCount;//總條數(shù)
 //窗體加載的時候顯示第一頁的數(shù)據(jù)
 private void Form1_Load(object sender, EventArgs e)
 {
 LoadData();
 }
 private void LoadData()
 {
 //根據(jù)pageIndex來加載數(shù)據(jù)
 string constr = "Data Source=steve-pc;Initial Catalog=itcast2014;Integrated Security=True";
 #region 1
 //using (SqlConnection conn = new SqlConnection(constr))
 //{
 // //將sql語句變成存儲過程名稱
 // string sql = "usp_getMyStudentsDataByPage";
 // using (SqlCommand cmd = new SqlCommand(sql, conn))
 // {
 // //告訴SqlCommand對象，現(xiàn)在執(zhí)行的存儲過程不是SQL語句
 // cmd.CommandType = CommandType.StoredProcedure;
 // //增加參數(shù)(存儲過程中有幾個參數(shù)，這里就需要增加幾個參數(shù))
 // //@pagesize int=7,--每頁記錄條數(shù)
 // //@pageindex int=1,--當前要查看第幾頁的記錄
 // //@recordcount int output,--總的記錄的條數(shù)
 // //@pagecount int output --總的頁數(shù)
 // SqlParameter[] pms = new SqlParameter[] { 
 // new SqlParameter("@pagesize",SqlDbType.Int){Value =pageSize},
 // new SqlParameter("@pageindex",SqlDbType.Int){Value =pageIndex},
 // new SqlParameter("@recordcount",SqlDbType.Int){ Direction=ParameterDirection.Output},
 // new SqlParameter("@pagecount",SqlDbType.Int){Direction=ParameterDirection.Output}
 // };
 // cmd.Parameters.AddRange(pms);
 // //打開連接
 // conn.Open();
 // //執(zhí)行
 //using(SqlDataReader reader=cmd.ExecuteReader())
 //{
 //reader.Read()
 //}
 //pms[2].Value
 // }
 //}
 #endregion
 //DataAdapter方式
 DataTable dt = new DataTable();
 using (SqlDataAdapter adapter = new SqlDataAdapter("usp_getMyStudentsDataByPage", constr))
 {
 adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
 SqlParameter[] pms = new SqlParameter[] { 
 new SqlParameter("@pagesize",SqlDbType.Int){Value =pageSize},
 new SqlParameter("@pageindex",SqlDbType.Int){Value =pageIndex},
 new SqlParameter("@recordcount",SqlDbType.Int){ Direction=ParameterDirection.Output},
 new SqlParameter("@pagecount",SqlDbType.Int){Direction=ParameterDirection.Output}
 };
 adapter.SelectCommand.Parameters.AddRange(pms);
 adapter.Fill(dt);
 //獲取