急呀!!代码是自带的程序生成的,没有改过,应该没有错的
protected System.Web.UI.WebControls.DataGrid MyDataGrid;
protected System.Web.UI.HtmlControls.HtmlForm form1;
protected Wuqi.Webdiyer.AspNetPager AspNetPager1;
private SqlConnection cn = new SqlConnection(); SqlConnection conn;
SqlCommand cmd;
void Page_Load(object src,EventArgs e)
{
conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["SiteDsn"]);
if(!Page.IsPostBack)
{
cmd=new SqlCommand("Home_Product_List",conn);
cmd.CommandType=CommandType.StoredProcedure;
cmd.Parameters.Add("@pageindex",1);
cmd.Parameters.Add("@pagesize",1);
cmd.Parameters.Add("@docount",true);
conn.Open();
AspNetPager1.RecordCount=(int)cmd.ExecuteScalar();
conn.Close();
BindData();
}
} void BindData()
{
cmd=new SqlCommand("Home_Product_List",conn);
cmd.CommandType=CommandType.StoredProcedure;
cmd.Parameters.Add("@pageindex",AspNetPager1.CurrentPageIndex);
cmd.Parameters.Add("@pagesize",AspNetPager1.PageSize);
cmd.Parameters.Add("@docount",false);
conn.Open();
MyDataGrid.DataSource=cmd.ExecuteReader();
MyDataGrid.DataBind();
conn.Close();
}
void ChangePage(object src,PageChangedEventArgs e)
{
AspNetPager1.CurrentPageIndex=e.NewPageIndex;
BindData();
}