using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Data.SqlClient;
using?System.Data;
//5-1-aspx
namespace?Tikect
{
????class?DBAccess
????{
????????public?static?SqlConnection?conn;
????????static?string?url?
????????????=?“server=.\\sqlexpress;uid=sa;pwd=sa;database=ticket“;
???
????????static?DBAccess（）
????????{
????????????conn?=?new?SqlConnection（url）;
????????}

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

????????///?更新
????????///?

????????///?
????????///?
????????public??int??update（String?sql）?{
????????????int?rows=0;
????????????try
????????????{
????????????????SqlCommand?cmd?=?new?SqlCommand（sql?conn）;
????????????????conn.Open（）;
????????????????rows?=?cmd.ExecuteNonQuery（）;
????????????}
????????????finally
????????????{
????????????????conn.Close（）;
????????????}
????????????return?rows;
????????}

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

????????///?生成數據表
????????///?

????????///?
????????///?
????????///?
????????public?DataTable?getDateSourse（string?sqlstring?tableName）
????????{
????????????SqlDataAdapter?dataAdapter?=?new?SqlDataAdapter（sql?conn）;
????????????DataTable?dt?=?new?DataTable（tableName）;
????????????dataAdapter.Fill（dt）;
????????????return?dt;
????????}
????}
}

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

?????文件?????758784??2012-01-02?21:29??機票預訂系統\王倩_計算機1086.doc

?????文件????????908??2011-12-27?09:39??機票預訂系統\AirlineTicket\Tikect.sln

????..A..H.?????18944??2011-12-30?08:11??機票預訂系統\AirlineTicket\Tikect.suo

?????文件???????3804??2011-12-27?09:39??機票預訂系統\AirlineTicket\UpgradeLog.xml

?????文件???????3348??2011-12-27?09:39??機票預訂系統\AirlineTicket\_UpgradeReport_Files\UpgradeReport.css

?????文件??????12505??2010-05-04?01:19??機票預訂系統\AirlineTicket\_UpgradeReport_Files\UpgradeReport.xslt

?????文件?????????69??2011-12-27?09:39??機票預訂系統\AirlineTicket\_UpgradeReport_Files\UpgradeReport_Minus.gif

?????文件?????????71??2011-12-27?09:39??機票預訂系統\AirlineTicket\_UpgradeReport_Files\UpgradeReport_Plus.gif

?????目錄??????????0??2012-01-01?22:27??機票預訂系統\AirlineTicket\_UpgradeReport_Files

?????文件????????144??2011-12-27?09:40??機票預訂系統\AirlineTicket\Tikect\app.config

?????文件???????1436??2011-12-27?16:28??機票預訂系統\AirlineTicket\Tikect\DBAccess.cs

?????文件???????2237??2011-12-30?07:58??機票預訂系統\AirlineTicket\Tikect\Form1.cs

?????文件???????6353??2011-12-30?07:58??機票預訂系統\AirlineTicket\Tikect\Form1.Designer.cs

?????文件??????70100??2011-12-30?07:58??機票預訂系統\AirlineTicket\Tikect\Form1.resx

?????文件???????5017??2011-12-30?08:10??機票預訂系統\AirlineTicket\Tikect\FrmMain.cs

?????文件??????24316??2011-12-29?09:11??機票預訂系統\AirlineTicket\Tikect\FrmMain.Designer.cs

?????文件???????5814??2011-12-29?09:11??機票預訂系統\AirlineTicket\Tikect\FrmMain.resx

?????文件????????494??2011-12-27?16:35??機票預訂系統\AirlineTicket\Tikect\Program.cs

?????文件???????5498??2011-12-27?10:42??機票預訂系統\AirlineTicket\Tikect\Tikect.csproj

?????文件????????452??2011-12-27?09:40??機票預訂系統\AirlineTicket\Tikect\Tikect.csproj.user

?????文件???????1164??2008-06-06?11:08??機票預訂系統\AirlineTicket\Tikect\Properties\AssemblyInfo.cs

?????文件???????2848??2011-12-27?09:40??機票預訂系統\AirlineTicket\Tikect\Properties\Resources.Designer.cs

?????文件???????5612??2008-06-06?11:08??機票預訂系統\AirlineTicket\Tikect\Properties\Resources.resx

?????文件???????1102??2011-12-27?09:40??機票預訂系統\AirlineTicket\Tikect\Properties\Settings.Designer.cs

?????文件????????249??2008-06-06?11:08??機票預訂系統\AirlineTicket\Tikect\Properties\Settings.settings

?????目錄??????????0??2012-01-01?22:27??機票預訂系統\AirlineTicket\Tikect\Properties

?????文件????????263??2008-12-30?20:48??機票預訂系統\AirlineTicket\Tikect\obj\Tikect.csproj.FileList.txt

?????文件???????1389??2009-05-25?16:14??機票預訂系統\AirlineTicket\Tikect\obj\Tikect.csproj.FileListAbsolute.txt

?????文件???????5668??2011-12-30?08:10??機票預訂系統\AirlineTicket\Tikect\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件????????590??2011-12-30?07:58??機票預訂系統\AirlineTicket\Tikect\obj\Debug\GenerateResource.read.1.tlog

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