DATABASE ACCESS, SQL WRAPPER

using System;
using System.Data.OleDb;
using System.Windows.Forms;

namespace cDatabase
{
	/// <summary>
	/// Summary description for cAccess.
	/// </summary>
	/// 
	public class cAccessException:Exception 
	{
		private string errorMessage;

		public override string Message
		{
			get
			{
				return this.errorMessage ;
			}
		}

		public cAccessException(string ErrorMessage)
		{
			this.errorMessage = ErrorMessage;
		}
		public override string ToString()
		{
			return this.errorMessage;
		}
	}





	public class cAccess
	{
		private OleDbConnection oConn = new OleDbConnection();
		private OleDbCommand oCmd = new OleDbCommand();
		
		private string Provider= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
		private string Security= ";Persist Security Info=False";
		private string Security2=";Jet OLEDB:Database Password=";
		private string Security3="User Id=";
		
		public OleDbConnection GetConnection()
		{
			if (oConn !=null)
			{
				return oConn;
			}
			else
			{	
				return null;
			}	

		}

		public cAccess(string Database)
		{
			try
			{
			oConn = new OleDbConnection(Provider + Database + Security);
				oConn.Open();

			}
			catch(Exception pe)
			{
				throw new cAccessException(pe.Message + '\r' + pe.Source );
			}
		}

		public cAccess(string Database,string User,string Passw)
		{
			try
			{
oConn = new OleDbConnection(Provider + Database + Security2 + Passw + ";" + Security3 + User + ";");
				oConn.Open();

			}
			catch(Exception pe)
			{
				throw new cAccessException(pe.Message + '\r' + pe.Source );
			}

		}
		public OleDbDataReader ExecuteReaderSql(string sql ) 
		{
			
			OleDbCommand oCmd= new OleDbCommand(sql,oConn );
			OleDbDataReader oDrdr;
			try
			{
				oDrdr= oCmd.ExecuteReader();
				
				return oDrdr;	
			}
			catch(OleDbException pe)
			{
				throw new cAccessException(pe.Message + '\r' + pe.Source );
				
			}
			
		}
		public void ExecuteQuery(string sql)
		{
			OleDbCommand oCmd= new OleDbCommand(sql,oConn );
			
			try
			{
				oCmd.ExecuteNonQuery();
				
			}
			catch(OleDbException pe)
			{
				throw new cAccessException(pe.Message + '\r' + pe.Source );
			}
			

		}
	}
}

Télécharger le zip