C# Access数据库操作的示例代码介绍
程序员文章站
2022-06-05 23:33:08
...
C# Access数据库操作的示例代码介绍
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using System.Data.OleDb; namespace AccessPractice { public static class AccessHelper { public static bool Execute(string path,string sql) { try { string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";"; OleDbConnection odcConnection = new OleDbConnection(strConn); //2、打开连接 odcConnection.Open(); //建立SQL查询 OleDbCommand odCommand = odcConnection.CreateCommand(); //3、输入查询语句 odCommand.CommandText = sql; odCommand.ExecuteNonQuery(); odcConnection.Close(); return true; } catch(Exception ex) { return false; } } public static DataTable ReadAllData(string tableName, string mdbPath,int topN, ref bool success) { DataTable dt = new DataTable(); try { //1、建立连接 string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + mdbPath + ";"; OleDbConnection odcConnection = new OleDbConnection(strConn); //2、打开连接 odcConnection.Open(); //建立SQL查询 OleDbCommand odCommand = odcConnection.CreateCommand(); //3、输入查询语句 odCommand.CommandText = "select * from " + tableName; //建立读取 OleDbDataReader odrReader = odCommand.ExecuteReader(); //查询并显示数据 int size = odrReader.FieldCount; for (int i = 0; i < size; i++) { DataColumn dc; dc = new DataColumn(odrReader.GetName(i)); dt.Columns.Add(dc); } DataRow dr; int count = 0; while (odrReader.Read()) { if (++count == topN) { break; } dr = dt.NewRow(); for (int i = 0; i < size; i++) { dr[odrReader.GetName(i)] = odrReader[odrReader.GetName(i)].ToString(); } dt.Rows.Add(dr); } //关闭连接 odrReader.Close(); odcConnection.Close(); success = true; return dt; } catch { success = false; return dt; } } } }
以上就是C# Access数据库操作的示例代码介绍的内容,更多相关内容请关注PHP中文网(www.php.cn)!