类库下载|C#类库
代码片段,代码分享,PHP代码分享,Java代码分享,Ruby代码分享,Python代码分享,HTML代码分享,CSS代
类库下载-C#类库
app打包ios安卓源码,ubuntu加apt错误,刘中兵.精通tomcat,spa爬虫工具,php开发共享雨伞,仓山区效果好的seo哪家好lzw
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、输入查询语句 mandText = 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、输入查询语句 mandText = "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; }} } }
批发商品展示源码,vscode如何代码语义化,ubuntu apt镜像,如何知道tomcat密码,python爬虫公司,paypal php开发,微信seo关键词,网站后台 灰色,养殖网页代码模板lzw
如果觉得《C# Access数据库操作》对你有帮助,请点赞、收藏,并留下你的观点哦!