using
System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using System.Data;
using System.Configuration;
namespace Dal
{
public sealed class OleHelper
{
private OleHelper()
{ }
public static OleDbConnection Conn
{
get
{
return new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + AppDomain.CurrentDomain.BaseDirectory + ConfigurationSettings.AppSettings["DataName"]);
}
}
public static DataSet ExecuteDataset(OleDbConnection connection, CommandType commandType, string commandText)
{
OleDbCommand cmd = new OleDbCommand();
PrepareCommand(cmd, connection, null, commandType, commandText);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
cmd.Parameters.Clear();
connection.Close();
return ds;
}
public static DataSet ExecuteDataset(OleDbConnection connection, CommandType commandType, string commandText, OleDbParameter[] parameters)
{
OleDbCommand cmd = new OleDbCommand();
PrepareCommand(cmd, connection, commandType, commandText, parameters);
DataSet retval = cmd.ExecuteDataset();
cmd.Parameters.Clear();
connection.Close();
return retval;
}
public static int ExecuteNonQuery(OleDbConnection connection, CommandType commandType, string commandText)
{
OleDbCommand cmd = new OleDbCommand();
PrepareCommand(cmd, connection, null, commandType, commandText);
int retval = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
connection.Close();
return retval;
}
public static int ExecuteNonQuery(OleDbConnection connection, CommandType commandType, string commandText, OleDbParameter[] parameters)
{
OleDbCommand cmd = new OleDbCommand();
PrepareCommand(cmd, connection, commandType, commandText, parameters);
int retval = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
connection.Close();
return retval;
}
public static object ExecuteScalar(OleDbConnection connection, CommandType commandType, string commandText)
{
OleDbCommand cmd = new OleDbCommand();
PrepareCommand(cmd, connection, null, commandType, commandText);
object retval = cmd.ExecuteScalar();
cmd.Parameters.Clear();
connection.Close();
return retval;
}
public static object ExecuteScalar(OleDbConnection connection, CommandType commandType, string commandText, OleDbParameter[] parameters)
{
OleDbCommand cmd = new OleDbCommand();
PrepareCommand(cmd, connection, commandType, commandText, parameters);
object retval = cmd.ExecuteScalar();
cmd.Parameters.Clear();
connection.Close();
return retval;
}
public static OleDbDataReader ExecuteReader(OleDbConnection connection, CommandType commandType, string commandText)
{
OleDbCommand cmd = new OleDbCommand();
PrepareCommand(cmd, connection, null, commandType, commandText);
OleDbDataReader retval = cmd.ExecuteReader();
cmd.Parameters.Clear();
connection.Close();
return retval;
}
public static OleDbDataReader ExecuteReader(OleDbConnection connection, CommandType commandType, string commandText,OleDbParameter[] parameters)
{
OleDbCommand cmd = new OleDbCommand();
PrepareCommand(cmd, connection, commandType, commandText, parameters);
OleDbDataReader retval = cmd.ExecuteReader();
cmd.Parameters.Clear();
connection.Close();
return retval;
}
private static void PrepareCommand(OleDbCommand command, OleDbConnection connection, OleDbTransaction transaction, CommandType commandType, string commandText)
{
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
command.Connection = connection;
command.CommandText = commandText;
if (transaction != null)
{
command.Transaction = transaction;
}
command.CommandType = commandType;
return;
}
private static void PrepareCommand(OleDbCommand command, OleDbConnection connection, CommandType commandType, string commandText,OleDbParameter[] parameters)
{
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
command.Connection = connection;
command.CommandText = commandText;
command.Parameters = parameters;
command.CommandType = commandType;
return;
}
}
}
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using System.Data;
using System.Configuration;
namespace Dal
{
public sealed class OleHelper
{
private OleHelper()
{ }
public static OleDbConnection Conn
{
get
{
return new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + AppDomain.CurrentDomain.BaseDirectory + ConfigurationSettings.AppSettings["DataName"]);
}
}
public static DataSet ExecuteDataset(OleDbConnection connection, CommandType commandType, string commandText)
{
OleDbCommand cmd = new OleDbCommand();
PrepareCommand(cmd, connection, null, commandType, commandText);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
cmd.Parameters.Clear();
connection.Close();
return ds;
}
public static DataSet ExecuteDataset(OleDbConnection connection, CommandType commandType, string commandText, OleDbParameter[] parameters)
{
OleDbCommand cmd = new OleDbCommand();
PrepareCommand(cmd, connection, commandType, commandText, parameters);
DataSet retval = cmd.ExecuteDataset();
cmd.Parameters.Clear();
connection.Close();
return retval;
}
public static int ExecuteNonQuery(OleDbConnection connection, CommandType commandType, string commandText)
{
OleDbCommand cmd = new OleDbCommand();
PrepareCommand(cmd, connection, null, commandType, commandText);
int retval = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
connection.Close();
return retval;
}
public static int ExecuteNonQuery(OleDbConnection connection, CommandType commandType, string commandText, OleDbParameter[] parameters)
{
OleDbCommand cmd = new OleDbCommand();
PrepareCommand(cmd, connection, commandType, commandText, parameters);
int retval = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
connection.Close();
return retval;
}
public static object ExecuteScalar(OleDbConnection connection, CommandType commandType, string commandText)
{
OleDbCommand cmd = new OleDbCommand();
PrepareCommand(cmd, connection, null, commandType, commandText);
object retval = cmd.ExecuteScalar();
cmd.Parameters.Clear();
connection.Close();
return retval;
}
public static object ExecuteScalar(OleDbConnection connection, CommandType commandType, string commandText, OleDbParameter[] parameters)
{
OleDbCommand cmd = new OleDbCommand();
PrepareCommand(cmd, connection, commandType, commandText, parameters);
object retval = cmd.ExecuteScalar();
cmd.Parameters.Clear();
connection.Close();
return retval;
}
public static OleDbDataReader ExecuteReader(OleDbConnection connection, CommandType commandType, string commandText)
{
OleDbCommand cmd = new OleDbCommand();
PrepareCommand(cmd, connection, null, commandType, commandText);
OleDbDataReader retval = cmd.ExecuteReader();
cmd.Parameters.Clear();
connection.Close();
return retval;
}
public static OleDbDataReader ExecuteReader(OleDbConnection connection, CommandType commandType, string commandText,OleDbParameter[] parameters)
{
OleDbCommand cmd = new OleDbCommand();
PrepareCommand(cmd, connection, commandType, commandText, parameters);
OleDbDataReader retval = cmd.ExecuteReader();
cmd.Parameters.Clear();
connection.Close();
return retval;
}
private static void PrepareCommand(OleDbCommand command, OleDbConnection connection, OleDbTransaction transaction, CommandType commandType, string commandText)
{
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
command.Connection = connection;
command.CommandText = commandText;
if (transaction != null)
{
command.Transaction = transaction;
}
command.CommandType = commandType;
return;
}
private static void PrepareCommand(OleDbCommand command, OleDbConnection connection, CommandType commandType, string commandText,OleDbParameter[] parameters)
{
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
command.Connection = connection;
command.CommandText = commandText;
command.Parameters = parameters;
command.CommandType = commandType;
return;
}
}
}