using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;//聯系到數據庫查詢操作必須既如此條語句

namespace?Fly
{
????public?partial?class?BookTicketFrom?:?Form
????{
????????public?BookTicketFrom（）
????????{
????????????InitializeComponent（）;
????????}

????????//聲明并初始化DataSet
????????private?DataSet?dataSet?=?new?DataSet（）;
????????//聲明DataReader
????????private?SqlDataAdapter?dataAdapter;

????????//窗體加載時，在DGV上顯示的數據
????????private?void?BookTicketFrom_Load（object?sender?EventArgs?e）
????????{
????????????//執行查詢的sql語句
????????????string?sql?=?“Select?FlightNOLeaveCityDestinationLeaveTimeid?From?TicketInfo“;
????????????//好比用車子把sql語句運輸到數據庫中去
????????????dataAdapter?=?new?SqlDataAdapter（sql?db.connection）;
????????????//然后再用車子把檢索到的數據集綁定到DGV所要顯示的表上
????????????dataAdapter.Fill（dataSet?“TicketInfo“）;
????????????//指定DGV的數據源
????????????dgv.DataSource?=?dataSet.Tables[“TicketInfo“];
????????}

????????//單擊查詢按鈕
????????private?void?btn查詢_Click（object?sender?EventArgs?e）
????????{
????????????try
????????????{
????????????????//首先判斷是否已經輸入了所要查詢的‘出發地’
????????????????if?（txt出發地.Text?==?““）
????????????????{
????????????????????MessageBox.Show（“請輸入您要查詢的出發地！“?“操作提示“?MessageBoxButtons.OK?MessageBoxIcon.Warning）;
????????????????}
????????????????//繼續判斷是否已經輸入了所要查詢的‘目的地’
????????????????else?if?（txt目的地.Text?==?““）
????????????????{
????????????????????MessageBox.Show（“請輸入您要查詢的目的地！“?“操作提示“?MessageBoxButtons.OK?MessageBoxIcon.Warning）;
????????????????}
????????????????//如果確定已經輸入了查詢信息，則執行如下語句
????????????????else
????????????????{
????????????????????//執行sql先查詢數據庫中是否存有所輸入的信息
????????????????????string?sq?=?string.Format（“select?count（*）?from?TicketInfo?where?LeaveCity=‘{0}‘and?Destination=‘{1}‘“?txt出發地.Text?txt目的地.Text）;
????????????????????//創建SqlCommand
????????????????????SqlCommand?cmd?=?new?SqlCommand（sq?db.connection）;
????????????????????//打開數據庫連接
????????????????????db.connection.Open（）;
????????????????????//是否檢索到了數據并用a接收
????????????????????int?a?=?（int）cmd.ExecuteScalar（）;
????????????????????//ExecuteScalar（）;//檢索不到數據則返回0
????????????????????//MessageBox.Show（a.ToString（））;//測試有沒有查到了數值
????????????????????if?（a?==?0）
????????????????????{
????????????????????????MessageBox.Show（“當前查詢中暫無兩地航班信息！“?“溫馨提示“?MessageBoxButtons.OK?MessageBoxIcon.Information）;
????????????????????}
????????????????????else
????????????????????{
????????????????????????//先清空DGV中原有的數據
????????????????????????dataSet.Tables[“TicketInfo“].Clear（）;
????????????????????????//重新查找
????????????????????????string?sql?=?string.Format（“select?id?FlightNOLeaveCityDestinationLeaveTime?from?TicketInfo?where?LeaveCity=‘{0}‘?and?Destination=‘{1}‘“?txt出發地.Text?txt目的地.Text）;
????????????????????????//定義DataAdapter
????????????????????????dataAdapter?=?new?SqlDataAdapter（sql?db.

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

?????文件????3145728??2008-11-11?17:53??航班票查詢\data\data\Ticket.mdf

?????文件????1048576??2008-11-11?17:53??航班票查詢\data\data\Ticket_log.ldf

?????文件??????86016??2008-11-14?17:30??航班票查詢\Fly\Fly\bin\Debug\Fly.exe

?????文件??????32256??2008-11-14?17:30??航班票查詢\Fly\Fly\bin\Debug\Fly.pdb

?????文件???????5632??2005-11-11?22:25??航班票查詢\Fly\Fly\bin\Debug\Fly.vshost.exe

?????文件??????12882??2008-11-14?17:31??航班票查詢\Fly\Fly\BookTicketFrom.cs

?????文件??????28798??2008-11-14?17:21??航班票查詢\Fly\Fly\BookTicketFrom.Designer.cs

?????文件???????6738??2008-11-14?17:21??航班票查詢\Fly\Fly\BookTicketFrom.resx

?????文件????????331??2008-11-12?17:26??航班票查詢\Fly\Fly\db.cs

?????文件???????3577??2008-11-12?20:52??航班票查詢\Fly\Fly\Fly.csproj

?????文件????????180??2008-11-14?17:21??航班票查詢\Fly\Fly\obj\Debug\Fly.BookTicketFrom.resources

?????文件????????988??2008-11-14?17:21??航班票查詢\Fly\Fly\obj\Debug\Fly.csproj.GenerateResource.Cache

?????文件??????86016??2008-11-14?17:30??航班票查詢\Fly\Fly\obj\Debug\Fly.exe

?????文件??????32256??2008-11-14?17:30??航班票查詢\Fly\Fly\obj\Debug\Fly.pdb

?????文件??????50436??2008-11-12?20:52??航班票查詢\Fly\Fly\obj\Debug\Fly.Properties.Resources.resources

?????文件???????5120??2008-11-12?20:49??航班票查詢\Fly\Fly\obj\Debug\TempPE\Properties.Resources.Designer.cs.dll

?????文件????????249??2008-11-14?17:31??航班票查詢\Fly\Fly\obj\Fly.csproj.FileList.txt

?????文件????????471??2008-11-12?16:38??航班票查詢\Fly\Fly\Program.cs

?????文件???????1214??2008-11-12?16:37??航班票查詢\Fly\Fly\Properties\AssemblyInfo.cs

?????文件???????3617??2008-11-12?20:49??航班票查詢\Fly\Fly\Properties\Resources.Designer.cs

?????文件???????6718??2008-11-12?20:49??航班票查詢\Fly\Fly\Properties\Resources.resx

?????文件???????1086??2008-11-12?16:37??航班票查詢\Fly\Fly\Properties\Settings.Designer.cs

?????文件????????249??2008-11-12?16:37??航班票查詢\Fly\Fly\Properties\Settings.settings

?????文件???????7068??2008-11-12?20:49??航班票查詢\Fly\Fly\Resources\listbackground.jpg

?????文件???????7068??2008-11-12?20:12??航班票查詢\Fly\Fly\Resources\listbackground.png

?????文件??????34816??2008-11-12?20:13??航班票查詢\Fly\Fly\Resources\p1（163）.gif

?????文件????????898??2008-11-12?16:37??航班票查詢\Fly\Fly.sln

????..A..H.?????15360??2008-11-14?17:31??航班票查詢\Fly\Fly.suo

?????目錄??????????0??2008-11-12?16:38??航班票查詢\Fly\Fly\obj\Debug\Refactor

?????目錄??????????0??2008-11-12?20:13??航班票查詢\Fly\Fly\obj\Debug\TempPE

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