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();
}
