C#Access访问方法.docVIP

C # Access 访问方法 using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using System.Data.OleDb; using System.IO; namespace AccessC { public class AccessC { /// summary /// 连接常量 /// /summary private OleDbConnection Con; /// summary /// SQL命令 /// /summary private OleDbCommand Com; /// summary /// 初始化一个连接实例 /// /summary /// param name=FilePath文件名/param public AccessC(string FilePath) { Con = new OleDbConnection(@Provider =Microsoft.Jet.OLEDB.4.0;Data Source = + @FilePath); Com = new OleDbCommand(); } /// summary /// 返回执行所受影响的函数 /// /summary /// param name=com/param /// returns/returns public int ExecuteGetLines(string com) { try { Com.CommandText = com; Com.Connection = Con; Con.Open(); int i = 0; i = Com.ExecuteNonQuery(); return i; } catch (Exception e) { throw new System.ArgumentException(错误, e.Message); } finally { CloseCon(); } } /// summary /// 统计特定条件的数量 /// /summary /// param name=com/param /// returns/returns public int ExecteCount(string com) { try { Com.CommandText = com; Com.Connection = Con; Con.Open(); int i = 0; i = (int)Com.ExecuteScalar(); return i; } catch (Exception e) { throw new System.ArgumentException(错误, e.Message); } finally { CloseCon(); } } /// sum