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

核心代码

using System.Data.OleDb;

using System.Data.OleDb;//GETDATATABLEpublic 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());}}

 

源码下载地址
https://download.csdn.net/download/qq_36403486/86401054

总结

以上是生活随笔为你收集整理的C#调用Microsoft.Jet.OLEDB.4.0查看MDB数据库的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。