protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable avgSchoolScore;
DataTable avgSubjectsScore;
DataTable avgClassesScore;
eRegisterData.DAL oDal = new eRegisterData.DAL();
avgSchoolScore = oDal.AvgSchoolScore(SchoolID, Int16.Parse(DropDownList1.SelectedItem.Value));
txtSchoolName.Text = avgSchoolScore.Rows[0][0].ToString();
txtAvgSchoolScore.Text = avgSchoolScore.Rows[0][1].ToString();
avgSubjectsScore = oDal.AvgSubjectYearScore(SchoolID, Int16.Parse(DropDownList1.SelectedItem.Value));
GridViewAvgsubjectScore.DataSource = avgSubjectsScore.DefaultView;
GridViewAvgsubjectScore.DataBind();
avgClassesScore = oDal.AvgClassesScore(SchoolID, Int16.Parse(DropDownList1.SelectedItem.Value));
GridViewAvgClassScore.DataSource = avgClassesScore.DefaultView;
GridViewAvgClassScore.DataBind();
}
protected void GridViewAvgsubjectScore_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridViewAvgsubjectScore.PageIndex = e.NewPageIndex;
GridViewAvgsubjectScore.DataBind();
}