/// 
        /// .net自带分页方法        /// 
        ///         ///         ///         /// 
             public static DataSet RunProcedure(int PageSize, int PageIndex, string strWhere)        {            using (SqlConnection connection = new SqlConnection(connectionString))            {                DataSet ds = new DataSet();                try                {                    connection.Open();                    SqlDataAdapter command = new SqlDataAdapter(strWhere, connection);                    command.Fill(ds, PageIndex, PageSize, strWhere);                }                catch (System.Data.SqlClient.SqlException ex)                {                    throw new Exception(ex.Message);                }                return ds;            }        }