/**//// <summary>
        /// 返回?cái)?shù)據(jù)集
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public DataSet GetData(string sql,string strconn)
        {
            OleDbConnection ole=new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source="+strconn);
            ole.Open();
            OleDbCommand cm=new OleDbCommand(sql,ole);
            DataSet ds=new DataSet();
            OleDbDataAdapter da=new OleDbDataAdapter(cm);
            da.Fill(ds);
            ole.Close();

            return ds;
        }

        /**//// <summary>
        /// 分頁(yè)
        /// </summary>
        /// <param name="pagesize">每頁(yè)大小</param>
        /// <param name="pageindex">當(dāng)前頁(yè)數(shù)</param>
        /// <param name="field">獲取字段名</param>
        /// <param name="tablename">表名</param>
        /// <param name="orderfield">排序字段</param>
        /// <param name="taxis">排序方式,true為升序，false為降序</param>
        /// <param name="condition">滿足的條件</param>
        /// <returns></returns>
        public DataSet GetPage(int pagesize,int pageindex,string field,string tablename,string orderfield,bool taxis,string condition)
        {
            string temp;
            if(taxis)
            {
                temp="asc";
            }
            else
            {
                temp="desc";
            }

            string sql;
            if(pageindex==1)             
            {
                if(condition=="")
                {
                    sql="select top "+pagesize+" "+field+" from "+tablename+" order by "+orderfield+" "+temp;
                    return GetData(sql);
                }
                else
                {
                    sql="select top "+pagesize+" "+field+" from "+tablename+" where "+condition+" order by "+orderfield+" "+temp;
                    return GetData(sql);
                }
            }
            else
            {
                pageindex=(pageindex-1)*pagesize;
                if(condition=="")
                {
                    if(taxis)
                    {
                        sql="select top "+pagesize+" "+field+" from "+tablename+" where "+orderfield+">all(select top "+pageindex+" "+orderfield+" from "+tablename+" order by "+orderfield+" "+temp+") order by "+orderfield+" "+temp;
                    }
                    else
                    {
                        sql="select top "+pagesize+" "+field+" from "+tablename+" where "+orderfield+"<all(select top "+pageindex+" "+orderfield+" from "+tablename+" order by "+orderfield+" "+temp+") order by "+orderfield+" "+temp;
                    }
                    return GetData(sql);
                }
                else
                {
                    if(taxis)
                    {
                        sql="select top "+pagesize+" "+field+" from "+tablename+" where "+condition+" and "+orderfield+">all(select top "+pageindex+" "+orderfield+" from "+tablename+" where "+condition+" order by "+orderfield+" "+temp+") order by "+orderfield+" "+temp;
                    }
                    else
                    {
                        sql="select top "+pagesize+" "+field+" from "+tablename+" where "+condition+" and "+orderfield+"<all(select top "+pageindex+" "+orderfield+" from "+tablename+" where "+condition+" order by "+orderfield+" "+temp+") order by "+orderfield+" "+temp;
                    }
                    return GetData(sql);
                }
            }

        }

希望給于評(píng)價(jià)
http://www.survivalescaperooms.com/wang123/archive/2006/12/08/586505.html