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?frm_logn
{
????public?partial?class?couror_chaxun?:?Form
????{
????????private?static?SqlCommand?cmd?=?null;
????????private?static?string?sql?=?null;
????????private?static?SqlConnection?conn?=?null;

????????public?couror_chaxun（）
????????{
????????????InitializeComponent（）;
????????????string?strConn?=?“Data?Source=.;Initial?Catalog?=?GuanLi;Trusted_Connection=SSPI“;
????????????conn?=?new?SqlConnection（strConn）;
????????????conn.Open（）;
????????}

????????private?void?bt_all_Click（object?sender?EventArgs?e）
????????{
????????????dataGridView1.Visible?=?true;
????????????DataSet?ds?=?new?DataSet（）;
????????????using?（SqlConnection?c?=?new?SqlConnection（））
????????????{
????????????????c.ConnectionString?=?“Data?Source=.;Initial?Catalog?=?GuanLi;Trusted_Connection=SSPI“;
????????????????c.Open（）;
????????????????using?（SqlCommand?command?=?c.CreateCommand（））
????????????????{
????????????????????command.CommandText?=?“select?Course.*CC.ClassID?from?CourseCC?where?Course.Cno?=?CC.Cno??“?;
????????????????????SqlDataAdapter?da?=?new?SqlDataAdapter（command）;
????????????????????try
????????????????????{
????????????????????????da.Fill（ds）;
????????????????????}
????????????????????catch
????????????????????{?
??????????????????????
????????????????????}
????????????????}
????????????}
????????????DataTable?dt?=?new?DataTable（）;
????????????dt?=?ds.Tables[0].Copy（）;
????????????this.dataGridView1.DataSource?=?dt;
????????????ds.Clear（）;

????????}

????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????dataGridView1.Visible?=?true;
????????????DataSet?ds?=?new?DataSet（）;
????????????using?（SqlConnection?c?=?new?SqlConnection（））
????????????{
????????????????c.ConnectionString?=?“Data?Source=.;Initial?Catalog?=?GuanLi;Trusted_Connection=SSPI“;
????????????????c.Open（）;
????????????????using?（SqlCommand?command?=?c.CreateCommand（））
????????????????{
????????????????????command.CommandText?=?“select?Course.*CC.ClassID?from?CourseCC?where?Course.Cno?=?CC.Cno?and??Course.Cno?=?‘“
????????????????????????+?tb_cno.Text.ToString（）?+?“‘“;
????????????????????SqlDataAdapter?da?=?new?SqlDataAdapter（command）;
????????????????????try
????????????????????{
????????????????????????da.Fill（ds）;
????????????????????????DataTable?dt?=?new?DataTable（）;
????????????????????????dt?=?ds.Tables[0].Copy（）;
????????????????????????this.dataGridView1.DataSource?=?dt;
????????????????????}
????????????????????catch
????????????????????{
????????????????????????MessageBox.Show（“沒有該課程“）;
????????????????????}
????????????????}
????????????}
???????????
????????????ds.Clear（）;

????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2015-12-16?23:19??frm_logn\
?????文件?????????866??2015-11-24?16:53??frm_logn.sln
?????文件?????????436??2015-11-24?16:35??frm_logn\app.config
?????目錄???????????0??2015-12-01?20:47??frm_logn\bin\
?????目錄???????????0??2015-12-16?23:17??frm_logn\bin\Debug\
?????文件??????128000??2015-12-17?00:01??frm_logn\bin\Debug\frm_logn.exe
?????文件?????????436??2015-11-24?16:35??frm_logn\bin\Debug\frm_logn.exe.config
?????文件??????153088??2015-12-17?00:01??frm_logn\bin\Debug\frm_logn.pdb
?????文件???????11600??2015-12-17?00:02??frm_logn\bin\Debug\frm_logn.vshost.exe
?????文件?????????436??2015-11-24?16:35??frm_logn\bin\Debug\frm_logn.vshost.exe.config
?????目錄???????????0??2015-12-01?20:47??frm_logn\bin\Release\
?????文件????????2968??2015-12-17?00:00??frm_logn\couror_chaxun.cs
?????文件????????4617??2015-12-08?14:40??frm_logn\couror_chaxun.Designer.cs
?????文件????????5817??2015-12-08?14:40??frm_logn\couror_chaxun.resx
?????文件????????6617??2015-12-16?23:14??frm_logn\denglu
?????文件????????5299??2015-12-16?23:55??frm_logn\Form1.cs
?????文件????????8631??2015-12-16?23:42??frm_logn\Form1.Designer.cs
?????文件???????19480??2015-12-16?23:42??frm_logn\Form1.resx
?????文件????????9283??2015-12-16?23:37??frm_logn\frm_logn.csproj
?????文件????????2172??2015-12-16?23:37??frm_logn\frm_Manager.cs
?????文件????????9483??2015-12-16?23:37??frm_logn\frm_Manager.Designer.cs
?????文件????????6015??2015-12-16?23:37??frm_logn\frm_Manager.resx
?????文件????????5169??2015-12-16?23:59??frm_logn\frm_Student.cs
?????文件???????11809??2015-12-16?23:47??frm_logn\frm_Student.Designer.cs
?????文件????????6440??2015-12-16?23:47??frm_logn\frm_Student.resx
?????文件?????????929??2015-11-03?15:39??frm_logn\frm_Stu_XiuGai.cs
?????文件????????4690??2015-11-03?15:39??frm_logn\frm_Stu_XiuGai.Designer.cs
?????文件????????5817??2015-11-03?15:39??frm_logn\frm_Stu_XiuGai.resx
?????文件????????5420??2015-12-17?00:01??frm_logn\frm_Teacher.cs
?????文件???????14586??2015-12-16?23:37??frm_logn\frm_Teacher.Designer.cs
?????文件????????6015??2015-12-16?23:37??frm_logn\frm_Teacher.resx
............此處省略75個文件信息