public/DatabaseOper.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
 * Author:Gaofa Wu
 * Date:2003-11-1
 * Function:Search,add,delete and modification to database.
 */

using System; 
using System.Data;
using System.Data .SqlClient ;
using System.Collections;


namespace OI.DatabaseOper
{
	/// <summary>
	/// Database operation
	/// </summary>
	public class DatabaseConnect: System.IDisposable 
	{
        private string source = System.Configuration.ConfigurationManager.AppSettings["connstr"].ToString();
		private  SqlConnection conn;
		
		public DatabaseConnect()
		{
			dataConnect();
		}
		public void DataBaseClose()
		{
			closeConnect();
		}
		~DatabaseConnect()
		{
			this.Dispose();
		}
		public void Dispose()
		{
//			if(conn!=null)
//			closeConnect();
//			conn=null;
			GC.SuppressFinalize (true);
		}
		/// <summary>
		/// Bind data
		/// </summary>
		/// <param name="SQL">"SELECT" sentence.</param>
		/// <param name="fillTable">Temp table's name</param>
		/// <returns>Data of "DataSet" type</returns>
		public DataSet getBinding(string SQL,string fillTable)
		{
			GC.Collect();
			this.dataConnect ();
			DataSet myDataSet= new DataSet();
			SqlDataAdapter myCommand=new SqlDataAdapter(SQL,conn);
			//Fill DataSet 
			myCommand.Fill(myDataSet,fillTable);
			this.closeConnect ();//Close connect
			myCommand.Dispose();			
			return myDataSet;
		}
		/// <summary>