}
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());
学生成绩管理系统设计报告
