void Page_Load(object sender, System.EventArgs e)
{
 string mySelectQuery = "SELECT * from Products";
 SqlConnection myConnection

 = new SqlConnection("server=...");
 SqlCommand myCommand = new SqlCommand(mySelectQuery, myConnection);
 myConnection.Open();
 SqlDataReader myReader;
 myReader = myCommand.ExecutePageReader(CommandBehavior.Default, 40, 20);
 GridView1.DataSource = myReader;
 GridView1.DataBind();
 myReader.Close();
 myConnection.Close();      
}