Gridview控件2

1.分页：

<1>内置分页：1.可以用GridView控件的分页样式

                           2.自定义分页：

                           先把数据绑定到GridView控件上，然后用Button按钮实现上下页的跳动

<2>存储过程分页： private void BindStudent(int pageIndex)
    {
        string str = System.Configuration.ConfigurationManager.ConnectionStrings["studentConnectionString"].ConnectionString;
        using (SqlConnection sqlcnn = new SqlConnection(str))
        {
            SqlCommand sqlcmm = sqlcnn.CreateCommand();
            sqlcmm.CommandText = "sp_Student_Select_by_Page_rowNumber";
            sqlcmm.CommandType = System.Data.CommandType.StoredProcedure;
            sqlcmm.Parameters.AddWithValue("@pageSize", 3);
            sqlcmm.Parameters.Add("@pageCount", SqlDbType.Int).Direction =
                ParameterDirection.Output;
            sqlcmm.Parameters.AddWithValue("@pageIndex", pageIndex);
            SqlDataAdapter da = new SqlDataAdapter(sqlcmm);
            DataSet ds = new DataSet();
            da.Fill(ds);
            this.GridView1.DataSource = ds.Tables[0];
            this.GridView1.DataBind();
            this.HiddenField1.Value = pageIndex.ToString();
            this.HiddenField2.Value = sqlcmm.Parameters["@pageCount"].Value.ToString();
            this.Label1.Text = pageIndex + "/" + this.HiddenField2.Value;
        }
    }