// Load dataset to datagridview public void LoadDataHousekeeping() { // Fetch dataset DataSet housekeepingDS = DBGetData.GetHousekeepingDGVActive(); if (housekeepingDS != null) { // No tables fetched if (housekeepingDS.Tables.Count == 0) { new StatusMessage("No datatable found, contact administrator."); return; } // No rows fetched else if (housekeepingDS.Tables[0].Rows.Count == 0) { new StatusMessage("No datarows found in housekeeping."); return; } // Clear labelStatus for previous messages else { new StatusMessage(""); } // Set the dataset as source for datagridview and make sure its displayed dataGridViewHousekeeping.DataSource = housekeepingDS; dataGridViewHousekeeping.DataMember = "Get_Housekeeping_Active"; LoadDataGridViewHousekeeping(); } }