commandbuilder.cs

C#2.0宝典源码,C#经典书籍,很多例子

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

namespace StudentsMIS.DataAccess
{
	/// <summary>
	/// CommandBuilder 的摘要说明。
	/// </summary>
	public class CommandBuilder
	{
    public static OleDbCommand BuildOleDbCommand(string cmdText)
    {
      return new OleDbCommand(cmdText,ConnectionBuilder.BuildOleDbConnection());
    }

    public static DataSet BuildOleDbDataSet(string cmdText)
    {
      OleDbCommand objCommand = BuildOleDbCommand(cmdText);
      OleDbDataAdapter objAdapter = new OleDbDataAdapter(objCommand);
      DataSet ds = new DataSet();
      objAdapter.Fill(ds);
      //销毁
      objCommand.Connection.Close();
      objCommand.Connection.Dispose();
      objCommand.Dispose();
      return ds; 
    }

    public static OleDbDataReader BuildOleDbDataReader(string cmdText)
    {
      OleDbCommand objCommand = BuildOleDbCommand(cmdText);
      OleDbDataReader objReader = objCommand.ExecuteReader();
      return objReader;
    }
	}
}