Question

asp.net(C#) 查询时的分页问题

我用DataGrid显示数据，然后用一个文本框和一个按钮查询DataGrid中的具体数据，查询后显示具体查询要求的数据，数据多的时候有分页，但是当我点下一页的时候把所有数据都显示出来了，还有就是点击DataGrid中的编辑也会将所有数据都显示出来，请高手指点一下该如何修改，时间很紧，解决后再加奖分，谢谢！
allowpaging属性已经设为ture了

Answer 1

你看下你DataGrid的allowpaging属性是否设为ture
这是自己手动写的分页 你可以直接用 在界面上拉控件就可以
public partial class GridView_gridview : System.Web.UI.Page
{
string sqlstr = "";
//总页数
public int PageCount;
//当前页数
public int Page ;
string SqlConStr = "server=.;uid=sa;pwd=;database=exampletest;";
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Page = 1;
filldata();
lbUpPage.Enabled = false;
lbFirstPage.Enabled = false;
}
}
private void filldata()
{
SqlConnection con = new SqlConnection(SqlConStr);
string sqlstr = "select name,id from filltree";
SqlDataAdapter sda = new SqlDataAdapter(sqlstr, con);
DataSet ds = new DataSet();
sda.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
PageCount = GridView1.PageCount;
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
this.GridView1.PageIndex = e.NewPageIndex;
filldata();
}
//修改事件
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
string id = GridView1.DataKeys[e.NewEditIndex].Value.ToString();
ViewState["id"] = id;
TextBox1.Text = GridView1.Rows[e.NewEditIndex].Cells[1].Text;
TextBox2.Text = GridView1.Rows[e.NewEditIndex].Cells[2].Text;
}
//修改按钮
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(SqlConStr);
sqlstr = "update filltree set name='" + TextBox2.Text + "' where id='" + ViewState["id"].ToString() + "'";
SqlCommand cmd = new SqlCommand(sqlstr, con);
con.Open();
if (cmd.ExecuteNonQuery() > 0)
{
TextBox1.Text = "";
TextBox2.Text = "";
}
con.Close();
filldata();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string id = GridView1.DataKeys[e.RowIndex].Value.ToString();
sqlstr = "delete from filltree where id=" + id + "";
SqlConnection con = new SqlConnection(SqlConStr);
SqlCommand cmd = new SqlCommand(sqlstr, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
filldata();
}
protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
Response.Write("<script>alert('@_@');</script>");
}
//上一页
protected void lbUpPage_Click(object sender, EventArgs e)
{
if (GridView1.PageIndex > 0)
{
lbDownPage.Enabled = true;
lbLastPage.Enabled = true;
GridView1.PageIndex -= 1;
if (GridView1.PageIndex == 0)
{
lbFirstPage.Enabled = false;
lbUpPage.Enabled = false;
}
}
filldata();
Page = GridView1.PageIndex + 1;
}
//下一页
protected void lbDownPage_Click(object sender, EventArgs e)
{
if (GridView1.PageIndex < GridView1.PageCount - 1)
{
GridView1.PageIndex += 1;
lbFirstPage.Enabled = true;
lbUpPage.Enabled = true;
if (GridView1.PageIndex+1 == GridView1.PageCount)
{
lbDownPage.Enabled = false;
lbLastPage.Enabled = false;
}
}
filldata();
Page = GridView1.PageIndex + 1;
}
//第一页
protected void lbFirstPage_Click(object sender, EventArgs e)
{
lbDownPage.Enabled = true;
lbLastPage.Enabled = true;
GridView1.PageIndex = 0;
filldata();
lbFirstPage.Enabled = false;
lbUpPage.Enabled = false;
Page = GridView1.PageIndex + 1;
}
//最后一页
protected void lbLastPage_Click(object sender, EventArgs e)
{
lbUpPage.Enabled = true;
lbFirstPage.Enabled = true;
GridView1.PageIndex = GridView1.PageCount - 1;
filldata();
lbLastPage.Enabled = false;
lbDownPage.Enabled = false;
Page = GridView1.PageIndex + 1;
}

Answer 2

你是不是没有加入PageIndexChanging事件啊
protected void gvPerson_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gvPerson.PageIndex = e.NewPageIndex;
Find();//绑定数据
}

Answer 3

错了，你的思维有点错了。
我想：你点查询的时候得到你要的结果，可是DataGrid的分页事件你是怎么写的？或者是默认的，那它就还是绑定全部数据是不是？
要是我的话，我会自己写分页的，加几个按钮写，不过比较麻烦

Answer 4

把数据的读取 作成 存储过程的分页.