private void InitClassInfo() { if (this.Tag != null) { TagObject tagObject = (TagObject)this.Tag; classId = tagObject.EditId; reload = tagObject.ReLoad; //赋值 //int.TryParse(this.Tag.ToString(), out stuId); } //查询数据 string sql = "select ClassName,GradeId,Remark from ClassInfo" + " where ClassId=@ClassId"; SqlParameter paraId = new SqlParameter("@ClassId", classId); SqlDataReader dr = SqlHelper.ExecuteReader(sql, paraId); //读取数据 只向前,不后退,读一条 丢一条 if (dr.Read()) { txtClassName.Text = dr["ClassName"].ToString(); oldName = txtClassName.Text.Trim(); txtRemark.Text = dr["Remark"].ToString(); int gradeId = (int)dr["GradeId"]; oldGradeId = gradeId; cboGrade.SelectedValue = gradeId; } dr.Close(); }
private void InitStuInfo() { //获取StuId if (this.Tag != null) { TagObject tagObject = (TagObject)this.Tag; stuId = tagObject.EditId; reLoad = tagObject.ReLoad; //赋值 //int.TryParse(this.Tag.ToString(), out stuId); } //查询数据 string sql = "select StudentName,Sex,ClassId,Phone from StudentInfo" + " where Studentid = @StudentId"; SqlParameter paraId = new SqlParameter("@StudentId", stuId); SqlDataReader dr = SqlHelper.ExecuteReader(sql, paraId); //读取数据 只向前,不后退,读一条 丢一条 if (dr.Read()) { txtName.Text = dr["StudentName"].ToString(); txtPhone.Text = dr["Phone"].ToString(); string sex = dr["Sex"].ToString(); if (sex == "Male") { rbM.Checked = true; } else { rbF.Checked = true; } int classId = (int)dr["ClassId"]; cboClass.SelectedValue = classId; } dr.Close(); }
private void InitStuInfo() { //获取到StudentId; if (this.Tag != null) { TagObject tagObject = (TagObject)this.Tag; stuId = tagObject.EditId; reLoad = tagObject.Reload; } //查询数据 string sql = "select StudentName,Sex,ClassId,Phone from StudentInfo where StudentId=@StudentId"; SqlParameter paraId = new SqlParameter("@StudentId", stuId); SqlDataReader dr = SqlHelper.ExecuteReader(sql, paraId); //读取数据,dr为一行,逐行往后读,边读边写 if (dr.Read()) { txtStuName.Text = dr["StudentName"].ToString(); txtPhone.Text = dr["Phone"].ToString(); string sex = dr["Sex"].ToString(); if (sex == "男") { rbtMale.Checked = true; } else { rbtFemale.Checked = true; } int classId = (int)dr["ClassId"]; cboClasses.SelectedValue = classId; } dr.Close(); }
private void InitClassInfo() { if (this.Tag != null) { TagObject tagObject = (TagObject)this.Tag; classId = tagObject.EditId; reLoad = tagObject.Reload; } string sql = "select ClassName,GradeId,Remark from ClassInfo where ClassId=@ClassId"; SqlParameter paraId = new SqlParameter("@ClassId", classId); SqlDataReader dr = SqlHelper.ExecuteReader(sql, paraId); if (dr.Read()) { txtClassName.Text = dr["ClassName"].ToString(); txtRemark.Text = dr["Remark"].ToString(); int gradeId = (int)dr["GradeId"]; cboGrades.SelectedValue = gradeId; } dr.Close(); }