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