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数据库操作的示例代码介绍的内容。