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

namespace?HotelManage
{
???public??class?DBHelper
????{

???????private?static?string?strConn?=?“server=.;database=hotelmanagedb;integrated?security?=true“;
????????private?static?SqlConnection?conn?=?new?SqlConnection（strConn）;

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

????????///?查詢公用方法
????????///?

????????///?
????????///?
????????///?
????????public?static?DataSet?DBQuery（string?sql?string?tableName）
????????{
????????????SqlDataAdapter?sda?=?new?SqlDataAdapter（sql?conn）;
????????????DataSet?ds?=?new?DataSet（）;
????????????sda.Fill（ds?tableName）;
????????????return?ds;
????????}

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

????????///?增刪改公用方法
????????///?

????????///?
????????///?
????????public?static?int?DBOperate（string?sql）
????????{
????????????SqlCommand?cmd?=?new?SqlCommand（sql?conn）;
????????????conn.Open（）;
????????????int?i?=?cmd.ExecuteNonQuery（）;
????????????conn.Close（）;
????????????return?i;
????????}
????}
}

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

?????文件????8038400??2012-07-02?20:11??酒店管理項目—葉菲\HotelManage\HotelManage\bin\Debug\HotelManage.exe

?????文件??????73216??2012-07-02?20:11??酒店管理項目—葉菲\HotelManage\HotelManage\bin\Debug\HotelManage.pdb

?????文件??????14328??2012-07-02?20:22??酒店管理項目—葉菲\HotelManage\HotelManage\bin\Debug\HotelManage.vshost.exe

?????文件????????490??2007-07-21?01:33??酒店管理項目—葉菲\HotelManage\HotelManage\bin\Debug\HotelManage.vshost.exe.manifest

?????文件???????1255??2012-07-02?16:39??酒店管理項目—葉菲\HotelManage\HotelManage\DBHelper.cs

?????文件???????5517??2012-07-02?18:18??酒店管理項目—葉菲\HotelManage\HotelManage\HotelManage.csproj

?????文件????2359350??2012-07-02?16:40??酒店管理項目—葉菲\HotelManage\HotelManage\img\1.bmp

?????文件??????25214??2012-07-02?16:39??酒店管理項目—葉菲\HotelManage\HotelManage\img\1.ico

?????文件????2359350??2012-07-02?16:40??酒店管理項目—葉菲\HotelManage\HotelManage\img\2.bmp

?????文件?????170972??2012-07-02?16:40??酒店管理項目—葉菲\HotelManage\HotelManage\img\3.jpg

?????文件??????37914??2012-07-02?16:40??酒店管理項目—葉菲\HotelManage\HotelManage\img\4.jpg

?????文件????1440054??2012-07-02?16:40??酒店管理項目—葉菲\HotelManage\HotelManage\img\6.bmp

?????文件?????184722??2012-07-02?16:40??酒店管理項目—葉菲\HotelManage\HotelManage\img\7.jpg

?????文件??????45781??2012-07-02?16:40??酒店管理項目—葉菲\HotelManage\HotelManage\img\8.jpg

?????文件???????1156??2012-07-02?16:39??酒店管理項目—葉菲\HotelManage\HotelManage\img\add.jpg

?????文件???????1495??2012-07-02?16:39??酒店管理項目—葉菲\HotelManage\HotelManage\img\cancel.jpg

?????文件???????1590??2012-07-02?16:39??酒店管理項目—葉菲\HotelManage\HotelManage\img\delete.jpg

?????文件???????1238??2012-07-02?16:39??酒店管理項目—葉菲\HotelManage\HotelManage\img\exit.jpg

?????文件???????1723??2012-07-02?16:39??酒店管理項目—葉菲\HotelManage\HotelManage\img\icon.ico

?????文件???????1535??2012-07-02?16:39??酒店管理項目—葉菲\HotelManage\HotelManage\img\query.jpg

?????文件???????1310??2012-07-02?16:39??酒店管理項目—葉菲\HotelManage\HotelManage\img\save.jpg

????..A.SH.?????32256??2012-07-02?20:10??酒店管理項目—葉菲\HotelManage\HotelManage\img\Thumbs.db

?????文件???????1270??2012-07-02?16:39??酒店管理項目—葉菲\HotelManage\HotelManage\img\update.jpg

?????文件???????1229??2012-07-02?19:56??酒店管理項目—葉菲\HotelManage\HotelManage\MainForm.cs

?????文件???????6069??2012-07-02?19:56??酒店管理項目—葉菲\HotelManage\HotelManage\MainForm.Designer.cs

?????文件??????44138??2012-07-02?19:56??酒店管理項目—葉菲\HotelManage\HotelManage\MainForm.resx

?????文件???????1886??2012-07-02?20:22??酒店管理項目—葉菲\HotelManage\HotelManage\obj\Debug\HotelManage.csproj.FileListAbsolute.txt

?????文件???????1650??2012-07-02?20:11??酒店管理項目—葉菲\HotelManage\HotelManage\obj\Debug\HotelManage.csproj.GenerateResource.Cache

?????文件????8038400??2012-07-02?20:11??酒店管理項目—葉菲\HotelManage\HotelManage\obj\Debug\HotelManage.exe

?????文件??????25780??2012-07-02?19:56??酒店管理項目—葉菲\HotelManage\HotelManage\obj\Debug\HotelManage.MainForm.resources

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