学生成绩管理系统课程设计源程序.doc

关于About.cs using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Reflection; namespace 学生成绩管理系统 { public partial class About : Form { public About() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { this.Close(); } private void About_Load(object sender, EventArgs e) { } } } 添加课程信息AddCourse.cs using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using MySql.Data.MySqlClient; namespace 学生成绩管理系统 { public partial class AddCourse : Form { public AddCourse() { InitializeComponent(); } private void btnExit_Click(object sender, EventArgs e) { this.Close(); } private void btnAddCourse_Click(object sender, EventArgs e) { string myConnectionString = Database=student;Data Source=localhost;User Id=root;Password=k6smile20xq; MySqlConnection mycn = new MySqlConnection(myConnectionString); mycn.Open(); string sql; Course course = new Course(); course.Cno = txtCno.Text; course.Cname = txtCname.Text; try { sql = select count(*) from course where cno= + txtCno.Text + ; MySqlCommand mycm = new MySqlCommand(sql, mycn); MySqlDataReader msdr = mycm.ExecuteReader(); msdr.Read(); int stuCount = msdr.GetInt32(count(*)); msdr.Close(); if (stuCount == 0 txtCname.Text != txtCno.Text != ) { sql = insert into course(cno