Fast GridView

using System;
using System.Text;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Data.OleDb;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Configuration;
using Avg.Controls;


//To test this code :
//1-download the AdventureWorks database  at http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en
//2-execute stored procedure on sql server :

//set ANSI_NULLS ON
//set QUOTED_IDENTIFIER ON
//go

//CREATE PROCEDURE [dbo].[ProductsByRows] 
//(@pBegin int,
// @pEnd int)
//AS
// With Prod AS 
//( SELECT [ProductID], 
//         [ProductName], 
//         [SupplierID], 
//         [CategoryID], 
//         [QuantityPerUnit], 
//         [UnitPrice], 
//         [UnitsInStock], 
//         [UnitsOnOrder], 
//         [ReorderLevel], 
//         [Discontinued] ,  
//         ROW_NUMBER() OVER (order by ProductName) as RowNumber from Products )
//         SELECT [ProductID], 
//        [ProductName], 
//        [SupplierID], 
//        [CategoryID], 
//        [QuantityPerUnit], 
//        [UnitPrice], 
//        [UnitsInStock], 
//        [UnitsOnOrder], 
//        [ReorderLevel], 
//        [Discontinued] from Prod  Where RowNumber 
//Between @pBegin and @pEnd 




public partial class _Default : System.Web.UI.Page
{


    protected override void OnLoad(EventArgs e)
    {
        base.OnLoad(e);
    }
   
   
    protected void GrdMain_DoLoadRowCount(object sender, EventArgs e)
    {
        StringBuilder que = new StringBuilder();
        que.Append(" SELECT count([ProductID]) from Products ");


        SqlConnection con = new SqlConnection(
            System.Configuration.ConfigurationSettings.AppSettings["conx"]
            );

        con.Open();

        SqlCommand command = new SqlCommand(que.ToString(), con);
        command.CommandType = CommandType.Text;

        object val = command.ExecuteScalar();
        con.Close();

        GrdMain.RowCount = Int32.Parse(val.ToString());
    }
    
    protected void GrdMain_DoSelectRow(object sender, EventArgs e)
    {
        
            SqlConnection con = new SqlConnection(
                 System.Configuration.ConfigurationSettings.AppSettings["conx"]
                 );

            con.Open();

            SqlCommand command = new SqlCommand("ProductsByRows", con);
            command.CommandType = CommandType.StoredProcedure;

            command.Parameters.Add(new SqlParameter("@pBegin", GrdMain.rowB));
            command.Parameters.Add(new SqlParameter("@pEnd", GrdMain.rowE));

            DataSet prod = new DataSet();
            SqlDataAdapter adap = new SqlDataAdapter(command);
            adap.Fill(prod);

            con.Close();

            GrdMain.DataSource = prod.Tables[0];
            DataBind();

        
    }
}