using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Data.SqlClient;
using?System.Data;
namespace?Client
{
????public?class?DBHelper
????{
????????//數據庫連接字符串
????????public?string?conString?=?“Data?Source=.;Initial?Catalog=MyKTV;Integrated?Security=True“;
????????//public?string?conString?=?“Data?Source=A14;Initial?Catalog=SuperMarket;User?ID=sang;Pwd=123“;
????????SqlConnection?conn;
????????///?

????????///?SqlConnection對象
????????///?

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

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

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

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

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

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

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



????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件??????48640??2013-01-26?11:51??KTV點歌系統\C#?AxWindowsMediaPlayer的詳細用法??.doc

?????文件??????44544??2013-05-10?18:16??KTV點歌系統\Client\Client\bin\Debug\AxInterop.WMPLib.dll

?????文件????4644352??2014-01-05?14:30??KTV點歌系統\Client\Client\bin\Debug\Client.exe

?????文件?????142848??2014-01-05?14:30??KTV點歌系統\Client\Client\bin\Debug\Client.pdb

?????文件??????11600??2014-01-05?14:38??KTV點歌系統\Client\Client\bin\Debug\Client.vshost.exe

?????文件????????490??2010-03-17?22:39??KTV點歌系統\Client\Client\bin\Debug\Client.vshost.exe.manifest

?????文件?????281600??2014-01-05?14:26??KTV點歌系統\Client\Client\bin\Debug\Interop.WMPLib.dll

?????文件???????8956??2013-05-10?18:16??KTV點歌系統\Client\Client\Client.csproj

?????文件???????1517??2013-05-02?18:18??KTV點歌系統\Client\Client\DBHelper.cs

?????文件???????9356??2013-05-11?13:36??KTV點歌系統\Client\Client\FrmAdmin.cs

?????文件??????18569??2013-05-10?19:58??KTV點歌系統\Client\Client\FrmAdmin.Designer.cs

?????文件??????11209??2013-05-10?19:58??KTV點歌系統\Client\Client\FrmAdmin.resx

?????文件??????11636??2013-05-13?11:45??KTV點歌系統\Client\Client\FrmClickBySinger.cs

?????文件??????17668??2013-05-11?13:42??KTV點歌系統\Client\Client\FrmClickBySinger.Designer.cs

?????文件????2700914??2013-05-11?13:42??KTV點歌系統\Client\Client\FrmClickBySinger.resx

?????文件???????9880??2013-05-13?12:15??KTV點歌系統\Client\Client\FrmOrderBySongName.cs

?????文件??????18839??2013-05-13?12:15??KTV點歌系統\Client\Client\FrmOrderBySongName.Designer.cs

?????文件??????11750??2013-05-13?12:15??KTV點歌系統\Client\Client\FrmOrderBySongName.resx

?????文件??????10319??2013-05-11?15:35??KTV點歌系統\Client\Client\FrmOrderBySongType.cs

?????文件??????19608??2013-05-11?14:21??KTV點歌系統\Client\Client\FrmOrderBySongType.Designer.cs

?????文件????1468044??2013-05-11?14:21??KTV點歌系統\Client\Client\FrmOrderBySongType.resx

?????文件??????11995??2013-05-11?15:35??KTV點歌系統\Client\Client\FrmOrderByWordCount.cs

?????文件??????28879??2013-05-11?14:21??KTV點歌系統\Client\Client\FrmOrderByWordCount.Designer.cs

?????文件??????11934??2013-05-11?14:21??KTV點歌系統\Client\Client\FrmOrderByWordCount.resx

?????文件???????9685??2013-05-11?15:35??KTV點歌系統\Client\Client\FrmOrderedSongList.cs

?????文件??????15593??2013-05-11?14:21??KTV點歌系統\Client\Client\FrmOrderedSongList.Designer.cs

?????文件??????11761??2013-05-11?14:21??KTV點歌系統\Client\Client\FrmOrderedSongList.resx

?????文件???????4353??2013-05-13?11:41??KTV點歌系統\Client\Client\FrmPlay.cs

?????文件???????3280??2013-05-13?11:41??KTV點歌系統\Client\Client\FrmPlay.Designer.cs

?????文件??????11905??2013-05-13?11:41??KTV點歌系統\Client\Client\FrmPlay.resx

............此處省略191個文件信息