oledbprovider.cs

此项目是用asp.net开发的航班查询系统

using System;
using System.Collections;
using System.Data;
using System.Data.OleDb;

namespace OceanSoft.Data
{
	/// <summary>
	/// 通用数据访问接口的 OleDb 实现类
	/// </summary>
	internal class OleDbProvider:DefaultProvider
	{
        /// <summary>
        /// OleDb实现的构造函数
        /// </summary>
        /// <param name="ConnString">连接字符串</param>
        public OleDbProvider(string ConnString)
		{
			this.Conn=new OleDbConnection(ConnString);
		}

        /// <summary>
        /// 得到空数据适配对象
        /// </summary>
        /// <returns>基于OleDb的适配器对象</returns>
        public override IDbDataAdapter GetNullDataAdapter()
		{
			return new OleDbDataAdapter();
		}

        protected override void FillTable(IDbDataAdapter da, DataTable mDataTable)
        {
            ((OleDbDataAdapter)da).Fill(mDataTable);
        }

        protected override int GetReturnValue()
        {
            return (int)((OleDbCommand)this.Cmd).Parameters["returnValue"].Value;
        }

        protected override void SetParams()
		{
            this.Cmd.Parameters.Clear();
			IDictionaryEnumerator pParams=this.CommandParams.GetEnumerator();

			while(pParams.MoveNext())
				((OleDbCommand)this.Cmd).Parameters.Add(pParams.Key.ToString(),pParams.Value);

            OleDbParameter par = new OleDbParameter();
            par.ParameterName = "returnValue";
            par.Direction = ParameterDirection.ReturnValue;
            ((OleDbCommand)this.Cmd).Parameters.Add(par);
        }
	}
}