ACCESS数据库重复 DBHelper类
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data; using System.Data.OleDb; /// <summary> /// DBHelper 的摘要说明 /// </summary> public static class DBHelper { private static readonly string conStr = System.Configuration.ConfigurationManager.ConnectionStrings["WebSiteConnectionString"].ConnectionString; public static OleDbConnection GetConnection { get { return new OleDbConnection(conStr) } } //增、删、改 public static int ExcuteCommand(String safeSql) { int result = 0; using (OleDbConnection conn = GetConnection) { conn.Open(); OleDbCommand cmd = new OleDbCommand(safeSql, conn); result = cmd.ExecuteNonQuery(); } return result; } //重载(增、删、改)带参数 public static int ExcuteCommand(String safeSql, params OleDbParameter[] param) { int result = 0; using (OleDbConnection conn = GetConnection) { conn.Open(); OleDbCommand cmd = new OleDbCommand(safeSql, conn); cmd.Parameters.AddRange(param); result = cmd.ExecuteNonQuery(); } return result; } public static Object GetScalar(String safeSql) { Object obj = null; using (OleDbConnection conn = GetConnection) { conn.Open(); OleDbCommand cmd = new OleDbCommand(safeSql, conn); obj = cmd.ExecuteScalar(); } return obj; } public static Object GetScalar(String safeSql, params OleDbParameter[] param) { Object obj = null; using (OleDbConnection conn = GetConnection) { conn.Open(); OleDbCommand cmd = new OleDbCommand(safeSql, conn); cmd.Parameters.AddRange(param); obj = cmd.ExecuteScalar(); } return obj; } public static OleDbDataReader GetDataReader(String safeSql) { OleDbConnection conn = GetConnection; conn.Open(); OleDbCommand cmd = new OleDbCommand(safeSql, conn); return cmd.ExecuteReader(CommandBehavior.CloseConnection); } public static OleDbDataReader GetDataReader (String safeSql, params OleDbParameter[] param) { OleDbConnection conn = GetConnection; conn.Open(); OleDbCommand cmd = new OleDbCommand(safeSql, conn); cmd.Parameters.AddRange(param); return cmd.ExecuteReader(CommandBehavior.CloseConnection); } public static DataTable GetDataTable(String safeSql) { DataTable dt = new DataTable(); OleDbDataAdapter sda = new OleDbDataAdapter(safeSql, GetConnection); sda.Fill(dt); return dt; } public static DataTable GetDataTable(String safeSql, params OleDbParameter[] param) { DataTable dt = new DataTable(); OleDbDataAdapter sda = new OleDbDataAdapter(safeSql, GetConnection); sda.SelectCommand.Parameters.AddRange(param); sda.Fill(dt); return dt; } }