protected void Page_Load(object sender, EventArgs e) { try { FilteredTextBoxExtender10.ValidChars = FilteredTextBoxExtender10.ValidChars + "\r\n"; if (Session["uid"] != null) { if (!IsPostBack) { //add form 2 Show_form2(); //end form 2 div_msg.Visible = false; txtEndDate.Text = DateTime.Now.AddYears(-12).ToString("dd/MM/yyyy"); if (!IsPostBack) { div_msg.Visible = false; try { string StrQuery2 = "select id,name from tblStatesMaster where countryId='" + 101 + "' ORDER BY name"; dbContext.BindDropDownlist(StrQuery2, ref ddl_state); ddl_city.Items.Clear(); ddl_city.Items.Insert(0, "--Select--"); string StrQueryExe = "select id,exeName from tblExecutive where status ='ACTIVE'"; dbContext.BindDropDownlist(StrQueryExe, ref ddl_ename); txt_email.Text = Session["email"].ToString(); } catch (Exception ex) { Log.Error(ex); // if condition fails then user will get following message div_msg.Visible = true; div_msg.Attributes["class"] = "alert alert-danger"; div_msg.InnerText = "Something wrong on form loading. Please Try again." + ex.Message; } } } } else { Response.Redirect("~/login.aspx", false); } } catch (Exception ex) { Log.Error(ex); } }
protected void Page_Load(object sender, EventArgs e) { GridView1.SelectedIndex = -1; if (!IsPostBack) { lbl_msg.Visible = false; BindGridView(); string StrDepartment = "select deptId, deptName from tbldepartment"; dbContext.BindDropDownlist(StrDepartment, ref ddlDepartment); dbContext.BindDropDownlist(StrDepartment, ref ddlCDepartment); string StrCourse = "select courseId, courseNumber from tblcourse"; dbContext.BindDropDownlist(StrCourse, ref ddlCourseNumber); } }
protected void Page_Load(object sender, EventArgs e) { //only first time execuite on below code if (!IsPostBack) { clear_data(); FillGrid(); try { string StrDepartment = "SELECT Distinct deptId, deptName FROM tbldepartment"; dbContext.BindDropDownlist(StrDepartment, ref ddlDepartment); string StrCourse = "SELECT Distinct courseId, courseName FROM tblcourse"; dbContext.BindDropDownlist(StrCourse, ref ddlCourseName); //string constr = ConfigurationManager.ConnectionStrings["MySql_ConnectionString"].ConnectionString; //using (MySqlConnection con = new MySqlConnection(constr)) //{ // string com = "SELECT Distinct deptId, deptName FROM tbldepartment"; // MySqlDataAdapter adpt = new MySqlDataAdapter(com, con); // DataTable dt = new DataTable(); // adpt.Fill(dt); // ddlDepartment.DataSource = dt; // ddlDepartment.SelectedValue = null; // ddlDepartment.DataBind(); // ddlDepartment.DataTextField = "deptName"; // ddlDepartment.DataValueField = "deptId"; // ddlDepartment.DataBind(); //} } catch (Exception ex) { Log.Error(ex); } } }
protected void Page_Load(object sender, EventArgs e) { try { courseId = Convert.ToInt32(Request.QueryString["id"]); string StrDepartment = "select deptId, deptName from tbldepartment"; dbContext.BindDropDownlist(StrDepartment, ref ddlDepartment); string StrCourse = "select courseId, courseNumber from tblcourse"; dbContext.BindDropDownlist(StrCourse, ref ddlCourseNumber); // dbContext.BindDropDownlist(StrCourse, ref ddlCourseStatus); string StrClassroom = "select classroomId, classroomNumber from tblclassroom"; dbContext.BindDropDownlist(StrClassroom, ref ddlClassRoom); string constr = ConfigurationManager.ConnectionStrings["MySql_ConnectionString"].ConnectionString; using (MySqlConnection con = new MySqlConnection(constr)) { string strcmd = "SELECT A.courseId, A.courseNumber, A.courseName, A.courseLevel, A.credits, B.deptName, A.status as status, A.term, A.credits, B.deptName from tblcourse as A " + "LEFT OUTER JOIN tbldepartment as B on B.deptId = A.deptId " + "WHERE A.courseId = " + courseId + " "; DataSet ds = dbContext.ExecDataSet(strcmd); if (ds.Tables[0].Rows.Count > 0) { ddlDepartment.SelectedValue = ds.Tables[0].Rows[0][5].ToString(); ddlCourseNumber.SelectedValue = ds.Tables[0].Rows[0]["courseNumber"].ToString(); txtCourseName.Text = ds.Tables[0].Rows[0]["courseName"].ToString(); ddlCourseStatus.SelectedValue = ds.Tables[0].Rows[0]["status"].ToString(); ddlCourseLevel.SelectedValue = ds.Tables[0].Rows[0]["courseLevel"].ToString(); ddlCourseCredits.SelectedValue = ds.Tables[0].Rows[0]["credits"].ToString(); ddlCourseTerm.SelectedValue = ds.Tables[0].Rows[0]["term"].ToString(); if (ds.Tables[0].Rows[0]["status"].ToString() == "1") { lblCourseStatus.Text = "Active"; btnCourseStatus.Text = "DEACTIVE"; btnCourseStatus.CssClass = "btn btn-danger btn-sm btn-block"; } else { lblCourseStatus.Text = "Deactive"; btnCourseStatus.Text = "ACTIVE"; btnCourseStatus.CssClass = "btn btn-success btn-sm btn-block"; } } //MySqlCommand cmd = new MySqlCommand(strcmd, con); //con.Open(); //MySqlDataReader dr = cmd.ExecuteReader(); //if (dr.HasRows) //{ // dr.Read(); // ddlDepartment.SelectedValue = dr["deptName"].ToString(); // ddlCourseNumber.SelectedValue = dr["courseNumber"].ToString(); //} } } catch (Exception ex) { Log.Error(ex); } }