public class WebForm1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected System.Data.SqlClient.SqlConnection sqlConnection1;
protected WebApplication2.DataSet1 dataSet11;
protected System.Data.SqlClient.SqlCommand sqlSelectCommand1;
protected System.Data.SqlClient.SqlCommand sqlInsertCommand1;
protected System.Data.SqlClient.SqlCommand sqlUpdateCommand1;
protected System.Data.SqlClient.SqlCommand sqlDeleteCommand1;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.TextBox TextBox1;
protected System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;

private void Button1_Click(object sender, System.EventArgs e)
{
sqlConnection1.Open();

sqlDataAdapter1.Fill(dataSet11);

DataGrid1.DataSource = dataSet11;
DataGrid1.DataBind();

}

private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
if(e.NewPageIndex>-1 && e.NewPageIndex<this.DataGrid1.PageCount)
{
DataGrid1.CurrentPageIndex=e.NewPageIndex;
}
else
DataGrid1.CurrentPageIndex=0;
TextBox1.Text = DataGrid1.CurrentPageIndex.ToString();
DataGrid1.DataBind();

}