Question

.NET中有个GIRDVIEW的分页设置有错，说是数据源不支持服务器端的分页，请教高手！

我把GRIDVIEW的属性中已经设置为分页了，我的分页代码如下
protected void GridView1_PageindexChanging(object sender, GridViewPageEventArgs e)
{
this.GridView1.PageIndex = e.NewPageIndex;
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=172.1.21.78;Initial Catalog=FamilyFinanceSystem;Integrated Security=TRUE";
conn.Open();

SqlCommand comm = new SqlCommand("Select * from rdParentItem", conn);
SqlDataReader dr = comm.ExecuteReader();
GridView1.DataSource = dr;
GridView1.DataBind();
}

Answer 1

sqldatareader不支持分页 改为dataset
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=172.1.21.78;Initial Catalog=FamilyFinanceSystem;Integrated Security=TRUE";
conn.Open();

SqlCommand comm = new SqlCommand("Select * from rdParentItem", conn);
SqlDataAdapter ad = new SqlDataAdapter(comm);
DataSet ds = new DataSet();
ad.Fill(ds);
GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataBind();

Answer 2

要使用自带的分页属性必须绑定到数据源控件，自己写查询语句作为数据源时不幸的。
自动分页要靠数据源控件支持，否则只能自己实现分页功能。