access数据库的分页显示的C#代码


    public class DBHelper
    {
        //属性:数据库链接对象
        private static OleDbConnection conn;
        public static OleDbConnection Conn
        {
            get
            {
                try
                {
                    string connstr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source=" + "" + Application.StartupPath + @"\Database.mdb";                    if (conn == null)
                        conn = new OleDbConnection(connstr);
                    if (conn.State == ConnectionState.Closed)
                        conn.Open();
                    if (conn.State == ConnectionState.Broken)
                    {
                        conn.Close();
                        conn.Open();
                    }
                    return conn;                }
                catch (Exception ex)
                {                    throw;
                }
            }
        }
        //方法:查询,DataReader
        public static OleDbDataReader GetReader(string SqlStr)
        {
            OleDbCommand cmd = new OleDbCommand(SqlStr, Conn);
            return cmd.ExecuteReader();
        }        public static OleDbDataReader GetReader(string SqlStr, OleDbParameter[] paras)
        {
            OleDbCommand cmd = new OleDbCommand(SqlStr, Conn);
            cmd.Parameters.AddRange(paras);
            return cmd.ExecuteReader();
        }
        //查询:DataTable
        public static DataTable GetTable(string SqlStr)
        {
            try
            {
               OleDbDataAdapter dap = new OleDbDataAdapter(SqlStr, Conn);
                DataSet ds = new DataSet();
                dap.Fill(ds);
                conn.Close();
                return ds.Tables[0];
            }
            catch (Exception ex)
            {
                throw;
            }
        }        //增删改
        public static bool Execute(string SqlStr)
        {
            OleDbCommand cmd = new OleDbCommand(SqlStr, Conn);
            int result = cmd.ExecuteNonQuery();
            conn.Close();
            return result > 0;
        }        /// <summary>    
        /// 向数据库里插入图像格式的字段(和上面情况类似的另一种实例)    
        /// </summary>    
        /// <param name="strSQL">SQL语句</param>    
        /// <param name="fs">图像字节,数据库的字段类型为image的情况</param>    
        /// <returns>影响的记录数</returns>    
        public static int Execute(string SqlStr, byte[] photo)
        {
            OleDbCommand cmd = new OleDbCommand(SqlStr, Conn);
            OleDbParameter myParameter = new OleDbParameter("@photo", SqlDbType.Image);
            myParameter.Value = photo;
            cmd.Parameters.Add(myParameter);
            int result = cmd.ExecuteNonQuery();
            return result;
        }        //返回首行首列
        public static object GetScalar(string SqlStr)
        {
            OleDbCommand cmd = new OleDbCommand(SqlStr, Conn);
            object obj = cmd.ExecuteScalar();
            conn.Close();
            return obj;
        }