public DataSet LoadDataSetWithTransaction(string sqlQuery, string dataTableName)
{
con = dataBase.CreateConnection();
con.Open();
objTransaction = con.BeginTransaction();
try
{
dataSet = new DataSet();
dataBase.LoadDataSet(dataBase.GetSqlStringCommand(sqlQuery), dataSet, dataTableName, objTransaction);
objTransaction.Commit();
return(dataSet);
}
catch (Exception ex)
{
objTransaction.Rollback();
throw ex;
}
finally
{
con.Close();
}
}
