学生成绩管理系统设计报告

}

private void 成绩查询ToolStripMenuItem1_Click(object sender, EventArgs e) {

Form_scoresel f6 = new Form_scoresel(); f6.Show();

}

private void 密码修改ToolStripMenuItem_Click(object sender, EventArgs e) {

Form_pwd pwd = new Form_pwd(); pwd.MdiParent = this; pwd.Show(); }

private void 重新登录ToolStripMenuItem_Click(object sender, EventArgs e) {

Login f1 = new Login(); this.Close(); f1.Show(); }

private void 数据库备份ToolStripMenuItem_Click(object sender, EventArgs e) {

string path = @\何坤\\DB备份\\student.bak\;

string backupstr = \+path+\; DBHelp DBHelp=new DBHelp ();

SqlConnection con=new SqlConnection (DBHelp.constr); SqlCommand com=new SqlCommand (backupstr,con); try {

con.Open();

com.ExecuteNonQuery(); MessageBox.Show(\备份成功\); } catch {

MessageBox.Show(\备份失败\); } finally

{

con.Close(); } }

private void 数据库恢复ToolStripMenuItem_Click(object sender, EventArgs e) {

string path = @\何坤\\DB备份\\student.bak\;

string restorestr = \ + path + \; DBHelp DBHelp = new DBHelp();

SqlConnection con = new SqlConnection(DBHelp.constr); SqlCommand com = new SqlCommand(restorestr, con); try {

con.Open();

com.ExecuteNonQuery(); MessageBox.Show(\恢复成功\); } catch {

MessageBox.Show(\恢复失败\); }

finally {

con.Close(); } }

private void 窗体层叠ToolStripMenuItem_Click(object sender, EventArgs e) {

this.LayoutMdi(MdiLayout.Cascade); }

private void 水平平铺ToolStripMenuItem_Click(object sender, EventArgs e) {

this.LayoutMdi(MdiLayout.TileHorizontal); }

private void 垂直平铺ToolStripMenuItem_Click(object sender, EventArgs e) {

this.LayoutMdi(MdiLayout.TileVertical); }

private void 教师信息查询ToolStripMenuItem_Click(object sender, EventArgs e) {

Teachersel teasel= new Teachersel(); teasel.MdiParent = this; teasel.Show(); }

private void 教师信息操作ToolStripMenuItem_Click(object sender, EventArgs e) {

Teacher tea = new Teacher(); tea.MdiParent = this; tea.Show(); }

private void 学生信息查询ToolStripMenuItem_Click(object sender, EventArgs e) {

Stusel stusel = new Stusel(); stusel.MdiParent = this; stusel.Show(); }

private void 学生信息操做ToolStripMenuItem_Click(object sender, EventArgs e) {

Student stu = new Student(); stu.MdiParent = this; stu.Show(); }

private void 统计个人成绩ToolStripMenuItem_Click(object sender, EventArgs e) {

tongji t = new tongji(); t.MdiParent = this; t.Show(); }

private void 专业信息查询ToolStripMenuItem_Click(object sender, EventArgs e) {

Specialty_sel s = new Specialty_sel(); s.MdiParent=this; s.Show(); }

private void 课程表查询ToolStripMenuItem_Click(object sender, EventArgs e)

{

Coursetablesel table = new Coursetablesel(); table.MdiParent = this; table.Show(); }

private void 课程表操作ToolStripMenuItem_Click(object sender, EventArgs e) {

Coursetable ta = new Coursetable(); ta.MdiParent = this; ta.Show(); }

private void 课程管理ToolStripMenuItem1_Click(object sender, EventArgs e) {

Form_Coursesel f=new Form_Coursesel(); f.MdiParent = this; f.Show();

}

private void 课程信息操作ToolStripMenuItem_Click(object sender, EventArgs e) {

Form_Course C = new Form_Course(); C.MdiParent = this; C.Show(); }

private void 班级查询ToolStripMenuItem_Click(object sender, EventArgs e) {

Classsel s = new Classsel(); s.MdiParent = this; s.Show(); }

private void 班级信息操作ToolStripMenuItem_Click(object sender, EventArgs e) {

Class c = new Class(); c.MdiParent = this; c.Show(); }

private void 专业信息操作ToolStripMenuItem_Click(object sender, EventArgs e) {

Specialty sa = new Specialty(); sa.MdiParent=this; sa.Show(); } } }

Class.cs

private void Class_Load(object sender, EventArgs e) { try {

DBHelp DBhelp = new DBHelp();

SqlConnection con = new SqlConnection(DBhelp.constr); string sql = \; SqlDataAdapter sda = new SqlDataAdapter(sql, con); DataSet ds = new DataSet(); sda.Fill(ds, \);

foreach (DataRow aRow in ds.Tables[0].Rows) {

comboBox1.Items.Add(aRow[0].ToString().Trim()); comboBox2.Items.Add(aRow[0].ToString().Trim());