OleDb数据层C#代码

public class Conn
 {
  public OleDbConnection my_Conn;

  public static string strConn
  {
   get
   {
    StringBuilder builder1 = new StringBuilder();
    builder1.Append("Provider = Microsoft.Jet.OLEDB.4.0");
    builder1.Append("; ");
    builder1.Append("Data Source = ");
    builder1.Append(HttpContext.Current.Server.MapPath("."));
    builder1.Append(@"\");
    builder1.Append(ConfigurationSettings.AppSettings["DataPath"]);
    return builder1.ToString();
   }
  }

  public void DBopen()
  {
   if (this.my_Conn.State == ConnectionState.Closed)
   {
    this.my_Conn.Open();
   }
  }

  public void DBclose()
  {
   if (this.my_Conn.State == ConnectionState.Open)
   {
    this.my_Conn.Close();
   }
  }

  public DataSet CreateDataSet(string strSql, string tableName)
  {
   OleDbDataAdapter adapter1 = new OleDbDataAdapter(strSql, this.my_Conn);
   DataSet set1 = new DataSet();
   adapter1.Fill(set1, tableName);
   return set1;
  }

  public int ExecuteSql(string strSql)
  {
   OleDbCommand command1 = new OleDbCommand(strSql, this.my_Conn);
   return command1.ExecuteNonQuery();
  }

  public OleDbDataReader ExecuteOleDbDataReader(string strSql)
  {
   OleDbCommand command1 = new OleDbCommand(strSql, this.my_Conn);
   return command1.ExecuteReader();
  }

  public Conn()
  {
   this.my_Conn = new OleDbConnection(Conn.strConn);
  }
 }