private void LoadDDLs() { DBLayer db = new DBLayer(); uiDropDownListSchoolYear.DataSource = db.GetAllSchoolYear(); uiDropDownListSchoolYear.DataTextField = "ArName"; uiDropDownListSchoolYear.DataValueField = "SchoolYearID"; uiDropDownListSchoolYear.DataBind(); DataSet currentYear = new DataSet(); currentYear = db.GetCurrentSchoolYear(); if (currentYear.Tables[0].Rows.Count > 0) { uiDropDownListSchoolYear.SelectedValue = currentYear.Tables[0].Rows[0]["SchoolYearID"].ToString(); } else { uiDropDownListSchoolYear.SelectedIndex = 0; } }
private void LoadDDLs() { DBLayer db = new DBLayer(); uiDropDownListClasses.DataSource = db.GetAllClass(); uiDropDownListClasses.DataTextField = "ArName"; uiDropDownListClasses.DataValueField = "ClassID"; uiDropDownListClasses.DataBind(); uiDropDownListClasses.SelectedIndex = 0; uiDropDownListClassRooms.DataSource = db.GetAllClassRoomsByClassID(Convert.ToInt32(uiDropDownListClasses.SelectedValue)); uiDropDownListClassRooms.DataTextField = "ArName"; uiDropDownListClassRooms.DataValueField = "ClassRoomID"; uiDropDownListClassRooms.DataBind(); uiDropDownListSchoolYear.DataSource = db.GetAllSchoolYear(); uiDropDownListSchoolYear.DataTextField = "ArName"; uiDropDownListSchoolYear.DataValueField = "SchoolYearID"; uiDropDownListSchoolYear.DataBind(); uiDropDownListSchoolYear.SelectedIndex = 0; }
private void BindData() { DBLayer db = new DBLayer(); DataSet ds = new DataSet(); ds = db.GetAllSchoolYear(); uiGridViewSchoolYears.DataSource = ds; uiGridViewSchoolYears.DataBind(); }