C#程序設(shè)計(jì)課程設(shè)計(jì)報(bào)告（2010 2011學(xué)年 第 2 學(xué)期）題 目： 專 業(yè)： 班 級(jí)： 姓名學(xué)號(hào)： 指導(dǎo)教師： 成 績(jī)： 計(jì)算機(jī)科學(xué)與技術(shù)系年月日C#學(xué)生成績(jī)管理系統(tǒng)一、設(shè)計(jì)目的1、掌握簡(jiǎn)單WinForm應(yīng)用程序的設(shè)計(jì)2、ADO.net的應(yīng)用。3、使用C#語言解決實(shí)際問題的能力二、設(shè)計(jì)內(nèi)容1、基本要求 （1）根據(jù)查詢條件實(shí)現(xiàn)學(xué)生信息的查詢。 （2）學(xué)生選課信息查詢、成績(jī)信息的查詢。 （3）學(xué)生信息、課程信息、成績(jī)信息的增加、刪除、修改。 （4）對(duì)基本信息完成增加、刪除、修改時(shí)，需注意表與表之間的關(guān)聯(lián)三、軟件設(shè)計(jì)過程 一、按照任務(wù)書寫表格1、 課程表2、 學(xué)生表3、 成績(jī)表另外添加了一張用戶登陸表2、 軟件功能介紹1、登陸界面 點(diǎn)擊登陸后進(jìn)入主界面，點(diǎn)擊退出即退出系統(tǒng)2、 主界面主界面有四個(gè)按鈕，分別是：學(xué)生信息查尋、學(xué)生信息修改、學(xué)生成績(jī)錄入和退出。前三個(gè)進(jìn)入相應(yīng)的功能界面，退出則是退出系統(tǒng)。3、 學(xué)生信息查詢界面進(jìn)入學(xué)生信息查尋界面?？梢园凑招彰W(xué)號(hào)和專業(yè)進(jìn)行查尋。按專業(yè)查詢：按姓名查詢：按學(xué)號(hào)查詢：點(diǎn)擊會(huì)顯示所選行學(xué)生的成績(jī) 以學(xué)號(hào)061101王林為例：返回鍵返回主菜單4、學(xué)生信息修改界面點(diǎn)擊任意一行，會(huì)將相應(yīng)學(xué)生的信息顯示在分別顯示在相應(yīng)的空格里，如圖：對(duì)其作出修改點(diǎn)擊更新當(dāng)輸入的姓名在學(xué)生表里沒有時(shí)，如：點(diǎn)擊更新怎是加入一條學(xué)生信息選中一條學(xué)生信息，點(diǎn)擊刪除，會(huì)有提示框提示是否刪除：點(diǎn)擊確定會(huì)提示刪除成功取消則是取消刪除。返回鍵返回主菜單5、 學(xué)生成績(jī)錄入界面進(jìn)入學(xué)生成績(jī)錄入界面，顯示有記錄學(xué)生成績(jī)的學(xué)號(hào)、姓名、課程號(hào)及成績(jī)。錄入成績(jī)，以錄入Tom 學(xué)號(hào)061120課程號(hào)101為例：點(diǎn)擊確認(rèn)即錄入成績(jī)點(diǎn)擊返回，返回主菜單。四、心得體會(huì) 這次課程設(shè)計(jì)，一開始無從下手。在聽過老師的講解后，逐漸知道了大體方向。開始慢慢地做了起來。碰到困難，尋求同學(xué)和網(wǎng)絡(luò)的幫助，在他們的幫助下，問題一一解決，最終完成了此次的課程設(shè)計(jì)。此次的課程設(shè)計(jì)讓我對(duì)C#和數(shù)據(jù)庫(kù)有更深一步的了解，把平時(shí)零散的理論知識(shí)在此次課程設(shè)計(jì)中用起來了。同時(shí)也發(fā)現(xiàn)了自己的不足之處，日后要多多實(shí)踐。五、源程序 用戶登陸界面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.Data.SqlClient;namespace _1 public partial class userLog : Form public userLog() InitializeComponent(); public string connstr; public void Getway() connstr = "Data Source=.SQLEXPRESS;AttachDbFilename=E:1Student.mdf;Integrated Security=True;Connect Timeout=30;User Instance=False" private void quit_Click(object sender, EventArgs e) this.Close(); private void log_Click(object sender, EventArgs e) Getway(); string username = uname.Text.Trim(); string password = upassword.Text.Trim(); /string selectcommond = "select * from Userxx where UserName ="+ username+" and Userpassword = "+ password+"" string _sql = "select * from userinfo" /方?便?前期操作痢? 后來?要癮刪?除y的?記?住? using (SqlConnection conn = new SqlConnection(connstr) conn.Open(); SqlCommand sql = new SqlCommand(_sql, conn); SqlDataReader reader = sql.ExecuteReader(); if (reader.Read() main open1 = new main(); open1.ShowDialog(); else if (uname.Text = "") MessageBox.Show("用?戶名?不?能為a空?！?", "錯(cuò)洙?誤提?示?！?"); else if (upassword.Text = "") MessageBox.Show("密碼?不?能為a空?！?", "錯(cuò)洙?誤提?示?！?"); else MessageBox.Show("不?存?在該?用?戶信?息！?", "錯(cuò)洙?誤提?示?！?"); uname.Text = "" upassword.Text = "" 主界面 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.Data.SqlClient;namespace _1 public partial class main : Form public main() InitializeComponent(); private void button1_Click_1(object sender, EventArgs e) StuinfoCheck stu1 = new StuinfoCheck(); stu1.ShowDialog(); private void button2_Click_1(object sender, EventArgs e) StuinfoAdd stu2 = new StuinfoAdd(); stu2.ShowDialog(); private void button3_Click_1(object sender, EventArgs e) StuGraceinfo stu3 = new StuGraceinfo(); stu3.ShowDialog(); private void button4_Click_1(object sender, EventArgs e) this.Close(); 學(xué)生信息查詢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.Data.SqlClient;using System.IO;namespace _1 public partial class StuinfoCheck : Form public StuinfoCheck() InitializeComponent(); public string SelectSno; private void StuinfoCheck_Load(object sender, EventArgs e) / TODO: 這a行D代洙?碼?將?數(shù)簓據(jù)Y加載?到?表括?“studentDataSet.S”中D。您可以?根據(jù)Y需要癮移?動(dòng)或移?除y它。 /this.sTableAdapter.Fill(this.studentDataSet.S); / TODO: 這a行D代洙?碼?將?數(shù)簓據(jù)Y加載?到?表括?“studentDataSet.C”中D。您可以?根據(jù)Y需要癮移?動(dòng)或移?除y它。 /this.cTableAdapter.Fill(this.studentDataSet.C); /- string connstr = "Data Source=.SQLEXPRESS;AttachDbFilename=E:1Student.mdf;Integrated Security=True;Connect Timeout=30;User Instance=False" string _sql = "SELECT Sno as 學(xué)號(hào)?,Sname as 姓?名?,Smajor as 專痢?業(yè)唉?Ssex as 性?別纄,Sbirth as 生?日?,totalpoint as 總哩?學(xué)分?,remark as 備?注痢?from S" / string _sql = "select Sno as 學(xué)號(hào)?,Sname as 姓?名? from S" SqlConnection cnn = new SqlConnection(connstr); SqlDataAdapter sda = new SqlDataAdapter(_sql, cnn); DataSet ds = new DataSet(); sda.Fill(ds); dataGridView1.DataSource = ds.Tables0.DefaultView; string sql_Smajor="select distinct Smajor from S" SqlCommand cmd = new SqlCommand(sql_Smajor,cnn); cnn.Open(); / SqlDataReader dr = new SqlDataReader(); SqlDataReader dr = cmd.ExecuteReader(); while(dr.Read() majorSelection.Items.Add(dr0); cnn.Close(); majorSelection.SelectedIndex=0; public DataSet Conn(string sql) string connstr = "Data Source=.SQLEXPRESS;AttachDbFilename=E:1Student.mdf;Integrated Security=True;Connect Timeout=30;User Instance=False" /string _sql = "SELECT Sno as 學(xué)號(hào)?,Sname as 姓?名?,Smajor as 專痢?業(yè)唉?Ssex as 性?別纄,Sbirth as 生?日?,totalpoint as 總哩?學(xué)分?,remark as 備?注痢?from S" SqlConnection cnn = new SqlConnection(connstr); SqlDataAdapter sda = new SqlDataAdapter(sql, cnn); DataSet ds = new DataSet(); sda.Fill(ds); return ds ; private void search_Click(object sender, EventArgs e) string sql = "select * from S where 1=1 " if (no.Text.Trim() != string.Empty) sql += " and Sno like %" + no.Text.Trim() + "%" if (name.Text.Trim() != string.Empty) sql += " and Sname like %" + name.Text.Trim() + "%" if (majorSelection.Text.Trim() != "所有瓺專痢?業(yè)唉?) sql += " and Smajor like %" + majorSelection.Text + "" DataSet ds = Conn(sql); dataGridView1.DataSource = ds.Tables0.DefaultView; /private void dataGridView1_RowHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e) / / string str = dataGridView1.CurrentRow.Cells0.Value.ToString(); / string _sql = "SELECT Sno as 學(xué)號(hào)?,Sname as 姓?名?,Smajor as 專痢?業(yè)唉?Ssex as 性?別纄,Sbirth as 生?日?,totalpoint as 總哩?學(xué)分?,remark as 備?注痢?from S" / DataSet ds = Conn(_sql); / dataGridView1.DataSource = ds.Tables0.DefaultView; / private void dataGridView1_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e) stuinfodetail formCourse = new stuinfodetail(); formCourse.SelectSno = dataGridView1.CurrentRow.Cells0.Value.ToString(); formCourse.ShowDialog(); private void exit_Click(object sender, EventArgs e) this.Close(); 成績(jī)顯示界面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.Data.SqlClient;namespace _1 public partial class stuinfodetail : Form public string SelectSno; public stuinfodetail() InitializeComponent(); private void stuinfodetail_Load(object sender, EventArgs e) string connstr = "Data Source=.SQLEXPRESS;AttachDbFilename=E:1Student.mdf;Integrated Security=True;Connect Timeout=30;User Instance=False" string _sql = "SELECT S.Sno as 學(xué)號(hào)?,Sname as 姓?名?,Cno as 課?程號(hào)?,Point 成績(jī) FROM S,SC where S.Sno = SC.Sno and S.Sno=" + this.SelectSno + "" SqlConnection cnn = new SqlConnection(connstr); cnn.Open(); SqlDataAdapter sda = new SqlDataAdapter(_sql, cnn); DataSet ds = new DataSet(); sda.Fill(ds); dataGridView1.DataSource = ds.Tables0.DefaultView; cnn.Close(); 學(xué)生信息修改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.Data.SqlClient;namespace _1 public partial class StuinfoAdd : Form public StuinfoAdd() InitializeComponent(); private void StuinfoAdd_Load(object sender, EventArgs e) / TODO: 這a行D代洙?碼?將?數(shù)簓據(jù)Y加載?到?表括?“studentDataSet.S”中D。您可以?根據(jù)Y需要癮移?動(dòng)或移?除y它。 /this.sTableAdapter.Fill(this.studentDataSet.S); / TODO: 這a行D代洙?碼?將?數(shù)簓據(jù)Y加載?到?表括?“studentDataSet.C”中D。您可以?根據(jù)Y需要癮移?動(dòng)或移?除y它。 /this.cTableAdapter.Fill(this.studentDataSet.C); /- string connstr = "Data Source=.SQLEXPRESS;AttachDbFilename=E:1Student.mdf;Integrated Security=True;Connect Timeout=30;User Instance=False" string _sql = "SELECT Sno as 學(xué)號(hào)?,Sname as 姓?名?,Smajor as 專痢?業(yè)唉?Ssex as 性?別纄,Sbirth as 生?日?,totalpoint as 總哩?學(xué)分?,remark as 備?注痢?from S" / string _sql = "select Sno as 學(xué)號(hào)?,Sname as 姓?名? from S" SqlConnection cnn = new SqlConnection(connstr); SqlDataAdapter sda = new SqlDataAdapter(_sql, cnn); DataSet ds = new DataSet(); sda.Fill(ds); dataGridView1.DataSource = ds.Tables0.DefaultView; /string sql_Smajor = "select distinct Smajor from S" /SqlCommand cmd = new SqlCommand(sql_Smajor, cnn); cnn.Open(); /SqlDataReader dr = new SqlDataReader(); /SqlDataReader dr = cmd.ExecuteReader(); /while (dr.Read() / / majorSeletion.Items.Add(dr0); / /cnn.Close(); /majorSeletion.SelectedIndex = 0; private void delete_Click(object sender, EventArgs e) string connstr = "Data Source=.SQLEXPRESS;AttachDbFilename=E:1Student.mdf;Integrated Security=True;Connect Timeout=30;User Instance=False" DialogResult ret = MessageBox.Show("確?定要癮刪?除y該?信?息嗎e？?", "刪?除y", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if(ret = DialogResult.Cancel) return; string _sql="delete from S where Sno="+stuno.Text+"" SqlConnection conn = new SqlConnection(connstr); SqlCommand cmd = new SqlCommand(_sql,conn); try conn .Open(); int rows=cmd .ExecuteNonQuery(); if(rows = 1) MessageBox.Show("刪?除y成功|！?", "提?示?", MessageBoxButtons.OK, MessageBoxIcon.Information); StuinfoAdd_Load(null ,null ); finally conn.Close(); private void dataGridView1_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e) stuno.Text = dataGridView1.CurrentRow.Cells0.Value.ToString(); stuname.Text = dataGridView1.CurrentRow.Cells1.Value.ToString(); cname.Text = dataGridView1.CurrentRow.Cells2.Value.ToString(); stubirth.Text = dataGridView1.CurrentRow.Cells4.Value.ToString(); credit.Text = dataGridView1.CurrentRow.Cells5.Value.ToString(); sturemark.Text = dataGridView1.CurrentRow.Cells6.Value.ToString(); if (dataGridView1.CurrentRow.Cells3.Value.ToString().Trim () = "男D") male.Checked = true; else female.Checked = true; /stubirth.Text = Convert.ToDateTime(stubirth.Text.Trim().ToShortDateString(); private void updata_Click(object sender, EventArgs e) /更新?信?息 string connstr = "Data Source=.SQLEXPRESS;AttachDbFilename=E:1Student.mdf;Integrated Security=True;Connect Timeout=30;User Instance=False" string _title = "select count(*) from S where sno=" + stuno.Text + "" SqlConnection conn = new SqlConnection(connstr); SqlCommand cmd = new SqlCommand(_title, conn); /檢查是?否?有瓺該?學(xué)生?的?信?息，?有瓺則修T改?，?無T則添?加 try conn.Open(); int str = (int)cmd.ExecuteScalar();/強(qiáng)?制?轉(zhuǎn)羇換?，?執(zhí)行D查詢并返?回?查詢所返?回?的?結(jié)果?集中D第臺(tái)?一?行D的?第臺(tái)?一?列 /修T改?信?息 if (str = 1) _title = "update S set Sname = " + stuname.Text + ",Smajor = " + cname.Text + ",totalpoint = " + int.Parse(credit.Text) + ",remark=" + sturemark.Text + " where Sno=" + stuno.Text + "" /添?加新?信?息 else /DateTime cn = Convert.ToDateTime(stubirth.Text.Trim(); string sex = male.Checked ? "男D" : "女?" _title = "insert into S(Sno,Sname,Smajor,Ssex,Sbirth,totalpoint,remark) values ( " + stuno.Text + "," + stuname.Text + "," + cname.Text + "," + sex + "," + stubirth.Text.Trim() + "," + int.Parse(credit.Text) + "," + sturemark.Text + ")" cmd = new SqlCommand(_title, conn); cmd.ExecuteNonQuery(); StuinfoAdd_Load(null, null); finally conn.Close(); private void exit_Click(object sender, EventArgs e) this.Close(); 學(xué)生成績(jī)錄入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.Data.SqlClient;namespace _1 public partial class StuGraceinfo : Form public StuGraceinfo() InitializeComponent(); private void StuGraceinfo_Load(object sender, EventArgs e) string connstr = "Data Source=.SQLEXPRESS;AttachDbFilename=E:1Student.mdf;Integrated Security=True;Connect Timeout=30;User Instance=False" string _sql = "SELECT S.Sno as 學(xué)號(hào)?,Sname as 姓?名?,Cno as 課?程號(hào)?,Point as 成績(jī) FROM S,SC where S.Sno=SC.Sno" /SELECT Sno as 學(xué)號(hào)?,Sname as 姓?名?,Smajor as 專痢?業(yè)唉?Ssex as 性?別纄,Sbirth as 生?日?,totalpoint as 總哩?學(xué)分?,remark as 備?注痢?from S SqlConnection cnn = new SqlConnection(connstr); SqlDataAdapter sda = new SqlDataAdapter(_sql, cnn); cnn.Open(); DataSet ds = new DataSet(); sda.Fill(ds); dataGridView1.DataSource = ds.Tables0.DefaultView; /cnn.Close(); private void button3_Click(object sender, EventArgs e) this.Close(); private void dataGridView1_RowHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e) textBox1.Text = dataGridView1.CurrentRow.Cells1.Value.ToString(); textBox3.Text = dataGridView1.CurrentRow.Cells0.Value.ToString(); textBox4.Text = dataGridView1.CurrentRow.Cells3.Value.ToString(); textBox6.Text = dataGridView1.CurrentRow.Cells2.Value.ToString(); private void button1_Click(object sender, EventArgs e) string connstr = "Data Source=.SQLEXPRESS;AttachDbFilename=E:1Student.mdf;Integrated Security=True;Connect Timeout=30;User Instance=False" string _sql = "select count(*) from S where S.Sno=" + textBox1.Text + "" string sql1 = "select Cno from C where Cno=" + textBox6 .Text + "" SqlConnection cnn = new SqlConnection(connstr); SqlCommand cmd = new SqlCommand(_sql,cnn); SqlCommand cmd1 = new SqlCommand(sql1, cnn); string cno="" try cnn.Open(); SqlDataReader dr = cmd1.ExecuteReader(); while (dr.Read() cno = dr0.ToString(); cnn.Close(); cnn.Open(); int cnt = (int)cmd.ExecuteScalar(); /制?轉(zhuǎn)羇化 返?回?第臺(tái)?一?行D第臺(tái)?一?列 修T改?記?錄? if (cnt = 1) _sql = "update SC set Point=" + textBox4.Text + ",Cno=" + textBox6.Text + " where Sno="+textBox1.Text +"" else /添?加記?錄? _sql = "insert into SC(Sno,Cno,Point) values(" + textBox3.Text.Trim() + "," + textBox6.Text.Trim() + "," + int.Parse(textBox4.Text.Trim() + ")" cmd = new SqlCommand(_sql, cnn); int i = cmd.ExecuteNonQuery(); StuGraceinfo_Load(null, null); finally cnn.Close(); 設(shè)計(jì)日志記錄每天的主要設(shè)計(jì)內(nèi)容、遇到的問題、解決方法及效果，等。DAY 1聽了老師對(duì)系統(tǒng)架構(gòu)的部分分析，對(duì)本次課程設(shè)計(jì)有了大致的了解，明確了大體框架，把任務(wù)書上的數(shù)據(jù)庫(kù)表準(zhǔn)備好了，并簡(jiǎn)單地完成了系統(tǒng)各個(gè)窗體的設(shè)計(jì)。DAY 2對(duì)各個(gè)窗體進(jìn)行了更為細(xì)致的設(shè)計(jì)，對(duì)需要用到的事件和要修改的屬性進(jìn)行適當(dāng)分配，以便設(shè)計(jì)代碼時(shí)能對(duì)整體更清晰，完成了用戶登陸的代碼設(shè)計(jì)。DAY 3開始代碼設(shè)計(jì)，實(shí)現(xiàn)了學(xué)生信息查詢的功能。在這過程中，遇到了許多問題諸如數(shù)據(jù)庫(kù)的