public void LoadQuotas() { Database data = new Database(); SqlDataReader reader = data.GetQuotaFunnel(EmployeeID, ReportMonth); if (reader.Read()) { RMRQuota = DataUtility.RetrieveDecimal(reader, "mnyRMRQuota", 0.0m); RMRFunnel = DataUtility.RetrieveDecimal(reader, "mnyRMRFunnel", 0.0m); RSSQuota = DataUtility.RetrieveDecimal(reader, "mnyRSSQuota", 0.0m); RSSFunnel = DataUtility.RetrieveDecimal(reader, "mnyRSSFunnel", 0.0m); tblQuotaFunnels.Rows[1].Cells[0].Text = RMRQuota.ToString("C"); tblQuotaFunnels.Rows[1].Cells[1].Text = RMRFunnel.ToString("C"); tblQuotaFunnels.Rows[1].Cells[2].Text = RSSQuota.ToString("C"); tblQuotaFunnels.Rows[1].Cells[3].Text = RSSFunnel.ToString("C"); } data.Close(); data.Dispose(); }