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?XuanKe
{
????public?partial?class?courseLook?:?Form
????{
????????public?courseLook（）
????????{
????????????InitializeComponent（）;
????????}

????????public?void?selCourse（string?sqlStr）?{
????????????string?strcon?=?“Data?Source=.;Initial?Catalog=XuanKe;Persist?Security?Info=False;?User?ID=sa;?Password=sasa“;//建立連接
????????????SqlConnection?conn?=?new?SqlConnection（strcon）;
????????????//打開連接
????????????conn.Open（）;
????????????//數據庫查詢并將結果顯示在dataGridView1中
????????????String?strsql?=?sqlStr;
????????????SqlDataAdapter?da?=?new?SqlDataAdapter（strsql?strcon）;
????????????DataSet?ds?=?new?DataSet（）;
????????????da.Fill（ds）;
????????????dataGridView1.DataSource?=?ds.Tables[0];
????????????conn.Close（）;
????????}
????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????string?courseName?=?comboBox1.Text.ToString（）;
????????????selCourse（“select?*?from?courseSel?where?courseName=?‘“?+?courseName?+?“‘“）;
????????}

????????private?void?button2_Click（object?sender?EventArgs?e）
????????{
????????????selCourse（“select?*?from?courseSel“）;
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-03-31?18:12??C#學生選課系統\
?????目錄???????????0??2017-03-31?18:10??C#學生選課系統\XuanKe\
?????目錄???????????0??2017-03-31?18:10??C#學生選課系統\XuanKe\XuanKe\
?????文件????????7566??2017-03-15?15:41??C#學生選課系統\XuanKe\XuanKe\Login.Designer.cs
?????文件????????3035??2017-03-22?17:27??C#學生選課系統\XuanKe\XuanKe\Login.cs
?????文件????????5814??2017-03-15?15:41??C#學生選課系統\XuanKe\XuanKe\Login.resx
?????文件????????4020??2017-03-22?17:23??C#學生選課系統\XuanKe\XuanKe\Main.Designer.cs
?????文件????????1156??2017-03-22?17:23??C#學生選課系統\XuanKe\XuanKe\Main.cs
?????文件????????6012??2017-03-22?17:23??C#學生選課系統\XuanKe\XuanKe\Main.resx
?????文件?????????769??2017-03-22?17:26??C#學生選課系統\XuanKe\XuanKe\Program.cs
?????目錄???????????0??2017-03-31?18:10??C#學生選課系統\XuanKe\XuanKe\Properties\
?????文件????????1368??2017-03-08?14:53??C#學生選課系統\XuanKe\XuanKe\Properties\AssemblyInfo.cs
?????文件????????2862??2017-03-08?14:53??C#學生選課系統\XuanKe\XuanKe\Properties\Resources.Designer.cs
?????文件????????5612??2017-03-08?14:53??C#學生選課系統\XuanKe\XuanKe\Properties\Resources.resx
?????文件????????1091??2017-03-08?14:53??C#學生選課系統\XuanKe\XuanKe\Properties\Settings.Designer.cs
?????文件?????????249??2017-03-08?14:53??C#學生選課系統\XuanKe\XuanKe\Properties\Settings.settings
?????文件????????7816??2017-03-15?15:53??C#學生選課系統\XuanKe\XuanKe\RegisterForm.Designer.cs
?????文件????????2784??2017-03-15?16:36??C#學生選課系統\XuanKe\XuanKe\RegisterForm.cs
?????文件????????5814??2017-03-15?15:53??C#學生選課系統\XuanKe\XuanKe\RegisterForm.resx
?????文件???????11627??2017-03-27?14:46??C#學生選課系統\XuanKe\XuanKe\Stu.Designer.cs
?????文件????????8066??2017-03-27?16:10??C#學生選課系統\XuanKe\XuanKe\Stu.cs
?????文件????????7737??2017-03-27?14:46??C#學生選課系統\XuanKe\XuanKe\Stu.resx
?????文件????????5720??2017-03-13?16:53??C#學生選課系統\XuanKe\XuanKe\UpdateForm.Designer.cs
?????文件????????2077??2017-03-22?16:21??C#學生選課系統\XuanKe\XuanKe\UpdateForm.cs
?????文件????????5814??2017-03-08?17:13??C#學生選課系統\XuanKe\XuanKe\UpdateForm.resx
?????文件????????5641??2017-03-22?16:06??C#學生選課系統\XuanKe\XuanKe\UpdateStu.Designer.cs
?????文件????????1920??2017-03-22?16:23??C#學生選課系統\XuanKe\XuanKe\UpdateStu.cs
?????文件????????5814??2017-03-22?16:06??C#學生選課系統\XuanKe\XuanKe\UpdateStu.resx
?????文件????????6973??2017-03-22?17:27??C#學生選課系統\XuanKe\XuanKe\XuanKe.csproj
?????目錄???????????0??2017-03-31?18:10??C#學生選課系統\XuanKe\XuanKe\bin\
?????目錄???????????0??2017-03-31?18:10??C#學生選課系統\XuanKe\XuanKe\bin\Debug\
............此處省略49個文件信息