private void PopulateGridView()
{
String fiscalYear = (String)Session["FiscalYear"];
RetrieveFromDB rtrvDB = new RetrieveFromDB();
DataSet ds = rtrvDB.DisplayCompensation(fiscalYear, "Instractional");
DataSet ds2 = rtrvDB.DisplayCompensation(fiscalYear, "NonInstractional");
DataSet ds3 = rtrvDB.DisplayNonCompensationExpenses(fiscalYear);
InstractionalCompensationGridView.DataSource = ds;
InstractionalCompensationGridView.DataBind();
NonInstractionalCompensationGridView.DataSource = ds2;
NonInstractionalCompensationGridView.DataBind();
NonCompensationGridView.DataSource = ds3;
NonCompensationGridView.DataBind();
TextBox tb = new TextBox();
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 = ds2.Tables[0].Rows[row][3].ToString();
if (ds2.Tables[0].Rows[row][4].ToString() != "")
{
double rate = double.Parse(ds2.Tables[0].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 = ds3.Tables[0].Rows[row][3].ToString();
}
}
