private void teacherManagertoolStripButton_Click(object sender, EventArgs e)
{
this.Close();
Form_adminTeacherManager a = new Form_adminTeacherManager();
a.Show();
}
private void btn_close_Click(object sender, EventArgs e)
{
this.Close();
Form_adminTeacherManager a = new Form_adminTeacherManager();
a.Show();
}
private void btn_change_Click(object sender, EventArgs e)
{
try
{
if (RB1.Checked)
{
sex = RB1.Text; //取性别值
}
else
{
sex = RB2.Text;
}
string strCon = "server=127.0.0.1;uid=sa;pwd=123456;database=ClassAttendanceManageSystem";
SqlConnection myconn = new SqlConnection(strCon);
DataSet myDataSet = new DataSet();
string strcom = "Select *from teacherInfo";
string str = "UPDATE teacherInfo SET teacherName='" + textBox2.Text.Trim() + "',teacherSex='" + sex.Trim() + "',courseID='" + textBox3.Text.Trim() + "',teacherPassword='******'where teacherID='" + Form_adminTeacherManager.teacherID + "'";
myconn.Open();
SqlCommand xg;
xg = new SqlCommand(str, myconn);
if (xg.ExecuteNonQuery() > 0) //判断插入数据是否成功
{ //执行要操作的语句
SqlDataAdapter mycommand = new SqlDataAdapter(strcom, myconn);
myDataSet.Clear();
mycommand.Fill(myDataSet, "teacherInfo");
//adminMain.dataGridView1.DataSource = myDataSet.Tables["systemStudent"];
MessageBox.Show("修改成功", "提示");
Close();
Form_adminTeacherManager a = new Form_adminTeacherManager();
a.ShowDialog();
}
myconn.Close();
}
catch (Exception x)
{
MessageBox.Show("error!" + x.ToString());
}
}
