internal IDataAdapter GetDataAdapter(string sqlCommand, IDbConnection connection, DBParameterCollection paramCollection, CommandType commandType)
{
IDataAdapter adapter = null;
IDbCommand command = (new CommandBuilder()).GetCommand(sqlCommand, connection, paramCollection, commandType);
switch (Configuration.DBProvider.Trim().ToUpper())
{
case Common.SQL_SERVER_DB_PROVIDER:
adapter = new SqlDataAdapter((SqlCommand)command);
break;
case Common.MY_SQL_DB_PROVIDER:
adapter = new MySqlDataAdapter((MySqlCommand)command);
break;
case Common.ORACLE_DB_PROVIDER:
adapter = new OracleDataAdapter((OracleCommand)command);
break;
case Common.ACCESS_DB_PROVIDER:
adapter = new OleDbDataAdapter((OleDbCommand)command);
break;
case Common.OLE_DB_PROVIDER:
adapter = new OleDbDataAdapter((OleDbCommand)command);
break;
case Common.ODBC_DB_PROVIDER:
adapter = new OdbcDataAdapter((OdbcCommand)command);
break;
}
return(adapter);
}
internal DataTable GetDataTable(string sqlCommand, DBParameterCollection paramCollection, IDbConnection connection, string tableName, CommandType commandType)
{
DataTable dt = null;
if (tableName != string.Empty)
{
dt = new DataTable(tableName);
}
else
{
dt = new DataTable();
}
IDbCommand command = null;
if (paramCollection != null)
{
if (paramCollection.Parameters.Count > 0)
{
command = (new CommandBuilder()).GetCommand(sqlCommand, connection, paramCollection, commandType);
}
else
{
command = (new CommandBuilder()).GetCommand(sqlCommand, connection, commandType);
}
}
else
{
command = (new CommandBuilder()).GetCommand(sqlCommand, connection, commandType);
}
switch (Configuration.DBProvider.Trim().ToUpper())
{
case Common.SQL_SERVER_DB_PROVIDER:
SqlDataAdapter sqlAdapter = null;
sqlAdapter = new SqlDataAdapter((SqlCommand)command);
try
{
sqlAdapter.Fill(dt);
}
catch (Exception ex1)
{
throw ex1;
}
finally
{
if (command != null)
{
command.Dispose();
}
if (sqlAdapter != null)
{
sqlAdapter.Dispose();
}
}
break;
case Common.MY_SQL_DB_PROVIDER:
MySqlDataAdapter mySqlAdapter = null;
mySqlAdapter = new MySqlDataAdapter((MySqlCommand)command);
try
{
mySqlAdapter.Fill(dt);
}
catch (Exception ex2)
{
throw ex2;
}
finally
{
if (command != null)
{
command.Dispose();
}
if (mySqlAdapter != null)
{
mySqlAdapter.Dispose();
}
}
break;
case Common.ORACLE_DB_PROVIDER:
OracleDataAdapter oracleAdapter = null;
oracleAdapter = new OracleDataAdapter((OracleCommand)command);
try
{
oracleAdapter.Fill(dt);
}
catch (Exception ex3)
{
throw ex3;
}
finally
{
if (command != null)
{
command.Dispose();
}
if (oracleAdapter != null)
{
oracleAdapter.Dispose();
}
}
break;
case Common.ACCESS_DB_PROVIDER:
OleDbDataAdapter oleDBAdapterAccess = null;
oleDBAdapterAccess = new OleDbDataAdapter((OleDbCommand)command);
try
{
oleDBAdapterAccess.Fill(dt);
}
catch (Exception ex4)
{
throw ex4;
}
finally
{
if (command != null)
{
command.Dispose();
}
if (oleDBAdapterAccess != null)
{
oleDBAdapterAccess.Dispose();
}
}
break;
case Common.OLE_DB_PROVIDER:
OleDbDataAdapter oleAdapter = null;
oleAdapter = new OleDbDataAdapter((OleDbCommand)command);
try
{
oleAdapter.Fill(dt);
}
catch (Exception ex4)
{
throw ex4;
}
finally
{
if (command != null)
{
command.Dispose();
}
if (oleAdapter != null)
{
oleAdapter.Dispose();
}
}
break;
case Common.ODBC_DB_PROVIDER:
OdbcDataAdapter odbcAdapter = null;
odbcAdapter = new OdbcDataAdapter((OdbcCommand)command);
try
{
odbcAdapter.Fill(dt);
}
catch (Exception ex4)
{
throw ex4;
}
finally
{
if (command != null)
{
command.Dispose();
}
if (odbcAdapter != null)
{
odbcAdapter.Dispose();
}
}
break;
}
return(dt);
}
