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?lasttest
{
????public?partial?class?courestudent_teacher?:?Form
????{
????????string?con?=?“server=.;database=Student;Integrated?Security=SSPI;“;
????????string?sno;
????????string?name;
????????informationteacher?it;
?????
????????public?courestudent_teacher（string?snostring?nameinformationteacher?it）
????????{
????????????InitializeComponent（）;
????????????
????????????datacoure.DataSource?=?bindingSource1;
????????????
????????????this.Text?=“學(xué)生選課信息“;
????????????this.it?=?it;
????????????DataSet?ret?=?new?DataSet（）;
????????????using?（SqlConnection?cnn?=?new?SqlConnection（con））
????????????{
????????????????cnn.Open（）;
????????????????string?queryString?=?“select?student.sno?as?學(xué)號(hào)??sname?as?姓名sclass?as?班級(jí)?course.cno?as?課程號(hào)碼cname?as?課程名cteacher?as?授課教師grade?as?成績(jī)?from?coursesc?student?where?student.sno=‘“?+?sno?+“‘?and?course.cno=sc.cno?and?student.sno=sc.sno“;
????????????????SqlDataAdapter?ad?=?new?SqlDataAdapter（）;
????????????????SqlCommand?com?=?new?SqlCommand（queryString?cnn）;
????????????????com.CommandType?=?CommandType.Text;
????????????????ad.SelectCommand?=?com;
????????????????ad.Fill（ret）;

????????????????this.sno?=?sno;
????????????????this.name?=name;
????????????}
????????????bindingSource1.DataSource?=?ret.Tables[0];
????????????
????????}

????????private?void?DataBind（）
????????{
????????????DataSet?ret?=?new?DataSet（）;
????????????using?（SqlConnection?cnn?=?new?SqlConnection（con））
????????????{
????????????????cnn.Open（）;
????????????????string?queryString?=?“select?student.sno?as?學(xué)號(hào)??sname?as?姓名sclass?as?班級(jí)?course.cno?as?課程號(hào)碼cname?as?課程名cteacher?as?授課教師grade?as?成績(jī)?from?coursesc?student?where?student.sno=‘“?+?sno?+?“‘?and?course.cno=sc.cno?and?student.sno=sc.sno“;
????????????????SqlDataAdapter?ad?=?new?SqlDataAdapter（）;
????????????????SqlCommand?com?=?new?SqlCommand（queryString?cnn）;
????????????????com.CommandType?=?CommandType.Text;
????????????????ad.SelectCommand?=?com;
????????????????ad.Fill（ret）;

????????????}
????????????bindingSource1.DataSource?=?ret.Tables[0];
????????}

????????private?void?courestudent_Load（object?sender?EventArgs?e）
????????{
????????????lablesno.Enabled?=?false;
????????????txtcon.Enabled?=?false;
????????????labgrade.Enabled?=?false;
????????????txtgrade.Enabled?=?false;
????????????btnsure.Enabled?=?false;
????????????lablesno.Enabled?=?false;
????????????txtsno.Enabled?=?false;
????????}



???????

????????private?void?datacoure_CellDoubleClick（object?sender?DataGridViewCellEventArgs?e）
????????{

????????}

????????private?void?btnsure_Click（object?sender?EventArgs?e）
????????{
????????????using?（SqlConnection?cnn?=?new?SqlConnection（con））
????????????{
????????????????cnn.O

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????395??2010-12-29?14:47??lasttest\lasttest\app.config

?????文件?????585728??2011-05-24?17:42??lasttest\lasttest\bin\Debug\lasttest.exe

?????文件????????395??2010-12-29?14:47??lasttest\lasttest\bin\Debug\lasttest.exe.config

?????文件?????255488??2011-05-24?17:42??lasttest\lasttest\bin\Debug\lasttest.pdb

?????文件??????14328??2011-05-28?15:44??lasttest\lasttest\bin\Debug\lasttest.vshost.exe

?????文件????????395??2010-12-29?14:47??lasttest\lasttest\bin\Debug\lasttest.vshost.exe.config

?????文件????????490??2009-06-11?05:14??lasttest\lasttest\bin\Debug\lasttest.vshost.exe.manifest

?????文件???????8272??2010-12-29?16:49??lasttest\lasttest\courestudent.cs

?????文件??????11833??2010-12-29?15:23??lasttest\lasttest\courestudent.Designer.cs

?????文件???????6215??2010-12-29?15:23??lasttest\lasttest\courestudent.resx

?????文件??????97886??2011-05-24?17:29??lasttest\lasttest\hydlbj1.jpg

?????文件???????3538??2010-12-29?16:35??lasttest\lasttest\informationchange.cs

?????文件??????15073??2010-12-29?16:34??lasttest\lasttest\informationchange.Designer.cs

?????文件???????5814??2010-12-29?16:34??lasttest\lasttest\informationchange.resx

?????文件???????6463??2011-05-24?16:27??lasttest\lasttest\Informationstudent.cs

?????文件??????14202??2011-05-24?16:15??lasttest\lasttest\Informationstudent.Designer.cs

?????文件???????6215??2011-05-24?16:15??lasttest\lasttest\Informationstudent.resx

?????文件??????10062??2011-05-24?16:52??lasttest\lasttest\informationteacher.cs

?????文件??????16309??2011-05-24?16:44??lasttest\lasttest\informationteacher.Designer.cs

?????文件???????6215??2011-05-24?16:44??lasttest\lasttest\informationteacher.resx

?????文件???????7546??2011-05-24?17:41??lasttest\lasttest\lasttest.csproj

?????文件???????4479??2011-05-24?17:38??lasttest\lasttest\Login.cs

?????文件???????6024??2011-05-24?17:37??lasttest\lasttest\Login.Designer.cs

?????文件?????211927??2010-12-28?13:28??lasttest\lasttest\login.jpg

?????文件???????5814??2011-05-24?17:37??lasttest\lasttest\Login.resx

?????文件????????180??2011-05-24?17:41??lasttest\lasttest\obj\Debug\lasttest.courestudent_teacher.resources

?????文件???????7115??2011-05-28?15:44??lasttest\lasttest\obj\Debug\lasttest.csproj.FileListAbsolute.txt

?????文件???????1616??2011-05-24?17:39??lasttest\lasttest\obj\Debug\lasttest.csproj.GenerateResource.Cache

?????文件?????585728??2011-05-24?17:42??lasttest\lasttest\obj\Debug\lasttest.exe

?????文件????????180??2011-05-24?17:41??lasttest\lasttest\obj\Debug\lasttest.informationchange.resources

............此處省略53個(gè)文件信息