C#调用Microsoft.Jet.OLEDB.4.0查看MDB数据库

qq_36403486

已于 2022-08-15 16:59:20 修改

阅读量1.4k

点赞数

文章标签：数据库 c# microsoft

于 2022-08-15 16:58:31 首次发布

本文链接：https://blog.csdn.net/qq_36403486/article/details/126349826

版权

核心代码

using System.Data.OleDb;

using System.Data.OleDb;
        //GETDATATABLE
        public static DataTable GetDatatable(string sql) {
            //connsrt:Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\\fruit.mdb //Jet OLEDB:Database Password=
            OleDbConnection conn = new OleDbConnection(MdbConnStr);
            OleDbCommand cmd = conn.CreateCommand();
            cmd.CommandText = sql;
            conn.Open();
            OleDbDataReader dr = cmd.ExecuteReader();
            DataTable dt = new DataTable();
            for (int i = 0; i < dr.FieldCount; i++) {
                dt.Columns.Add(dr.GetName(i));
            }
            dt.Rows.Clear();
            while (dr.Read()) {
                DataRow row = dt.NewRow();
                for (int i = 0; i < dr.FieldCount; i++) {
                    row[i] = dr[i];
                }
                dt.Rows.Add(row);
            }
            cmd.Dispose();
            conn.Close();
            return dt;

        }
        //执行SQL语句
        public static int ExecuteNonQuery(string sql) {
            //connsrt:Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\\fruit.mdb //Jet OLEDB:Database Password=
            OleDbConnection conn = new OleDbConnection(MdbConnStr);
            OleDbCommand cmd = conn.CreateCommand();
            try {
                cmd.CommandText = sql;
                conn.Open();
                int c = cmd.ExecuteNonQuery();
                cmd.Dispose();
                conn.Close();
                return c;
            } catch {
                cmd.Dispose();
                conn.Close();
                return -1;
            }
        }
        /// <summary>
        /// 获取数据库架构信息
        /// </summary>
        /// <returns></returns>
        public static DataTable GetSchema() {
            OleDbConnection conn = new OleDbConnection(MdbConnStr);
            try {
                conn.Open();
                DataTable schemaDt = conn.GetSchema();
                conn.Close();
                return schemaDt;
            } catch (Exception ex) {
                conn.Close();
                throw new Exception(ex.ToString());
            }
        }