Privet vsem, ya novichek v Asp .net. Poyavilas takaya problem , pomogite please. Ispolzuyu paging Datagrid , est u menya vverhu stranizi dropdownlist tam vibirayu neobhodimuyu category i v zavisimosty kakuyu vibral poyavlayutsa tovary etoy category , vse klasno pashet no kogda idu na posledniyu stranizu paging i potom menayu category vverhu vidaet mne error.
"Invalid CurrentPageIndex value. It must be >= 0 and < the PageCount."

Vot code:

private void BindProducts()
{
//components.Product product = new components.Product();
//dgProducts.DataSource = product.ProductGetList(listCategories.SelectedItem.Value);
//dgProducts.DataBind();

// Fix bug if i delete the last row in some page
//if((dgProducts.Items.Count % dgProducts.PageSize == 1) && (dgProducts.CurrentPageIndex == dgProducts.PageCount - 1) && (dgProducts.CurrentPageIndex != 0))
//{
// dgProducts.CurrentPageIndex = dgProducts.CurrentPageIndex -1;
//}

SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
SqlCommand myCommand = new SqlCommand("spProductGetList", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add ( new SqlParameter ( "@catid", SqlDbType.NVarChar ) ).Value = listCategories.SelectedItem.Value;
SqlDataAdapter myAdapter = new SqlDataAdapter(myCommand);
DataSet ds = new DataSet();
myAdapter.Fill(ds);
dgProducts.DataSource = ds;
dgProducts.DataBind();
}


protected void GridPageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
dgProducts.CurrentPageIndex = e.NewPageIndex;
BindProducts();
}

Jdu otvetov , spasibo.

Reshil ya etu problem vremenno tak , skazite mojno li po drugomu

private void changeCategory(object sender, System.EventArgs e)
{
dgProducts.CurrentPageIndex = 0;
BindProducts();
}

Tobesh kogda menayu category na 1 stranizu idet srazu.