private void RefreshBookingFinancialTransactions() { BookingSearchService bookingFinancialTransactions = new BookingSearchService(); BindingSource bindingSource = new BindingSource(); try { bindingSource.DataSource = bookingFinancialTransactions.BookingFinancialTransactions( _bookingContract.Booking.BookingId ); dataGridViewBookingFinancialTransactions.AutoGenerateColumns = true; dataGridViewBookingFinancialTransactions.DataSource = bindingSource; dataGridViewBookingFinancialTransactions.AutoResizeColumns(); // select last (totals) row dataGridViewBookingFinancialTransactions.Rows[0].Selected = false; dataGridViewBookingFinancialTransactions.Rows[dataGridViewBookingFinancialTransactions.Rows.Count - 1].Selected = true; dataGridViewBookingFinancialTransactions.Refresh(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { bookingFinancialTransactions.Close(); } }