// Load dataset public void LoadDataGuest() { // Fetch dataset DataSet guestDS = DBGetData.GetGuestDGVAll(); if (guestDS != null) { // No tables fetched if (guestDS.Tables.Count == 0) { new StatusMessage("No datatable found, contact administrator."); return; } // No rows fetched else if (guestDS.Tables[0].Rows.Count == 0) { new StatusMessage("No datarows found for this month."); return; } // Clear labelStatus for previous messages else { new StatusMessage(""); } // Set the dataset as source for datagridview and make sure its displayed dataGridViewGuest.DataSource = guestDS; dataGridViewGuest.DataMember = "Get_Guest_All"; LoadDataGridViewGuest(); } }