SqlConnection thisConnection = new SqlConnection(strCon);
thisConnection.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "paging";
cmd.Connection = thisConnection;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@NumPage", SqlDbType.Int).Direction = ParameterDirection.Input;
cmd.Parameters.Add("@NumPage", SqlDbType.Int).Value=strNum;
cmd.Parameters.Add("@CountRecOnPage", SqlDbType.Int).Direction=ParameterDirection.Input;
cmd.Parameters.Add("@CountRecOnPage", SqlDbType.Int).Value= 5 ;
cmd.Parameters.Add("@CountRec", SqlDbType.Int).Direction = ParameterDirection.Output;
SqlDataAdapter adapter = new SqlDataAdapter("", thisConnection);
adapter = new SqlDataAdapter(cmd);
DataTable ds = new DataTable();
adapter.Fill(ds);
this.GridView1.DataSource = ds;
this.GridView1.DataBind();
adapter.Dispose();
count=(int)adapter.SelectCommand.Parameters["CountRec"].Value;
thisConnection.Close();

create procedure paging 
@NumPage int,
@CountRecOnPage int,
@CountRec int output 
as
declare @low int, @high int 
Set @CountRec=(select count(*) from id)
Set @low=@NumPage*@CountRecOnPage-@CountRecOnPage;
Set @high=@NumPage*@CountRecOnPage;
declare @t table
(IdTmp Char( 10 ), NameTmp Char( 10 ),
num int identity( 1 , 1 ) not null)
insert into t (IdTmp, NameTmp) select * from id order by asc
select * from t where num between @low and @high

cmd.Parameters.Add("@CountRec", SqlDbType.Int);
        par.Direction = ParameterDirection.Output;