简单的access数据库连接的基类

using System;
using System.Data.SqlClient;
using System.Data.OleDb;
using System.Data;
namespace DB
{
 /// <summary>
 /// SqlDB 的摘要说明。
 /// </summary>
 public class SqlDB:System.Web.UI.Page
 {
  public SqlDB()
  {
   //
   // TODO: 在此处添加构造函数逻辑
   //
  }
  public string DbPath()
  {
   return "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("databasc/txl.mdb")+";";
  }
  public static string ConnectionString
  {
   get
   {
    SqlDB ConnectionString=new SqlDB();
    return ConnectionString.DbPath();
   }
  }
  public static DataTable ExecSqlTable(string SqlStr)
  {
   OleDbDataAdapter da=new OleDbDataAdapter(SqlStr,SqlDB.ConnectionString);
   DataTable dt=new DataTable();
   da.Fill(dt);
   return dt; 
  }
  public static int ExecSqlInt(string SqlStr)
  {
   OleDbConnection conn=new OleDbConnection();
   conn.ConnectionString=SqlDB.ConnectionString;

   OleDbCommand cmd=new OleDbCommand();
   cmd.CommandText=SqlStr;
   cmd.Connection=conn;
      
   conn.Open();
   int i=cmd.ExecuteNonQuery();//返回命令对的影响行数
   conn.Close();//关闭数据库
   cmd.Dispose();//清除命令
   conn.Dispose();//清除数据库
   return i;
  }
  public static object ExecuteScalar(string SqlStr)
  {
   OleDbConnection conn=new OleDbConnection();
   conn.ConnectionString=SqlDB.ConnectionString;

   OleDbCommand cmd=new OleDbCommand();
   cmd.CommandText=SqlStr;
   cmd.Connection=conn;

   conn.Open();
   object c=cmd.ExecuteScalar();//返回命令对像第一行第一列
   conn.Close();//关闭数据库
   cmd.Dispose();//清除命令
   conn.Dispose();//清除数据库
   return c;
  }
 }
}