1、教師管理操作流程使用Teacher賬號登陸教師管理系統代碼區域：if (loginType = 教師) string sql = string.Format(select count(*) from teacher where LoginId=0 AND LoginPwd=1, loginId, loginPwd); try SqlCommand command = new SqlCommand(sql, DBHelper.connection); DBHelper.connection.Open(); count = (int)command.ExecuteScalar(); if (cou

2、nt = 1) isValidUser = true; else index+; if (index = 3) Application.Exit(); isValidUser = false; catch (Exception ex) message = ex.Message; Console.WriteLine(ex.Message); 查詢修改信息查詢教師基本信息(代碼區域：) TeacherBaseForm teacherBaseForm = new TeacherBaseForm(); teacherBaseForm.Show();TeacherBaseForm（教師基本信息窗體）查詢

3、及修改學生信息(代碼區域：) UpdateStudentForm updateStudentForm = new UpdateStudentForm(); updateStudentForm.Show();SearchTeacherForm.cs（查詢及修改信息窗體）AddScoreForm（學生成績錄入窗體）錄入按鈕代碼：string sql = string.Format(select StudentId,StudentNo,StudentName from Student where StudentId=0, txtId.Text); try SqlCommand command = n

4、ew SqlCommand(sql, DBHelper.connection); DBHelper.connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read() id = (int)readerStudentId; no = (string)readerStudentNo; name = (string)readerStudentName; reader.Close(); catch (Exception ex) MessageBox.Show(ex.Message); final

5、ly DBHelper.connection.Close(); if (TianJia() if (txtId.Text = Convert.ToString(id) & txtStudentNo.Text = no & txtStudentName.Text = name) string studentName = txtStudentName.Text; string sdudentNo = txtStudentNo.Text; string subject = cboSubject.Text; string score = txtScore.Text; int classId = Get

6、ClassId(); string studentId = txtId.Text; string sql1 = string.Format(insert into Score(StudentNo,Subject,SScore,SName,ClassId,StudentId)values(0,1,2,3,4,5), sdudentNo, subject, score, studentName, classId, studentId); try SqlCommand command = new SqlCommand(sql1, DBHelper.connection); DBHelper.conn

7、ection.Open(); int result = command.ExecuteNonQuery(); if (result != 1) MessageBox.Show(添加失敗, 輸入提示, MessageBoxButtons.OK, MessageBoxIcon.Information); else MessageBox.Show(添加成功, 輸入提示, MessageBoxButtons.OK, MessageBoxIcon.Information); catch (Exception ex) /MessageBox.Show(操作數據庫出錯！, 輸入提示, MessageBoxB

8、uttons.OK, MessageBoxIcon.Information); /Console.WriteLine(ex.Message); MessageBox.Show(ex.Message); finally DBHelper.connection.Close(); else MessageBox.Show(您輸入的學生在數據庫中沒有，請重新輸入, 輸入提示, MessageBoxButtons.OK, MessageBoxIcon.Information); private void AddScoreForm_Load(object sender, EventArgs e) stri

9、ng sql = select gradeName from Grade; try SqlCommand command = new SqlCommand(sql, DBHelper.connection); DBHelper.connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read() string gradeName = (string)reader0; cboGrade.Items.Add(gradeName); reader.Close(); catch (Exceptio

10、n ex) MessageBox.Show(ex.Message); finally DBHelper.connection.Close(); string sql1 = select SubjectName from Subject; try SqlCommand command = new SqlCommand(sql1, DBHelper.connection); DBHelper.connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read() string subName =

11、 (string)reader0; cboSubject.Items.Add(subName); reader.Close(); catch (Exception ex) MessageBox.Show(ex.Message); finally DBHelper.connection.Close(); private void cboGrade_SelectedIndexChanged(object sender, EventArgs e) if (cboGrade.Text.Trim() != ) int gradeId = -1; string sql = string.Format(se

12、lect GradeId from Grade where GradeName=0, cboGrade.Text); SqlCommand command = new SqlCommand(sql, DBHelper.connection); try DBHelper.connection.Open(); SqlDataReader reader = command.ExecuteReader(); if (reader.Read() gradeId = (int)reader0; reader.Close(); catch (Exception ex) MessageBox.Show(操作數

13、據庫出錯); Console.WriteLine(ex.Message); finally DBHelper.connection.Close(); sql = SELECT ClassName FROM Class WHERE GradeId= + gradeId; command.CommandText = sql; try DBHelper.connection.Open(); SqlDataReader reader = command.ExecuteReader(); string className = ; cboClass.Items.Clear(); while (reader

14、.Read() className = (string)readerClassName; cboClass.Items.Add(className); reader.Close(); catch (Exception ex) MessageBox.Show(操作數據庫出錯); Console.WriteLine(ex.Message); finally DBHelper.connection.Close(); private void txtId_TextChanged(object sender, EventArgs e) UpdateScoreForm（更新成績窗體）保存按鈕代碼：DialogResult result = MessageBox.Show(確實要將修改保存到數據庫嗎？, 輸入提示, MessageBoxButtons.OK, MessageBoxIcon.Information); if (result = DialogResult.OK) SqlCommandBuilder builder = new S