private DataTable BindGridView(string strcmd) { try { //create a dataset object and fill it DataSet ds = dbContext.ExecDataSet(strcmd); int row_count = ds.Tables[0].Rows.Count; lbl_rowcount.Text = "Total - " + row_count.ToString(); return(ds.Tables[0]); } catch (Exception ex) { Log.Error("" + ex); lbl_msg.Visible = true; lbl_msg.Text = "Something went wrong. Please try again......"; return(null); } }
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); } }