/// <summary> ///Set Division Table in Viewstate /// </summary> private void SetDivisionTableInViewState() { SYS_BMSBLogic = new SYS_BMS_BLogic(); DataSet dsDivision = new DataSet(); dsDivision = SYS_BMSBLogic.BAL_SYS_BMS_FillDivisionBySchoolBMSID(AppSessions.SchoolID); ViewState["DivisionTable"] = dsDivision.Tables[0]; }
/// <summary> /// Set Division Value in ZZ column of excel sheet. /// </summary> private static void SetDivValue(Worksheet xlsWorksheet) { SYS_BMS_BLogic BSysBMS = new SYS_BMS_BLogic(); DataSet dsDivision = new DataSet(); dsDivision = BSysBMS.BAL_SYS_BMS_FillDivisionBySchoolBMSID(AppSessions.SchoolID); if (dsDivision.Tables[0].Rows.Count > 0) { int i = 1; foreach (DataRow oDr in dsDivision.Tables[0].Rows) { xlsWorksheet.Range["ZZ" + i + ""].Value = Convert.ToString(oDr["Division"]); i++; } } SeDivisionDropDown(xlsWorksheet, dsDivision.Tables[0].Rows.Count); }