var query = from att in _dataEntities.Attendance
                                  from usr in _dataEntities.Users
                                  where usr.Id == att.UserID
                                  select new
                                  {
                                      AttendanceId = att.ID,
                                      UserId = usr.Id, 
                                      Name = usr.Name,
                                      Date = att.Date,
                                      Payment = att.Payment
                                  };

...

dataGridView.AutoGenerateColumns = false;
dataGridView.DataSource = query;

...

// или через BindingSource:
bindingSourceAttendance.DataSource = query;