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

namespace?MySchool
{
????///?

????///?此類維護數據庫連接字符串，和?Connection?對象
????///?

??public?class?DBHelper
????{
????????//?數據庫連接字符串
????????private?string?connString?=?@“server=.;database=MySchool;uid=sa;Pwd=kevin“;

????????//?數據庫連接?Connection?對象
????????private?SqlConnection?connection;

????????///?

????????///?Connection對象
????????///?

????????public?SqlConnection?Connection
????????{
????????????get
????????????{
????????????????if?（connection?==?null）
????????????????{
????????????????????connection?=?new?SqlConnection（connString）;
????????????????}
????????????????return?connection;
????????????}????????????
????????}

????????///?

????????///?打開數據庫連接
????????///?

????????public?void?OpenConnection（）
????????{
????????????if?（Connection.State?==?ConnectionState.Closed）
????????????{
????????????????Connection.Open（）;
????????????}
????????????else?if?（Connection.State?==?ConnectionState.Broken）
????????????{
????????????????Connection.Close（）;
????????????????Connection.Open（）;
????????????}
????????}

????????///?

????????///?關閉數據庫連接
????????///?

????????public?void?CloseConnection（）
????????{
????????????if?（Connection.State?==?ConnectionState.Open?||?Connection.State?==?ConnectionState.Broken）
????????????{
????????????????Connection.Close（）;
????????????}
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2014-03-25?20:56??MYKTV后臺\
?????目錄???????????0??2014-04-15?14:20??MYKTV后臺\MyKTV\
?????目錄???????????0??2014-03-25?20:56??MYKTV后臺\MyKTVAdmin\
?????文件?????????872??2014-02-10?15:09??MYKTV后臺\MyKTVAdmin.sln
?????文件???????51712??2014-02-27?19:38??MYKTV后臺\MyKTVAdmin.suo
?????文件???????77312??2014-05-14?16:35??MYKTV后臺\MyKTVAdmin.v12.suo
?????文件?????????358??2014-02-21?08:59??MYKTV后臺\MyKTVAdmin\About.cs
?????文件????????5607??2014-02-21?08:59??MYKTV后臺\MyKTVAdmin\About.designer.cs
?????文件???????56866??2014-02-21?08:58??MYKTV后臺\MyKTVAdmin\About.resx
?????目錄???????????0??2014-03-25?20:56??MYKTV后臺\MyKTVAdmin\bin\
?????目錄???????????0??2014-03-25?20:56??MYKTV后臺\MyKTVAdmin\bin\Debug\
?????文件??????122880??2014-05-14?16:35??MYKTV后臺\MyKTVAdmin\bin\Debug\MyKTVAdmin.exe
?????文件??????118272??2014-05-14?16:35??MYKTV后臺\MyKTVAdmin\bin\Debug\MyKTVAdmin.pdb
?????文件???????24224??2014-05-14?16:35??MYKTV后臺\MyKTVAdmin\bin\Debug\MyKTVAdmin.vshost.exe
?????文件?????????490??2012-06-02?22:34??MYKTV后臺\MyKTVAdmin\bin\Debug\MyKTVAdmin.vshost.exe.manifest
?????目錄???????????0??2014-02-27?19:40??MYKTV后臺\MyKTVAdmin\bin\Release\
?????文件????????7318??2014-02-22?14:27??MYKTV后臺\MyKTVAdmin\FrmAddSong.cs
?????文件???????10413??2014-02-12?19:53??MYKTV后臺\MyKTVAdmin\FrmAddSong.Designer.cs
?????文件????????6020??2014-02-11?15:34??MYKTV后臺\MyKTVAdmin\FrmAddSong.resx
?????文件???????10619??2014-02-22?14:24??MYKTV后臺\MyKTVAdmin\FrmEditSinger.cs
?????文件???????10980??2014-02-21?08:46??MYKTV后臺\MyKTVAdmin\FrmEditSinger.Designer.cs
?????文件???????63619??2014-02-21?08:46??MYKTV后臺\MyKTVAdmin\FrmEditSinger.resx
?????文件????????3051??2014-02-27?19:34??MYKTV后臺\MyKTVAdmin\FrmLogin.cs
?????文件????????4926??2014-02-10?17:13??MYKTV后臺\MyKTVAdmin\FrmLogin.Designer.cs
?????文件????????5817??2014-02-10?17:13??MYKTV后臺\MyKTVAdmin\FrmLogin.resx
?????文件????????2109??2014-02-27?16:35??MYKTV后臺\MyKTVAdmin\FrmManage.cs
?????文件???????10764??2014-02-27?16:36??MYKTV后臺\MyKTVAdmin\FrmManage.Designer.cs
?????文件????????6188??2014-02-27?16:35??MYKTV后臺\MyKTVAdmin\FrmManage.resx
?????文件????????4399??2014-02-25?13:47??MYKTV后臺\MyKTVAdmin\FrmPhotoPath.cs
?????文件????????7224??2014-02-22?15:43??MYKTV后臺\MyKTVAdmin\FrmPhotoPath.Designer.cs
?????文件????????6025??2014-02-22?15:43??MYKTV后臺\MyKTVAdmin\FrmPhotoPath.resx
............此處省略130個文件信息