操作Access的通用数据库类

using System;using System.Collections.Generic;using System.Text;using System.Data;using System.Configuration;using System.Data.OleDb;public static class OleDbDBHelp{ private static OleDbConnection connection; public static OleDbConnection Connection { get { string connectionString = ConfigurationManager.ConnectionStrings["accconn"].ConnectionString; if (connection == null) { connection = new OleDbConnection(connectionString); connection.Open(); } else if (connection.State == System.Data.ConnectionState.Closed) { connection.Open(); } else if (connection.State == System.Data.ConnectionState.Broken) { connection.Close(); connection.Open(); } return connection; } } public static int ExecuteCommand(string safeOleDb) { OleDbCommand cmd = new OleDbCommand(safeOleDb, Connection); int result = cmd.ExecuteNonQuery(); return result; } public static int ExecuteCommand(string OleDb, params OleDbParameter[] values) { OleDbCommand cmd = new OleDbCommand(OleDb, Connection); cmd.Parameters.AddRange(values); return cmd.ExecuteNonQuery(); } public static int GetScalar(string safeOleDb) { OleDbCommand cmd = new OleDbCommand(safeOleDb, Connection); int result = Convert.ToInt32(cmd.ExecuteScalar()); return result; } public static int GetScalar(params OleDbParameter[] values) { OleDbCommand cmd = new OleDbCommand(); cmd.Connection = Connection; cmd.CommandText = "Pro_InsertOrder"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddRange(values); int result = Convert.ToInt32(cmd.ExecuteScalar()); return result; } public static int GetScalar(string OleDb, params OleDbParameter[] values) { OleDbCommand cmd = new OleDbCommand(OleDb, Connection); cmd.Parameters.AddRange(values); int result = Convert.ToInt32(cmd.ExecuteScalar()); return result; } public static OleDbDataReader GetReader(string safeOleDb) { OleDbCommand cmd = new OleDbCommand(safeOleDb, Connection); OleDbDataReader reader = cmd.ExecuteReader(); return reader; } public static OleDbDataReader GetReader(string OleDb, params OleDbParameter[] values) { OleDbCommand cmd = new OleDbCommand(OleDb, Connection); cmd.Parameters.AddRange(values); OleDbDataReader reader = cmd.ExecuteReader(); return reader; } public static DataTable GetDataSet(string safeOleDb) { DataSet ds = new DataSet(); OleDbCommand cmd = new OleDbCommand(safeOleDb, Connection); OleDbDataAdapter da = new OleDbDataAdapter(cmd); da.Fill(ds); return ds.Tables[0]; } public static DataTable GetDataSet(string OleDb, params OleDbParameter[] values) { DataSet ds = new DataSet(); OleDbCommand cmd = new OleDbCommand(OleDb, Connection); cmd.Parameters.AddRange(values); OleDbDataAdapter da = new OleDbDataAdapter(cmd); da.Fill(ds); return ds.Tables[0]; }}

 

web配置文件添加数据库连接信息:

........省略其他代码......<configuration><appSettings/> <connectionStrings> <add name="accconn" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=|DataDirectory|scdb.mdb" providerName="System.Data.OleDb" /> </connectionStrings>........省略其他代码......