private void BindCourse() { try { objEWA.OrgId = Session["OrgId"].ToString(); DataSet ds = objBL.BindCourses_BL(objEWA); ViewState["dvBranch"] = ds.Tables[2]; ViewState["dvClass"] = ds.Tables[3]; ddlCourse.Items.Clear(); ddlCourse.DataSource = ds.Tables[0]; ddlCourse.DataTextField = "CourseName"; ddlCourse.DataValueField = "CourseId"; ddlCourse.DataBind(); ddlCourse.Items.Insert(0, new ListItem("---Select---", "0")); DDLAcademicYear.Items.Clear(); DDLAcademicYear.DataSource = ds.Tables[7]; DDLAcademicYear.DataTextField = "AcademicYear"; DDLAcademicYear.DataValueField = "AcademicYearId"; DDLAcademicYear.DataBind(); DDLAcademicYear.Items.Insert(0, new ListItem("---Select---", "0")); ddlBranch.Items.Clear(); ddlBranch.Items.Insert(0, new ListItem("---Select---", "0")); ddlClass.Items.Clear(); ddlClass.Items.Insert(0, new ListItem("---Select---", "0")); } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
private void BindCourse() { try { EWA_Common objEWA = new EWA_Common(); BL_Common objBL = new BL_Common(); objEWA.OrgId = Session["OrgId"].ToString(); DataSet ds = objBL.BindCourses_BL(objEWA); ViewState["dvBranch"] = ds.Tables[2]; ViewState["dvClass"] = ds.Tables[3]; ViewState["dvDivision"] = ds.Tables[4]; ViewState["dvStudentData"] = ds.Tables[5]; ddlCourse.DataSource = ds.Tables[0]; ddlCourse.DataTextField = "CourseName"; ddlCourse.DataValueField = "CourseId"; ddlCourse.DataBind(); ddlCourse.Items.Insert(0, new ListItem("---Select---", "0")); ddlCasteCategory.DataSource = ds.Tables[1]; ddlCasteCategory.DataTextField = "CasteCategoryName"; ddlCasteCategory.DataValueField = "CasteCategoryId"; ddlCasteCategory.DataBind(); ddlCasteCategory.Items.Insert(0, new ListItem("---Select---", "0")); DDLAcademicYear.DataSource = ds.Tables[7]; DDLAcademicYear.DataTextField = "AcademicYear"; DDLAcademicYear.DataValueField = "AcademicYearId"; DDLAcademicYear.DataBind(); DDLAcademicYear.Items.Insert(0, new ListItem("---Select---", "0")); ddlBranch.Items.Clear(); ddlBranch.Items.Insert(0, new ListItem("---Select---", "0")); ddlClass.Items.Clear(); ddlClass.Items.Insert(0, new ListItem("---Select---", "0")); if (IsPostBack) { GrdStudent.DataSource = ds.Tables[5]; GrdStudent.DataBind(); gvPrint.DataSource = ds.Tables[5]; gvPrint.DataBind(); ViewState["PrintData"] = ds.Tables[5]; } } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
private void BindCourse() { try { EWA_Common objEWA = new EWA_Common(); BL_Common objBL = new BL_Common(); objEWA.OrgId = Session["OrgId"].ToString(); DataSet ds = objBL.BindCourses_BL(objEWA); ViewState["dvcast"] = ds.Tables[1]; ViewState["dvBranch"] = ds.Tables[2]; ViewState["dvClass"] = ds.Tables[3]; //ViewState["dvDivision"] = ds.Tables[4]; ViewState["dvStudentData"] = ds.Tables[5]; ddlCourse.DataSource = ds.Tables[0]; ddlCourse.DataTextField = "CourseName"; ddlCourse.DataValueField = "CourseId"; ddlCourse.DataBind(); ddlCourse.Items.Insert(0, new ListItem("---Select---", "0")); ddlCasteCategory.DataSource = ds.Tables[1]; ddlCasteCategory.DataTextField = "CasteCategoryName"; ddlCasteCategory.DataValueField = "CasteCategoryId"; ddlCasteCategory.DataBind(); ddlCasteCategory.Items.Insert(0, new ListItem("---Select---", "0")); DDLAcademicYear.DataSource = ds.Tables[7]; DDLAcademicYear.DataTextField = "AcademicYear"; DDLAcademicYear.DataValueField = "AcademicYearId"; DDLAcademicYear.DataBind(); DDLAcademicYear.Items.Insert(0, new ListItem("---Select---", "0")); ddlBranch.Items.Clear(); ddlBranch.Items.Insert(0, new ListItem("---Select---", "0")); ddlClass.Items.Clear(); ddlClass.Items.Insert(0, new ListItem("---Select---", "0")); ddlDivision.Items.Clear(); ddlDivision.Items.Insert(0, new ListItem("---Select---", "0")); GrdStudent.DataSource = ds.Tables[5]; GrdStudent.DataBind(); //GrdStudent.DataSource = db.Displaygrid("SELECT tblStudent.UserCode, tblAdmissionDetails.FirstName, tblAdmissionDetails.MiddleName, tblAdmissionDetails.LastName, tblCourse.CourseName, tblBranch.BranchName, tblClass.ClassName, tblAdmissionDetails.AdmissionYear FROM tblAdmissionDetails INNER JOIN tblStudent ON tblAdmissionDetails.AdmissionID = tblStudent.AdmissionId INNER JOIN tblCourse ON tblAdmissionDetails.CourseId = tblCourse.CourseId INNER JOIN tblBranch ON tblAdmissionDetails.BranchId = tblBranch.BranchId INNER JOIN tblClass ON tblAdmissionDetails.ClassId = tblClass.ClassId where tblAdmissionDetails.OrgID='" + Convert.ToInt32(Session["OrgId"]) + "'"); //GrdStudent.DataBind(); gvPrint.DataSource = ds.Tables[5]; gvPrint.DataBind(); ViewState["PrintData"] = ds.Tables[5]; } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
//Added by Ashwini 8-Oct-2020 private void BindCourse() { try { ec.OrgId = Session["OrgId"].ToString(); DataSet ds = bl.BindCourses_BL(ec); ViewState["dvBranch"] = ds.Tables[2]; ViewState["dvClass"] = ds.Tables[3]; ViewState["dvDivision"] = ds.Tables[4]; ViewState["dvStudentData"] = ds.Tables[5]; ddlCourse.Items.Clear(); ddlCourse.DataSource = ds.Tables[0]; ddlCourse.DataTextField = "CourseName"; ddlCourse.DataValueField = "CourseId"; ddlCourse.DataBind(); ddlCourse.Items.Insert(0, new ListItem("---Select---", "0")); DDLAcademicYear.Items.Clear(); DDLAcademicYear.DataSource = ds.Tables[7]; DDLAcademicYear.DataTextField = "AcademicYear"; DDLAcademicYear.DataValueField = "AcademicYearId"; DDLAcademicYear.DataBind(); DDLAcademicYear.Items.Insert(0, new ListItem("---Select---", "0")); ddlBranch.Items.Clear(); ddlBranch.Items.Insert(0, new ListItem("---Select---", "0")); ddlClass.Items.Clear(); ddlClass.Items.Insert(0, new ListItem("---Select---", "0")); } catch (Exception exp) { throw exp; } }