Если процедура возвращает селект и один параметр???

adapter.SelectCommand.Parameters.Add("YourParameterName");
adapter.SelectCommand.Parameters["YourParameterName"].Direction = ParameterDirection.Output;
adaper.Fill(ds,"TableName");
object o = adapter.SelectCommand.Parameters["YourParameterName"].Value;

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();

cmd.Parameters.[b]Add("@NumPage", [/b]SqlDbType.Int).Direction = ParameterDirection.Input;
cmd.Parameters.[b]Add("@NumPage", [/b]SqlDbType.Int).Value=strNum;

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