C#调用Microsoft.Jet.OLEDB.4.0查看MDB数据库-Toy模板网

这篇具有很好参考价值的文章主要介绍了C#调用Microsoft.Jet.OLEDB.4.0查看MDB数据库。希望对大家有所帮助。如果存在错误或未考虑完全的地方，请大家不吝赐教，您也可以点击"举报违法"按钮提交疑问。

核心代码

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());
            }
        }

provider=microsoft.jet.oledb.4.0,数据库,c#,microsoft