private void PopulateGridView() { String fiscalYear = (String)Session["FiscalYear"]; StoredProcedures sp = new StoredProcedures(); TextBox tb = new TextBox(); DataSet ds = sp.GetExpenduters(fiscalYear); MiscellaneousExpensesGridView.DataSource = ds.Tables[3]; MiscellaneousExpensesGridView.DataBind(); if (ds.Tables[0].Rows.Count == 0) { Session["ChreckExpenduters"] = false; InstractionalCompensationPanel.Visible = false; InfoPanel.Visible = true; BenefitsRateLink.Visible = false; SaveButton.Visible = false; } else { Session["ChreckExpenduters"] = true; InfoPanel.Visible = false; InstractionalCompensationPanel.Visible = true; BenefitsRateLink.Visible = true; SaveButton.Visible = true; DisplayTotals(fiscalYear); InstractionalCompensationGridView.DataSource = ds.Tables[0]; InstractionalCompensationGridView.DataBind(); NonInstractionalCompensationGridView.DataSource = ds.Tables[1]; NonInstractionalCompensationGridView.DataBind(); NonCompensationGridView.DataSource = ds.Tables[2]; NonCompensationGridView.DataBind(); for (int row = 0; row < InstractionalCompensationGridView.Rows.Count; row++) { tb = (TextBox)InstractionalCompensationGridView.Rows[row].FindControl("BudgetTextBox"); tb.Text = ds.Tables[0].Rows[row][3].ToString(); if (ds.Tables[0].Rows[row][4].ToString() != "") { double rate = double.Parse(ds.Tables[0].Rows[row][4].ToString()) * 100; tb = (TextBox)InstractionalCompensationGridView.Rows[row].FindControl("FringeBenefitRateTextBox"); tb.Text = ds.Tables[0].Rows[row][4].ToString(); rate.ToString(); } } for (int row = 0; row < NonInstractionalCompensationGridView.Rows.Count; row++) { tb = (TextBox)NonInstractionalCompensationGridView.Rows[row].FindControl("BudgetTextBox"); tb.Text = ds.Tables[1].Rows[row][3].ToString(); if (ds.Tables[1].Rows[row][4].ToString() != "") { double rate = double.Parse(ds.Tables[1].Rows[row][4].ToString()) * 100; tb = (TextBox)NonInstractionalCompensationGridView.Rows[row].FindControl("FringeBenefitRateTextBox"); tb.Text = rate.ToString(); } } for (int row = 0; row < NonCompensationGridView.Rows.Count; row++) { tb = (TextBox)NonCompensationGridView.Rows[row].FindControl("BudgetTextBox"); tb.Text = ds.Tables[2].Rows[row][3].ToString(); } } for (int row = 0; row < MiscellaneousExpensesGridView.Rows.Count; row++) { tb = (TextBox)MiscellaneousExpensesGridView.Rows[row].FindControl("BudgetTextBox"); tb.Text = ds.Tables[3].Rows[row][3].ToString(); } }
private void PopulateMiscellaneous() { String fiscalYear = (String)Session["FiscalYear"]; StoredProcedures sp = new StoredProcedures(); TextBox tb = new TextBox(); DataSet ds = sp.GetExpenduters(fiscalYear); MiscellaneousExpensesGridView.DataSource = ds.Tables[3]; MiscellaneousExpensesGridView.DataBind(); for (int row = 0; row < MiscellaneousExpensesGridView.Rows.Count; row++) { tb = (TextBox)MiscellaneousExpensesGridView.Rows[row].FindControl("BudgetTextBox"); tb.Text = ds.Tables[3].Rows[row][3].ToString(); } }
protected void PopulateExpendatures() { string fiscalYear = (string)ViewState["MostRecentFiscalYear"]; DataSet ds = new DataSet(); if (ViewState["Expendatures"] != null) { ds = (DataSet)ViewState["Expendatures"]; } else { StoredProcedures sp = new StoredProcedures(); ds = sp.GetExpenduters(fiscalYear); ViewState["Expendatures"] = ds; } DataTable dt = new DataTable(); if ( RadioButtonList1.SelectedIndex == 0 ) { dt = ds.Tables[0]; AddedExpendaturesGridView.Columns[2].Visible = true; } else if (RadioButtonList1.SelectedIndex == 1) { dt = ds.Tables[1]; AddedExpendaturesGridView.Columns[2].Visible = true; } else if (RadioButtonList1.SelectedIndex == 2) { dt = ds.Tables[2]; AddedExpendaturesGridView.Columns[2].Visible = false; } else { dt = ds.Tables[3]; AddedExpendaturesGridView.Columns[2].Visible = false; } AddedExpendaturesGridView.DataSource = dt; AddedExpendaturesGridView.DataBind(); }