using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;
/// <summary>
///AccessDBHelper 的摘要说明
/// </summary>
public class AccessDBHelper
{
private string connectionString = "Provider=Microsoft.Jet.OleDb.4.0;Jet Oledb:Database Password=mingmei114;Data Source=";
public AccessDBHelper()
{
}
public AccessDBHelper(string AsaFilePath)
{
connectionString += AsaFilePath;
}
private OleDbConnection connection;
public OleDbConnection Connection
{
get
{
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 int ExecuteCommand(string safeSql)
{
OleDbCommand cmd = new OleDbCommand(safeSql,Connection);
int result = cmd.ExecuteNonQuery();
return result;
}
public int ExecuteCommand(string sql, params SqlParameter[] values)
{
OleDbCommand cmd = new OleDbCommand(sql, Connection);
cmd.Parameters.AddRange(values);
return cmd.ExecuteNonQuery();
}
public int GetScalar(string safeSql)
{
OleDbCommand cmd = new OleDbCommand(safeSql, Connection);
int result = Convert.ToInt32(cmd.ExecuteScalar());
return result;
}
public int GetScalar(string sql, SqlParameter[] values)
{
OleDbCommand cmd = new OleDbCommand(sql, Connection);
cmd.Parameters.AddRange(values);
int result = Convert.ToInt32(cmd.ExecuteScalar());
return result;
}
public OleDbDataReader GetReader(string safeSql)
{
OleDbCommand cmd = new OleDbCommand(safeSql, Connection);
OleDbDataReader reader = cmd.ExecuteReader();
return reader;
}
public OleDbDataReader GetReader(string sql, SqlParameter[] values)
{
OleDbCommand cmd = new OleDbCommand(sql, Connection);
cmd.Parameters.AddRange(values);
OleDbDataReader reader = cmd.ExecuteReader();
return reader;
}
public DataTable GetDataSet(string safeSql)
{
DataSet ds = new DataSet();
OleDbCommand cmd = new OleDbCommand(safeSql, Connection);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
da.Fill(ds);
return ds.Tables[0];
}
public DataTable GetDataSet(string sql, SqlParameter[] values)
{
DataSet ds = new DataSet();
OleDbCommand cmd = new OleDbCommand(sql, Connection);
cmd.Parameters.AddRange(values);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
da.Fill(ds);
return ds.Tables[0];
}
}
用法:
protected string BindDrName(string srk) //收款人 销售员
{
if (Session["shopid"] == null)
Response.Redirect("MemberLogin.aspx");
string myshopDB = Session["shopid"].ToString();
string asafilepath = System.Web.HttpContext.Current.Server.MapPath("~/App_Data/" + myshopDB + ".asa");
AccessDBHelper acc = new AccessDBHelper(asafilepath);
string sql = "select * from dr where dr_hm='" + srk +"'";
DataTable dt = acc.GetDataSet(sql);
string drname = "";
foreach (DataRow item in dt.Rows)
{
drname = item["dr_name"].ToString();
}
return drname;
}