DataGrid中分页的问题

我在实现DataGrid中分页的问题。
我的一个程序只能实现一个DataGrid分页,其他的DataGrid中分页不好使:代码如下:
private void Page_Load(object sender, System.EventArgs e)
{
DataGrid1.AllowPaging = true;
DataGrid1.PagerStyle.Mode =PagerMode.NumericPages;
DataGrid1.PageSize = 10;
BindGrid();//初始化DataGrid1

}

private void BindGrid()
{
SqlConnection cn = new SqlConnectio("server=ERIC;database=bookshop;uid=sa;pwd=1");
SqlDataAdapter cmd = new SqlDataAdapter("select * from booktype1", cn);
string sqlstr="select * from booktype1";
DataSet ds = new DataSet();
cmd.Fill(ds, "orders");
this.database.ExecuteSelect1(DataGrid1,sqlstr);
}
//分页函数
private void Page_Index(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
this.DataGrid1.CurrentPageIndex=e.NewPageIndex;
this.DataGrid1.DataBind();
}
//分页的属性PageSize="3" AllowPaging="True"
可笑是,我查询另一个表即select * from booktype1变为select * from book,结果不变。
竟请赐教 忠心的谢谢!!
[1049 byte] By [hsl616-hsl18] at [2008-2-13]