mdbc.cs

来自「《精通ASP.NET网络编程》附带实例」· CS 代码 · 共 49 行

using System;
using System.Data;
using System.Data.OleDb;
namespace MycMdb
{
   public class Mdbc
   { 
    private string ConnStr;
    private int Index;
    public Mdbc(string PathName) 
    {
     ConnStr="Provider=Microsoft.Jet.OLEDB.4.0;"+"Data Source="+PathName;
    }
   public OleDbDataReader GetDataReader(string SelectSQL)
    {
     OleDbConnection Conn;
     OleDbCommand Cmd;
     OleDbDataReader myDataReader;
     Conn= new OleDbConnection(ConnStr);
     Cmd = new OleDbCommand(SelectSQL, Conn); 
     Conn.Open();
     myDataReader=Cmd.ExecuteReader();
     return myDataReader;
    }
   public DataView GetDataView(string SelectSQL)
    {
     OleDbConnection Conn;
     OleDbDataAdapter Cmd;
     DataSet ds;
     string TableName;
     Conn= new OleDbConnection(ConnStr);
     Cmd = new OleDbDataAdapter(SelectSQL, Conn);
     Index+=1;
     TableName ="Table"+Index;
     ds=new DataSet();
     Cmd.Fill(ds, TableName);
     return(new DataView(ds.Tables[TableName]));
    }
  public void ExecuteSQL(string ActionQuery) 
    {
     OleDbCommand Cmd;
     OleDbConnection Conn= new OleDbConnection(ConnStr);
     Cmd = new OleDbCommand(ActionQuery, Conn);
     Conn.Open();
     Cmd.ExecuteNonQuery();
    }
   }
}