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

namespace?KTVClient
{
	///?

	///?數據庫開關類
	///?

	public?class?DBHelper
	{
		public?string?strConn?=?“Data?Source=.;Initial?Catalog=MyKTV;Integrated?Security=True“;
		private?SqlConnection?conn;

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

		///?

		///?open?connection
		///?

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

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????1398??2015-11-09?14:09??KTVServer\KTV.sln
?????文件???????82432??2015-11-09?12:31??KTVServer\KTV.suo
?????文件??????113664??2015-12-14?19:58??KTVServer\KTV.v11.suo
?????目錄???????????0??2015-12-14?10:51??KTVServer\KTVClient\
?????文件??????363566??2015-11-17?12:08??KTVServer\KTVClient\12.ico
?????文件?????????187??2015-11-08?20:35??KTVServer\KTVClient\App.config
?????目錄???????????0??2015-11-08?20:36??KTVServer\KTVClient\bin\
?????目錄???????????0??2015-12-14?11:37??KTVServer\KTVClient\bin\Debug\
?????文件????????6144??2015-12-14?10:54??KTVServer\KTVClient\bin\Debug\AxInterop.QYPluginLib.dll
?????文件???????53760??2015-12-14?10:54??KTVServer\KTVClient\bin\Debug\AxInterop.WMPLib.dll
?????文件????????4088??2015-12-14?13:25??KTVServer\KTVClient\bin\Debug\FrmMain.cs
?????文件???????14962??2015-12-14?13:25??KTVServer\KTVClient\bin\Debug\FrmMain.Designer.cs
?????文件??????288419??2015-12-14?13:25??KTVServer\KTVClient\bin\Debug\FrmMain.resx
?????文件????????6812??2015-12-14?13:26??KTVServer\KTVClient\bin\Debug\FrmSongList.cs
?????文件???????16939??2015-12-14?13:26??KTVServer\KTVClient\bin\Debug\FrmSongList.Designer.cs
?????文件??????320860??2015-12-14?13:26??KTVServer\KTVClient\bin\Debug\FrmSongList.resx
?????文件????????6656??2015-12-14?10:54??KTVServer\KTVClient\bin\Debug\Interop.QYPluginLib.dll
?????文件??????330752??2015-12-14?10:54??KTVServer\KTVClient\bin\Debug\Interop.WMPLib.dll
?????文件?????6634496??2015-12-14?19:51??KTVServer\KTVClient\bin\Debug\KTVClient.exe
?????文件?????????187??2015-11-08?20:35??KTVServer\KTVClient\bin\Debug\KTVClient.exe.config
?????文件??????171520??2015-12-14?19:51??KTVServer\KTVClient\bin\Debug\KTVClient.pdb
?????文件???????22984??2015-12-14?19:57??KTVServer\KTVClient\bin\Debug\KTVClient.vshost.exe
?????文件?????????187??2015-11-08?20:35??KTVServer\KTVClient\bin\Debug\KTVClient.vshost.exe.config
?????文件?????????490??2015-07-10?19:01??KTVServer\KTVClient\bin\Debug\KTVClient.vshost.exe.manifest
?????文件???????52736??2015-12-14?10:54??KTVServer\KTVClient\bin\Debug\KTVServer.exe
?????文件??????101888??2015-12-14?10:54??KTVServer\KTVClient\bin\Debug\KTVServer.pdb
?????目錄???????????0??2015-11-08?20:36??KTVServer\KTVClient\bin\Release\
?????文件????????1057??2015-11-08?22:53??KTVServer\KTVClient\DBHelper.cs
?????文件????????4088??2015-12-14?13:25??KTVServer\KTVClient\FrmMain.cs
?????文件???????14962??2015-12-14?13:25??KTVServer\KTVClient\FrmMain.Designer.cs
?????文件??????288419??2015-12-14?13:25??KTVServer\KTVClient\FrmMain.resx
............此處省略168個文件信息