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(); } }