分页与全选（全不选）

 今天学习了分页（有两种方法，一种是内置分页，还有一种是存储过程分页）
内置分页：1、直接使用GridView控件的分页样式
2、使用自定义分页样式
存储过程分页：
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ if(!IsPostBack)
bindstudent(1)；

}

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;

}

}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
this.bindstudent(1);
}
protected void Button4_Click(object sender, EventArgs e)
{
this.bindstudent(Convert.ToInt32(this.HiddenField2.Value));
}
protected void Button2_Click(object sender, EventArgs e)
{
int index = Convert.ToInt32(this.HiddenField1.Value);
if (index>0)
{
index--;
}
this.bindstudent(index);
}
protected void Button3_Click(object sender, EventArgs e)
{
int index = Convert.ToInt32(this.HiddenField1.Value);
int total = Convert.ToInt32(this.HiddenField2.Value);
if (index<total)
{
index++;
}
this.bindstudent(index);
}
protected void Button5_Click(object sender, EventArgs e)
{
int index = Convert.ToInt32(this.TextBox1.Text);
int total = Convert.ToInt32(this.HiddenField2.Value);
if (index<=total)
{
this.bindstudent(index);
}
}
}
复选框的选择形式全选或全不选的方法
加上角注
<script type="text/javascript">
function change(sender) {
var table = document.getElementById("GridView1");
for (var i = 1; i < table.rows.length; i++) {
table.rows[i].cells[0].getElementsByTagName("input")[0].checked = sender.checked;
}
}
</script>



using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Default3 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void CheckBox2_CheckedChanged(object sender, EventArgs e)
{
CheckBox ckb = sender as CheckBox;
foreach (GridViewRow row in this.GridView1.Rows)
{
if (row.RowType==DataControlRowType.DataRow)
{
(row.Cells[0].FindControl("CheckBox1") as CheckBox).Checked =ckb.Checked;
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
foreach( GridViewRow row in this.GridView1.Rows)
{
if (row.RowType==DataControlRowType.DataRow )
{
CheckBox ckb = row.Cells[0].FindControl("CheckBox1") as CheckBox;
if (ckb.Checked)
{
Response.Write(row.Cells[1].Text +"<br/>");
}
}
}
}
}