一个简单的存储过程数据分页[2]

   string str1 = " select * from Mobile ";//不带排序语句的SQL语句   
   int intRecsPerPage = 10;//每页容纳的记录数
   string strID = " MobileID ";//需要排序的不重复的ID号
   string strSort = " MobileID ";//排序字段及规则
   string strTBName = "Mobile";//数据库当中的要提取数据的表
   
   
   SqlConnection con = new SqlConnection("uid=sa;pwd=123456;database=Test;");   
   SqlCommand cmd = new SqlCommand("Proc_Paging",con);   
   cmd.CommandType = CommandType.StoredProcedure;    

   cmd.Parameters.Add(new SqlParameter("@SQL",SqlDbType.NVarChar,4000));
   cmd.Parameters.Add(new SqlParameter("@Page",SqlDbType.Int));
   cmd.Parameters.Add(new SqlParameter("@RecsPerPage",SqlDbType.Int));
   cmd.Parameters.Add(new SqlParameter("@ID",SqlDbType.NVarChar,255));
   cmd.Parameters.Add(new SqlParameter("@Sort",SqlDbType.NVarChar,255));
   cmd.Parameters.Add(new SqlParameter("@TBName",SqlDbType.NVarChar,255));

   SqlParameter parameterPageCount = new SqlParameter("@PageCount",SqlDbType.Int);
   parameterPageCount.Direction = ParameterDirection.Output;
   cmd.Parameters.Add(parameterPageCount);

   cmd.Parameters["@SQL"].Value = str1;
   cmd.Parameters["@Page"].Value = intPage;
   cmd.Parameters["@RecsPerPage"].Value = intRecsPerPage;
   cmd.Parameters["@ID"].Value = strID;
   cmd.Parameters["@Sort"].Value = strSort;
   cmd.Parameters["@TBName"].Value = strTBName;   
   
   try
   {    
    using(SqlDataAdapter ad = new SqlDataAdapter(cmd))
    {    
     DataSet ds = new DataSet();
     ad.Fill(ds);
     dg.DataSource = ds.Tables[0].DefaultView;
     dg.DataBind();    
    }
   }
   catch(Exception Error)
   {
    string strError = Error.ToString();
   }
   finally
   {
    if( con != null || con.State == ConnectionState.Open )
    {      
     con.Close();
    }
   }  
   
   lblPaging.Text = GetlblPagingBind(Request.QueryString["Page"],parameterPageCount.Value.ToString());
  }