using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Data;
using?System.Data.SqlClient;


namespace?SelectCourse
{
????class?CDatabase
????{
????????//public?static?string?connStr?=?“?Data?Source=SONY-PC\\HE豐;Initial?Catalog=DBSelectCourse;Integrated?Security=true“;
????????//public?static?SqlConnection?conn?=?new?SqlConnection（connStr）;
????????public?static?string?connStr;
????????public?static?SqlConnection?conn?=?new?SqlConnection（connStr）;

????????public?static?DataSet?GetDataFromDB（string?sqlStr）
????????{
????????????conn.Open（）;
????????????SqlDataAdapter?myAdapter?=?new?SqlDataAdapter（sqlStr?conn）;
????????????DataSet?myDataSet?=?new?DataSet（）;
????????????myDataSet.Clear（）;
????????????myAdapter.Fill（myDataSet）;
????????????conn.Close（）;
????????????if?（myDataSet.Tables[0].Rows.Count?!=?0）
????????????{
????????????????return?myDataSet;
????????????}
????????????else
????????????{
????????????????return?null;
????????????}
????????}

????????public?static?bool?UpdateDB（string?sqlStr）
????????{
????????????conn.Open（）;
????????????SqlCommand?myCmd?=?new?SqlCommand（sqlStr?conn）;
????????????myCmd.CommandType?=?CommandType.Text;
????????????myCmd.ExecuteNonQuery（）;
????????????conn.Close（）;
????????????return?true;
????????}
????????

????????

????}
???
}

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

?????文件?????????72??2010-10-13?17:21??SelectCourse\SelectCourse\bin\Debug\DbSet.ini

?????文件?????457728??2010-12-27?10:17??SelectCourse\SelectCourse\bin\Debug\SelectCourse.exe

?????文件?????157184??2010-12-27?10:17??SelectCourse\SelectCourse\bin\Debug\SelectCourse.pdb

?????文件??????11600??2011-09-07?16:52??SelectCourse\SelectCourse\bin\Debug\SelectCourse.vshost.exe

?????文件????????490??2009-08-31?00:40??SelectCourse\SelectCourse\bin\Debug\SelectCourse.vshost.exe.manifest

?????文件??????89088??2010-10-12?23:05??SelectCourse\SelectCourse\bin\Release\SelectCourse.exe

?????文件??????28160??2010-10-12?23:05??SelectCourse\SelectCourse\bin\Release\SelectCourse.pdb

?????文件??????11600??2010-10-12?23:06??SelectCourse\SelectCourse\bin\Release\SelectCourse.vshost.exe

?????文件????????490??2010-03-17?22:39??SelectCourse\SelectCourse\bin\Release\SelectCourse.vshost.exe.manifest

?????文件???????1389??2010-12-27?10:17??SelectCourse\SelectCourse\CDatabase.cs

?????文件????????734??2010-10-16?08:55??SelectCourse\SelectCourse\CPublic.cs

?????文件??????15223??2010-10-20?13:06??SelectCourse\SelectCourse\FrmCourse.cs

?????文件??????15687??2010-10-20?13:06??SelectCourse\SelectCourse\FrmCourse.Designer.cs

?????文件??????53609??2010-10-20?13:06??SelectCourse\SelectCourse\FrmCourse.resx

?????文件???????4887??2010-12-20?23:35??SelectCourse\SelectCourse\FrmDatabase.cs

?????文件???????9055??2010-10-21?16:03??SelectCourse\SelectCourse\FrmDatabase.Designer.cs

?????文件??????54007??2010-10-21?16:03??SelectCourse\SelectCourse\FrmDatabase.resx

?????文件???????1092??2010-11-08?10:35??SelectCourse\SelectCourse\FrmHelp.cs

?????文件???????7424??2010-11-08?10:35??SelectCourse\SelectCourse\FrmHelp.Designer.cs

?????文件??????54294??2010-11-08?10:35??SelectCourse\SelectCourse\FrmHelp.resx

?????文件???????7651??2010-10-19?15:25??SelectCourse\SelectCourse\FrmInformation.cs

?????文件??????14218??2010-10-18?21:51??SelectCourse\SelectCourse\FrmInformation.Designer.cs

?????文件??????53609??2010-10-18?21:51??SelectCourse\SelectCourse\FrmInformation.resx

?????文件???????9795??2010-12-20?10:21??SelectCourse\SelectCourse\FrmLogin.cs

?????文件??????19534??2010-12-20?10:21??SelectCourse\SelectCourse\FrmLogin.Designer.cs

?????文件??????53609??2010-12-20?10:21??SelectCourse\SelectCourse\FrmLogin.resx

?????文件???????8318??2010-10-14?10:49??SelectCourse\SelectCourse\FrmMain.cs

?????文件??????10039??2010-10-14?10:49??SelectCourse\SelectCourse\FrmMain.Designer.cs

?????文件??????53609??2010-10-14?10:49??SelectCourse\SelectCourse\FrmMain.resx

?????文件???????6249??2010-10-19?15:10??SelectCourse\SelectCourse\FrmPassword.cs

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