Example #1
0
        protected void PopulateAssessments()
        {
            string fiscalYear = (string)ViewState["MostRecentFiscalYear"];

            DataSet ds;
            DataSet ds2;

            if (ViewState["Assessments"] != null)
            {
                ds = (DataSet)ViewState["Assessments"];
                ds2 = (DataSet)ViewState["AssessmentMetrics"];
            }
            else
            {
                StoredProcedures sp = new StoredProcedures();

                ds = sp.GetAssessments(fiscalYear);
                ds2 = sp.GetAssessmentMetrics(fiscalYear);

                ViewState["Assessments"] = ds;
                ViewState["AssessmentMetrics"] = ds2;
            }

            FinancialAidUndergradTextBox.Text = ds.Tables[0].Rows[0][3].ToString();
            PlundFundUndergradRateTextBox.Text = ds.Tables[0].Rows[2][3].ToString();
            PriorYearProjectedUndergradTextBox.Text = ds2.Tables[0].Rows[1][2].ToString();

            FinancialAidGradTextBox.Text = ds.Tables[0].Rows[1][3].ToString();
            PlundFundGradRateTextBox.Text = ds.Tables[0].Rows[3][3].ToString();
            PriorYearProjectedGradTextBox.Text = ds2.Tables[0].Rows[0][2].ToString();
        }