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); ddlCourse.DataSource = ds; ddlCourse.DataTextField = "CourseName"; ddlCourse.DataValueField = "CourseId"; ddlCourse.DataBind(); ddlCourse.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "0")); ddlBranch.Items.Clear(); ddlClass.Items.Clear(); ddlBranch.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "0")); ddlClass.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "0")); } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
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()); } }
public void BindStudentList(string rblStatus) { EWA_Common objEWA = new EWA_Common(); BL_Common objBL = new BL_Common(); objEWA.OrgId = Session["OrgId"].ToString(); DataSet ds = objBL.BindCourses_BL(objEWA); ViewState["dvStudentData"] = ds.Tables[6]; dvStudentData = new DataView(ViewState["dvStudentData"] as DataTable); dvStudentData.RowFilter = "[Status] = '" + rblStatus + "'"; GrdStudent.DataSource = dvStudentData; GrdStudent.DataBind(); gvPrint.DataSource = dvStudentData; gvPrint.DataBind(); }
// Biding Methods #region Biding Comman Methods private void BindCourse(int OrgID) { try { objEWA.OrgId = Convert.ToString(OrgID); DataSet ds = objBL.BindCourses_BL(objEWA); ddlCourses.DataSource = ds; ddlCourses.DataTextField = "CourseName"; ddlCourses.DataValueField = "CourseId"; ddlCourses.DataBind(); ddlCourses.Items.Insert(0, "Select"); } 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 = DDL_SelectCollege.SelectedValue; DataSet ds = objBL.BindCourses_BL(objEWA); ddlCourse.DataSource = ds; ddlCourse.DataTextField = "CourseName"; ddlCourse.DataValueField = "CourseId"; ddlCourse.DataBind(); ddlCourse.Items.Insert(0, new ListItem("Select", "0")); } catch (Exception exp) { } }
//Bind Course #region 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); ddlCourse.DataSource = ds; ddlCourse.DataTextField = "CourseName"; ddlCourse.DataValueField = "CourseId"; ddlCourse.DataBind(); ddlCourse.Items.Insert(0, "Select"); } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
//Bind Course #region [Bind Courses] private void BindCourse(int OrgID) { try { EWA_Common objEWA = new EWA_Common(); BL_Common objBL = new BL_Common(); //Pass from Session objEWA.OrgId = Convert.ToString(OrgID); DataSet ds = objBL.BindCourses_BL(objEWA); ddlCourses.DataSource = ds; ddlCourses.DataTextField = "CourseName"; ddlCourses.DataValueField = "CourseId"; ddlCourses.DataBind(); ddlCourses.Items.Insert(0, new ListItem("Select", "0")); } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
//Bind Drop Down #region [Bind Drop Down] protected void BindDropDownData(int orgID) { try { BL_Common objBL = new BL_Common(); EWA_Common objEWA = new EWA_Common(); objEWA.OrgId = Convert.ToString(orgID); ds = objBL.BindCourses_BL(objEWA); ddl_Course.DataSource = ds; ddl_Course.DataTextField = "CourseName"; ddl_Course.DataValueField = "CourseId"; ddl_Course.DataBind(); ddl_Course.Items.Insert(0, "Select"); } 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["dvStudentData"] = ds.Tables[6]; ddlCourse.DataSource = ds.Tables[0]; ddlCourse.DataTextField = "CourseName"; ddlCourse.DataValueField = "CourseId"; ddlCourse.DataBind(); ddlCourse.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")); //GrdStudent.DataSource = ds.Tables[6]; //GrdStudent.DataBind(); //gvPrint.DataSource = ds.Tables[6]; //gvPrint.DataBind(); //ViewState["PrintData"] = ds.Tables[6]; //ViewState["dvStudentData_Completed"] = ds.Tables[8]; } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
private void BindStudent() { 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["dvStudentData"] = ds.Tables[5]; 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()); } }
//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; } }
//Page Load #region [Page Load] protected void Page_Load(object sender, EventArgs e) { try { int orgId = Convert.ToInt32(Session["OrgID"]); if (orgId == 0) { Response.Redirect("~/CMSHome.aspx"); } if (!IsPostBack) { EWA_Common ObjEWA = new EWA_Common(); BL_Common ObjBL = new BL_Common(); //Session OrgId; ObjEWA.OrgId = Session["OrgId"].ToString(); DataSet ds = ObjBL.BindCourses_BL(ObjEWA); // ObjEWA.CourseId = ObjEWA.CourseId; ddlCourse.DataSource = ds; ddlCourse.DataTextField = "CourseName"; ddlCourse.DataValueField = "CourseId"; ddlCourse.DataBind(); ddlCourse.Items.Insert(0, new ListItem("Select", "Select")); //Session OrgId; ObjEWA.OrgId = Session["OrgId"].ToString(); //DataSet ds1 = ObjBL.BindCasteCategory_BL(ObjEWA); Bind_ddlFeesCategory(); //cn.Open(); //SqlCommand cmd1 = new SqlCommand("SELECT CourseId,CourseName FROM tblCourse WHERE OrgId='" + ddlCourse.SelectedValue + "'", cn); //SqlDataReader dr1 = cmd1.ExecuteReader(); //ddlCourse.DataSource = dr1; //ddlCourse.Items.Clear(); //ddlCourse.DataTextField = "CourseName"; //ddlCourse.DataValueField = "CourseId"; //ddlCourse.DataBind(); //cn.Close(); //ddlCourse.Items.Insert(0, new ListItem("--Please Select Course--", "0")); // cn.Open(); // SqlCommand cmd = new SqlCommand("SELECT CasteCategoryId,CasteCategoryName FROM tblCasteCategory where OrgId='" + orgId.ToString() + "'", cn); // SqlDataReader dr = cmd.ExecuteReader(); // ddlCastCategory.DataSource = dr; //// ddlCastCategory.DataSource = ds1; // ddlCastCategory.DataTextField = "CasteCategoryName"; // ddlCastCategory.DataValueField = "CasteCategoryId"; // ddlCastCategory.DataBind(); // ddlCastCategory.Items.Insert(0, "Select"); // dr.Close(); BindGridView("Empty"); lblresult.Text = ""; } } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }