public SqlDataReader executeQuery(string sql)
{
    SqlCommand command = this.connection.CreateCommand();
    command.CommandText = sql;
    command.CommandType = CommandType.Text;
    if (this.trans.getSqlTrans() != null)
    {
        command.Transaction = this.trans.getSqlTrans();
    }
    return command.ExecuteReader();
}