public DataSet CreateDataSet(string query)
{
DbCommand sqlcom = null;
DbConnection myConn = null;
IFactoryDbPool pool = OledbConnectionSingletion.CreateInstance();
try
{
ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings["OledbConnectionString"];
OledbConnectionSingletion.ConnectionString = settings.ConnectionString;
//Borrow the SqlConnection object from the pool
myConn = pool.BorrowDBConnection();
sqlcom = new OleDbCommand(query, (OleDbConnection)myConn);
DataSet ds = new DataSet();
OleDbDataAdapter oda = new OleDbDataAdapter();
oda.SelectCommand = (OleDbCommand)sqlcom;
oda.Fill(ds);
return(ds);
}
catch (Exception)
{
if (sqlcom != null)
{
sqlcom.Dispose();
}
return(null);
}
finally
{
pool.ReturnDBConnection(myConn);
}
}
public string UpDate(string query)
{
DbCommand sqlcom = null;
DbConnection myConn = null;
IFactoryDbPool pool = OledbConnectionSingletion.CreateInstance();
try
{
if (ConfigurationManager.ConnectionStrings["OledbConnectionString"] != null)
{
ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings["OledbConnectionString"];
OledbConnectionSingletion.ConnectionString = settings.ConnectionString;
}
//Borrow the SqlConnection object from the pool
myConn = pool.BorrowDBConnection();
sqlcom = new OleDbCommand(query, (OleDbConnection)myConn);
sqlcom.ExecuteNonQuery();
return("Success");
}
catch (Exception ee)
{
if (sqlcom != null)
{
sqlcom.Dispose();
}
return(ee.Message);
}
finally
{
pool.ReturnDBConnection(myConn);
}
}
public static OledbConnectionSingletion CreateInstance()
{
if (instance == null)
{
lock (locker)
{
if (instance == null)
{
instance = new OledbConnectionSingletion();
}
}
}
return(instance);
}
public string ExecProcedures(string procedure, string[] seg, object[] value, string result)
{
DbCommand sqlcom = null;
DbConnection myConn = null;
IFactoryDbPool pool = OledbConnectionSingletion.CreateInstance();
try
{
ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings["OledbConnectionString"];
OledbConnectionSingletion.ConnectionString = settings.ConnectionString;
//Borrow the SqlConnection object from the pool
myConn = pool.BorrowDBConnection();
sqlcom = myConn.CreateCommand();;
sqlcom.CommandType = CommandType.StoredProcedure;
sqlcom.CommandText = procedure;
if (seg.Length == value.Length)
{
for (int i = 0; i < seg.Length; i++)
{
OleDbParameter p = new OleDbParameter(seg[i], value[i]);
p.Direction = ParameterDirection.Input;
sqlcom.Parameters.Add(p);
}
}
sqlcom.Parameters.Add(new OleDbParameter("result",
OleDbType.VarChar));
sqlcom.Parameters["result"].Direction = ParameterDirection.Output;
sqlcom.ExecuteNonQuery();
return(sqlcom.Parameters["result"].Value.ToString());
}
catch (Exception)
{
if (sqlcom != null)
{
sqlcom.Dispose();
}
return(null);
}
finally
{
pool.ReturnDBConnection(myConn);
}
}
