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

namespace?MyKTVClient
{
????class?DBHelper
????{
????????//連接字符串
????????private?string?conStr?=?@“Data?Source=LUKVHTGSO9RY6JV\SQLEXPRESS;Initial?Catalog=MyKTV;Integrated?Security=True“;
????????//連接對象
????????private?SqlConnection?conn;

????????public?SqlConnection?Conn
????????{
????????????get
????????????{
????????????????if?（conn?==?null）
????????????????{
????????????????????conn?=?new?SqlConnection（conStr）;
????????????????}
????????????????return?conn;

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

????????}

????????//打開連接
????????public?void?OpenConn（）
????????{
????????????if?（this.Conn.State?==?System.Data.ConnectionState.Closed）
????????????{
????????????????this.Conn.Open（）;
????????????}
????????????else?if?（this.Conn.State?==?System.Data.ConnectionState.Broken）
????????????{
????????????????this.Conn.Close（）;
????????????????this.Conn.Open（）;
????????????}
????????}


????????//關閉連接
????????public?void?CloseConn（）
????????{
????????????if?（this.Conn.State?==?System.Data.ConnectionState.Open?||?this.Conn.State?==?System.Data.ConnectionState.Broken）
????????????{
????????????????this.Conn.Close（）;
????????????}
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-12-20?15:16??MyKTV\
?????目錄???????????0??2012-12-20?14:39??MyKTV\MyKTVClient前臺\
?????目錄???????????0??2012-12-20?14:35??MyKTV\MyKTVClient前臺\MyKTVClient\
?????文件????????1338??2012-12-19?23:31??MyKTV\MyKTVClient前臺\MyKTVClient\DBHelper.cs
?????文件???????24874??2012-12-20?07:41??MyKTV\MyKTVClient前臺\MyKTVClient\FrmMain.Designer.cs
?????文件????????5689??2012-12-20?07:41??MyKTV\MyKTVClient前臺\MyKTVClient\FrmMain.cs
?????文件?????1195843??2012-12-20?07:41??MyKTV\MyKTVClient前臺\MyKTVClient\FrmMain.resx
?????文件???????16476??2012-12-20?07:38??MyKTV\MyKTVClient前臺\MyKTVClient\FrmOrderBySinger.Designer.cs
?????文件????????3804??2012-12-20?07:38??MyKTV\MyKTVClient前臺\MyKTVClient\FrmOrderBySinger.cs
?????文件?????1656581??2012-12-20?07:38??MyKTV\MyKTVClient前臺\MyKTVClient\FrmOrderBySinger.resx
?????文件???????11835??2012-12-20?07:41??MyKTV\MyKTVClient前臺\MyKTVClient\FrmOrderBySongList.Designer.cs
?????文件????????4199??2012-12-20?07:42??MyKTV\MyKTVClient前臺\MyKTVClient\FrmOrderBySongList.cs
?????文件?????1070083??2012-12-20?07:41??MyKTV\MyKTVClient前臺\MyKTVClient\FrmOrderBySongList.resx
?????文件???????10660??2012-12-18?10:01??MyKTV\MyKTVClient前臺\MyKTVClient\FrmOrderBySongName.Designer.cs
?????文件????????2851??2012-12-18?10:02??MyKTV\MyKTVClient前臺\MyKTVClient\FrmOrderBySongName.cs
?????文件?????1294470??2012-12-18?10:01??MyKTV\MyKTVClient前臺\MyKTVClient\FrmOrderBySongName.resx
?????文件???????14089??2012-12-19?15:42??MyKTV\MyKTVClient前臺\MyKTVClient\FrmOrderBySongType.Designer.cs
?????文件????????2534??2012-12-19?15:42??MyKTV\MyKTVClient前臺\MyKTVClient\FrmOrderBySongType.cs
?????文件?????2176449??2012-12-19?15:42??MyKTV\MyKTVClient前臺\MyKTVClient\FrmOrderBySongType.resx
?????文件???????11239??2012-12-19?15:32??MyKTV\MyKTVClient前臺\MyKTVClient\FrmOrderByWordCount.Designer.cs
?????文件????????2837??2012-12-19?15:32??MyKTV\MyKTVClient前臺\MyKTVClient\FrmOrderByWordCount.cs
?????文件?????1452789??2012-12-19?15:32??MyKTV\MyKTVClient前臺\MyKTVClient\FrmOrderByWordCount.resx
?????文件???????14879??2012-12-19?20:56??MyKTV\MyKTVClient前臺\MyKTVClient\FrmPlay.Designer.cs
?????文件????????5851??2012-12-19?20:56??MyKTV\MyKTVClient前臺\MyKTVClient\FrmPlay.cs
?????文件?????1968640??2012-12-19?20:56??MyKTV\MyKTVClient前臺\MyKTVClient\FrmPlay.resx
?????文件???????12386??2012-12-18?12:20??MyKTV\MyKTVClient前臺\MyKTVClient\FrmSongList.Designer.cs
?????文件????????2827??2012-12-18?12:22??MyKTV\MyKTVClient前臺\MyKTVClient\FrmSongList.cs
?????文件??????875587??2012-12-18?12:20??MyKTV\MyKTVClient前臺\MyKTVClient\FrmSongList.resx
?????文件?????????417??2012-12-19?14:35??MyKTV\MyKTVClient前臺\MyKTVClient\KTVUtil.cs
?????文件????????9265??2012-12-19?21:34??MyKTV\MyKTVClient前臺\MyKTVClient\MyKTVClient.csproj
?????文件????????1793??2012-12-17?00:29??MyKTV\MyKTVClient前臺\MyKTVClient\PlayList.cs
............此處省略137個文件信息