using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;
namespace?WindowsApplication1
{
????public?partial?class?ChengJiChaXun?:?Form
????{
????????string?strConn?=?“Server=localhost;?database=StudentCj;user=sa;password=ok;“;?//連接數據??
????????public?ChengJiChaXun（）
????????{
????????????InitializeComponent（）;
????????}

????????private?void?button2_Click（object?sender?EventArgs?e）
????????{
????????????try
????????????{
????????????????DataSet?ds;
????????????????string?sqla?=?“select?a.id?as?學號b.name?as?姓名a.cj?as?成績?c.kcmc?as?課程名稱?from?cjbiao?a?join?student?b?on?a.id=b.id?join?kecheng?c?on?a.kcdm=c.kcdm?where?a.id=‘“?+?textBox1.Text?+?“‘?or?b.name=‘“?+?textBox2.Text?+?“‘“;
????????????????SqlDataAdapter?adp?=?new?SqlDataAdapter（sqla?strConn）;
????????????????ds?=?new?DataSet（）;
????????????????ds.Clear（）;
????????????????adp.Fill（ds?“Cjbiao“）;
????????????????//dataGridView1.DataSource?=?ds.Tables[0].DefaultView;
????????????????if?（ds.Tables[0].Rows.Count?!=?0）??//判斷是否查詢出
????????????????{
????????????????????dataGridView1.DataSource?=?ds.Tables[0].DefaultView;


????????????????}
????????????????else
????????????????{
????????????????????MessageBox.Show（“對不起！你的成績不存在，請輸入正確的學號或姓名“）;

????????????????}
????????????}
????????????catch
????????????{?}
????????}

????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????try
????????????{
????????????????DataSet?ds2;
????????????????//string?sql2?=?“select?a.id?as?學號b.name?as?姓名a.cj?as?成績?c.kcmc?as?課程名稱?from?cjbiao?a?join?student?b?on?a.id=b.id?join?kecheng?c?on?a.kcdm=c.kcdm?where?a.bjdm=（select?bjdm?from?bj?where?bjmc=‘“+comboBj.Text+“‘）“;
????????????????string?sql2?=?“SELECT?b.ID?as?學號d.Name?as?姓名a.BJMC?as?班級名稱c.KCMC?as?課程名稱b.CJ??as?成績?FROM?BJ?a?join?cjbiao?b?ON?a.BJDM?=b.BJDM?JOIN?kecheng?c?ON?b.KCDM?=c.KCDM?JOIN?student?d?ON?b.ID?=?d.ID?where?bjmc=‘“?+?comboBox1.Text?+?“‘“;
????????????????SqlDataAdapter?adp?=?new?SqlDataAdapter（sql2?strConn）;
????????????????ds2?=?new?DataSet（）;
????????????????ds2.Clear（）;
????????????????adp.Fill（ds2?“Cjbiao1“）;
????????????????//dataGridView1.DataSource?=?ds2.Tables[0].DefaultView;
????????????????if?（ds2.Tables[0].Rows.Count?!=?0）　　//判斷是否查詢出
????????????????{
????????????????????dataGridView1.DataSource?=?ds2.Tables[0].DefaultView;
????????????????????textBox2.Text?=?““;
????????????????????textBox1.Text?=?““;
????????????????}
????????????????else
????????????????{
????????????????????MessageBox.Show（“對不起！你輸入的班級的信息不存在，請輸入正確的班級“）;
????????????????????textBox1.Text?=?““;
????????????????????textBox2.Text?=?““;

????????????????}
????????????}
????????????catch
????????????{?}
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????916??2010-02-05?09:03??源碼10?成績管理系統\Backup\CJGL.sln

????..A..H.?????15360??2010-09-08?00:00??源碼10?成績管理系統\Backup\CJGL.suo

?????文件?????????74??2009-08-20?17:41??源碼10?成績管理系統\Backup\成績管理系統\app.config

?????文件???????3091??2009-08-21?09:20??源碼10?成績管理系統\Backup\成績管理系統\ChengJiChaXun.cs

?????文件???????8277??2008-03-11?13:13??源碼10?成績管理系統\Backup\成績管理系統\ChengJiChaXun.Designer.cs

?????文件???????5814??2008-03-11?13:13??源碼10?成績管理系統\Backup\成績管理系統\ChengJiChaXun.resx

?????文件???????2276??2009-08-21?09:20??源碼10?成績管理系統\Backup\成績管理系統\ChengJiLuRu.cs

?????文件???????8388??2008-03-11?12:05??源碼10?成績管理系統\Backup\成績管理系統\ChengJiLuRu.Designer.cs

?????文件???????5814??2008-03-11?12:05??源碼10?成績管理系統\Backup\成績管理系統\ChengJiLuRu.resx

?????文件???????1622??2010-02-05?09:00??源碼10?成績管理系統\Backup\成績管理系統\ChengJiXiuGai.cs

?????文件???????6014??2008-03-11?12:21??源碼10?成績管理系統\Backup\成績管理系統\ChengJiXiuGai.Designer.cs

?????文件???????5814??2008-03-11?12:21??源碼10?成績管理系統\Backup\成績管理系統\ChengJiXiuGai.resx

?????文件???????8116??2010-07-26?10:57??源碼10?成績管理系統\Backup\成績管理系統\CJGL.csproj

?????文件????????485??2010-07-26?10:57??源碼10?成績管理系統\Backup\成績管理系統\CJGL.csproj.user

?????文件???????1668??2010-07-26?10:30??源碼10?成績管理系統\Backup\成績管理系統\CJGL_TemporaryKey.pfx

?????文件???????1894??2010-02-05?09:00??源碼10?成績管理系統\Backup\成績管理系統\Form1.cs

?????文件???????5329??2008-03-11?14:37??源碼10?成績管理系統\Backup\成績管理系統\Form1.Designer.cs

?????文件???????5814??2008-03-11?14:37??源碼10?成績管理系統\Backup\成績管理系統\Form1.resx

?????文件????????464??2010-02-05?08:56??源碼10?成績管理系統\Backup\成績管理系統\GuanYu.cs

?????文件???????3758??2010-02-05?08:56??源碼10?成績管理系統\Backup\成績管理系統\GuanYu.Designer.cs

?????文件???????5814??2010-02-05?08:56??源碼10?成績管理系統\Backup\成績管理系統\GuanYu.resx

?????文件???????2379??2008-03-11?21:08??源碼10?成績管理系統\Backup\成績管理系統\Main.cs

?????文件??????10999??2008-03-11?13:32??源碼10?成績管理系統\Backup\成績管理系統\Main.Designer.cs

?????文件???????6214??2008-03-11?13:32??源碼10?成績管理系統\Backup\成績管理系統\Main.resx

?????文件????????478??2008-03-09?14:59??源碼10?成績管理系統\Backup\成績管理系統\Program.cs

?????文件???????1210??2008-03-09?14:59??源碼10?成績管理系統\Backup\成績管理系統\Properties\AssemblyInfo.cs

?????文件???????2862??2010-02-05?08:54??源碼10?成績管理系統\Backup\成績管理系統\Properties\Resources.Designer.cs

?????文件???????5612??2008-03-09?14:59??源碼10?成績管理系統\Backup\成績管理系統\Properties\Resources.resx

?????文件???????1117??2010-02-05?08:54??源碼10?成績管理系統\Backup\成績管理系統\Properties\Settings.Designer.cs

?????文件????????249??2008-03-09?14:59??源碼10?成績管理系統\Backup\成績管理系統\Properties\Settings.settings

............此處省略113個文件信息