access类常用方法

来源：互联网发布：linux jdk 安装编辑：程序博客网时间：2024/06/15 20:49
/// <summary>    /// 获取所有表    /// </summary>    /// <param name="ConnAcc"></param>    /// <returns></returns>    public static DataTable Get_AllTables(string ConnAcc)    {        OleDbConnection connection = new OleDbConnection(ConnAcc);        try        {            connection.Open();            DataTable dt = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });            connection.Close();            return dt;        }        catch (System.Data.SqlClient.SqlException E)        {            connection.Close();            throw new Exception(E.Message);        }    }    /// <summary>    /// 获取列    /// </summary>    /// <param name="ConnAcc"></param>    /// <param name="tableName"></param>    /// <returns></returns>    public static DataTable Get_TablesColumns(string ConnAcc, string tableName)    {        string connnectionString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + ConnAcc;        OleDbConnection connection = new OleDbConnection(ConnAcc);        try        {            connection.Open();            DataTable dt = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new object[] { null, null, tableName, null });            //dt.DefaultView.Sort = "ordinal_position asc";            connection.Close();            return dt;        }        catch (System.Data.SqlClient.SqlException E)        {            connection.Close();            throw new Exception(E.Message);        }    }    /// <summary>    ///执行结果条数    /// </summary>    /// <param name="querstr"></param>    /// <returns></returns>    public static int ExecuteNonQuery(string ConnAcc, string querstr)    {        OleDbConnection Conn = new OleDbConnection(ConnAcc);        try        {            Conn.Open();            OleDbCommand mycom = new OleDbCommand(querstr, Conn);            int myc = mycom.ExecuteNonQuery();            Conn.Close();            return myc;        }        catch (System.Data.SqlClient.SqlException E)        {            Conn.Close();            throw new Exception(E.Message);        }    }    /// <summary>    /// 查询总条数    /// </summary>    /// <param name="ConnAcc">链接字符串</param>    /// <param name="querstr">查询语句</param>    /// <returns></returns>    public static int ExecuteCount(string ConnAcc, string querstr)    {        OleDbConnection Conn = new OleDbConnection(ConnAcc);        try        {            Conn.Open();            OleDbCommand mycom = new OleDbCommand(querstr, Conn);            int myc = Convert.ToInt32(mycom.ExecuteScalar());            Conn.Close();            return myc;        }        catch (System.Data.SqlClient.SqlException E)        {            Conn.Close();            throw new Exception(E.Message);        }    }    /// <summary>    /// admin下的文件夹下的返回Table    /// </summary>    /// <param name="querstr"></param>    /// <returns></returns>    public static DataTable ExecuteAccessTable(string ConnAcc, string querstr)    {        OleDbConnection Conn = new OleDbConnection(ConnAcc);        try        {            Conn.Open();            OleDbDataAdapter myadapter = new OleDbDataAdapter(querstr, Conn);            DataTable dt = new DataTable();            myadapter.Fill(dt);            Conn.Close();            return dt;        }        catch (System.Data.SqlClient.SqlException E)        {            Conn.Close();            throw new Exception(E.Message);        }    }    //前台分页    public static DataTable PagerSource1(string ConnAcc, int startIndex, int pageSize, string sql, string table)    {        OleDbConnection connection = new OleDbConnection(ConnAcc);        try        {            connection.Open();            DataSet ds = new DataSet();            OleDbDataAdapter MyAdapter = new OleDbDataAdapter(sql, connection);            MyAdapter.Fill(ds, startIndex, pageSize, table);            connection.Close();            return ds.Tables[0];        }        catch (System.Data.SqlClient.SqlException E)        {            connection.Close();            throw new Exception(E.Message);        }    }
0 0