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

namespace?MyKTVClientUnder
{
????public?class?DBHelp
????{
????????private?const?string?CONNSTR?=?“Data?Source=LAPTOP-4TBLDJBJ\\SQLEXPRESS;Initial?Catalog=MyKTV4;Integrated?Security=True“;

????????private?static?SqlConnection?connection?=?new?SqlConnection（CONNSTR）;
????????///?

????????///?執行增刪改調用此方法傳入你構造好的Sql語句
????????///?

????????///?
????????///?
????????public?static??int?ExecuteNonQuery（string?sql）
????????{
????????????int?rows?=?-1;??//-1表示失敗的情況
????????????SqlCommand?cmd?=?new?SqlCommand（sql?connection）;
????????????try
????????????{
????????????????connection.Open（）;
????????????????rows?=?cmd.ExecuteNonQuery（）;
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????throw?ex;??//拋出異常
????????????}
????????????finally
????????????{
????????????????connection.Close（）;
????????????}
???????
????????????return?rows;

????????}
????????///?

????????///?返回首行首列的值
????????///?

????????///?
????????///?
????????public?static?object?ExecuteScalar（string?sql）
????????{
????????????object?obj?=?null;??//-1表示失敗的情況
????????????SqlCommand?cmd?=?new?SqlCommand（sql?connection）;
????????????try
????????????{
????????????????connection.Open（）;
????????????????obj?=?cmd.ExecuteScalar（）;
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????throw?ex;??//拋出異常
????????????}
????????????finally
????????????{
????????????????connection.Close（）;
????????????}

????????????return?obj;

????????}

????????public?static?SqlDataReader?ExecuteReader（string?sql）
????????{
????????????SqlDataReader?reader?=?null;
????????????SqlCommand?cmd?=?new?SqlCommand（sql?connection）;
????????????try
????????????{
????????????????connection.Open（）;
????????????????//當外部關閉該reader時關閉該對象關聯的連接對象
????????????????reader?=?cmd.ExecuteReader（CommandBehavior.CloseConnection）;
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????throw?ex;??//拋出異常
????????????}
????????????
????????????return?reader;
????????}

????????public?static?DataSet?GetDataSet（string?sql）
????????{
????????????DataSet?ds?=?new?DataSet（）;
????????????SqlDataAdapter?sda?=?new?SqlDataAdapter（sql?CONNSTR）;
????????????sda.Fill（ds）;
????????????return?ds;
????????}
????}
????}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-01-20?16:53??MyKTV系統\
?????文件??????123546??2018-01-13?10:48??MyKTV系統\0020033081960358_b.jpg
?????文件??????109196??2018-01-03?16:31??MyKTV系統\01E58PICwrk_1024.jpg
?????文件??????214502??2018-01-03?21:26??MyKTV系統\01E58PICwrk_10245.jpg
?????文件?????1560406??2018-01-15?13:47??MyKTV系統\1515.PNG
?????文件??????866849??2018-01-03?16:15??MyKTV系統\15764976-fd35d93533a96c6444d2eda7531ba719.jpg
?????文件??????804798??2018-01-03?22:29??MyKTV系統\15790270-f5f34ccb6deb39784175a419f2ffb77c.jpg
?????文件???????92665??2018-01-03?22:37??MyKTV系統\18558PICgGY_1024.jpg
?????文件??????168285??2018-01-03?22:24??MyKTV系統\19A58PICpbv_1024.jpg
?????文件?????1529643??2018-01-03?21:32??MyKTV系統\20150502224055_8aUQc.jpeg
?????文件???????17882??2018-01-13?10:57??MyKTV系統\241f95cad1c8a78682cd1ab66d09c93d71cf50a6.jpg
?????文件???????24835??2018-01-03?16:33??MyKTV系統\2531170_021920538000_2.jpg
?????文件??????115835??2018-01-03?16:03??MyKTV系統\28s58PICNJ3_1024.jpg
?????文件???????11073??2018-01-04?14:07??MyKTV系統\2fdda3cc7cd98d10250072d52a3fb80e7aec9079.jpg
?????文件???????98635??2018-01-13?10:47??MyKTV系統\4480_P_1378352374683.jpg
?????文件??????237486??2018-01-13?10:47??MyKTV系統\499_P_1440292844086.jpg
?????文件???????89375??2018-01-10?09:55??MyKTV系統\5ab5c9ea15ce36d3486a041530f33a87e950b1ad.jpg
?????文件???????56666??2018-01-03?21:29??MyKTV系統\635931321279751738.png
?????文件???????68219??2018-01-03?22:37??MyKTV系統\77b1OOOPICb2.jpg
?????文件???????23637??2018-01-03?21:32??MyKTV系統\7aec54e736d12f2ea590c75645c2d5628535686a.jpg
?????文件??????329817??2018-01-10?22:09??MyKTV系統\84ec490ff62c4902b279ce50a07b44aa_th.gif
?????文件???????18723??2018-01-13?10:42??MyKTV系統\86d6277f9e2f0708b8bf6136e324b899a901f24a.jpg
?????文件??????701466??2018-01-13?10:45??MyKTV系統\944_P_1426644125212.png
?????文件?????2810960??2018-01-12?16:45??MyKTV系統\MyKTV.pptx
?????文件?????3145728??2018-01-12?17:34??MyKTV系統\MyKTV4.mdf
?????文件?????1048576??2018-01-12?17:34??MyKTV系統\MyKTV4_log.ldf
?????目錄???????????0??2018-01-20?16:53??MyKTV系統\MyKTVClient4\
?????文件?????????187??2018-01-02?17:22??MyKTV系統\MyKTVClient4\App.config
?????文件????????2754??2018-01-08?14:30??MyKTV系統\MyKTVClient4\DBHelp.cs
?????文件????????2747??2018-01-15?12:49??MyKTV系統\MyKTVClient4\DBHelper.cs
?????文件????????4865??2018-01-15?14:55??MyKTV系統\MyKTVClient4\FrmAbout.Designer.cs
............此處省略275個文件信息