根据分页的存储过程进行数据绑定的方法

        /// <summary>
        /// 分页方法
        /// </summary>
        /// <param name="tablename">表名</param>
        /// <param name="IdName">主键名</param>
        /// <param name="columns">选取的列,默认为*,表示全部</param>
        /// <param name="whereText">查询条件,可以为空,默认为1=1</param>
        /// <param name="orderText">排序条件,可以为空,默认为空</param>
        /// <param name="startIndex">开始值</param>
        /// <param name="endIndex">结束值</param>
        /// <returns></returns>
        public static DataTable GetPager(string tablename,string IdName,string columns,string whereText,string orderText,int startIndex,int endIndex)
        {
            if (string.IsNullOrEmpty(columns))
            {
                columns="*";
            }
            if (string.IsNullOrEmpty(whereText))
            {
                whereText = " 1=1 ";
            }
            if (string.IsNullOrEmpty(orderText))
            {
                orderText = " id ";
            }
            SqlParameter[] par ={
                new     SqlParameter("@Tname",tablename),
                        new SqlParameter("@kname",IdName),
                        new SqlParameter("@columns",columns),
                        new SqlParameter("@whereText",whereText),
                        new SqlParameter("@orderText",orderText),
                        new SqlParameter("@startIndex", startIndex),
                        new SqlParameter("@endIndex", endIndex)
            };

            return GetPagerBase(GlobalConnectionString.ToString(), CommandType.StoredProcedure, "sp_paging", par).Tables[0];
        }
        /// <summary>
        /// 分页基础方法
        /// </summary>
        /// <param name="m_connectionString"></param>
        /// <param name="cmdType"></param>
        /// <param name="cmdText"></param>
        /// <param name="cmdParms"></param>
        /// <returns></returns>
        private static DataSet GetPagerBase(string m_connectionString, CommandType cmdType, string cmdText, params SqlParameter[] cmdParms)
        {
            SqlCommand cmd = new SqlCommand();
            SqlConnection conn = new SqlConnection(m_connectionString);

            // we use a try/catch here because if the method throws an exception we want to 
            // close the connection throw code, because no datareader will exist, hence the 
            // commandBehaviour.CloseConnection will not work
            try
            {
                PrepareCommand(cmd, conn, null, cmdType, cmdText, cmdParms);
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                da.Fill(ds);

                // detach the SqlParameters from the command object, so they can be used again.            
                cmd.Parameters.Clear();
                return ds;
            }
            catch
            {
                conn.Close();
                throw;
            }
        }
        /// <summary>
        /// 获取查询到的数据总数,用于分页
        /// </summary>
        /// <param name="tablename">表名</param>
        /// <param name="sqlwhere">查询条件,不带where</param>
        /// <returns></returns>
        public static int GetPagingNum(string tablename, string sqlwhere)
        {
            string sql = "select count(id) from {0} where {1}";
            return (int)ExecuteScalar(string.Format(sql,tablename,sqlwhere));
        }