using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Web;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Data.SqlClient;
using?System.Data;

namespace?AirTicket
{
????public?partial?class?BookingInquiry?:?System.Web.UI.Page
????{
????????string?strCon?=?System.Configuration.ConfigurationManager.ConnectionStrings[“con“].ToString（）;//定義鏈接數據庫
????????SqlConnection?sqlcon;
????????SqlCommand?sqlcom;
????????protected?void?Page_Load（object?sender?EventArgs?e）
????????{
????????????if?（!IsPostBack）
????????????{
????????????????bind（）;
????????????}
????????}
????????protected?void?GridView1_RowEditing（object?sender?GridViewEditEventArgs?e）
????????{
????????????GridView1.EditIndex?=?e.NewEditIndex;
????????????bind（）;
????????}
????????//刪除
????????protected?void?GridView1_RowDeleting（object?sender?GridViewDeleteEventArgs?e）
????????{
????????????string?sqlstr?=?“delete?from?BookTicket?where?Oid=‘“?+?GridView1.DataKeys[e.RowIndex].Value.ToString（）?+?“‘“;
????????????sqlcon?=?new?SqlConnection（strCon）;
????????????sqlcom?=?new?SqlCommand（sqlstr?sqlcon）;
????????????sqlcon.Open（）;
????????????sqlcom.ExecuteNonQuery（）;
????????????sqlcon.Close（）;
????????????bind（）;
????????}

????????//更新
????????protected?void?GridView1_RowUpdating（object?sender?GridViewUpdateEventArgs?e）
????????{
????????????sqlcon?=?new?SqlConnection（strCon）;
????????????string?sqlstr?=?“update?BookTicket?set?OPlane=‘“
????????????????+?（（TextBox）（GridView1.Rows[e.RowIndex].Cells[1].Controls[0]））.Text.ToString（）.Trim（）?+?“‘OTicketype=‘“
????????????????+?（（TextBox）（GridView1.Rows[e.RowIndex].Cells[2].Controls[0]））.Text.ToString（）.Trim（）?+?“‘ObuyTime=‘“
????????????????+?（（TextBox）（GridView1.Rows[e.RowIndex].Cells[3].Controls[0]））.Text.ToString（）.Trim（）?+?“‘Ousetime=‘“
????????????????+?（（TextBox）（GridView1.Rows[e.RowIndex].Cells[4].Controls[0]））.Text.ToString（）.Trim（）?+?“‘Omoney=‘“
????????????????+?（（TextBox）（GridView1.Rows[e.RowIndex].Cells[5].Controls[0]））.Text.ToString（）.Trim（）?+?“‘?where?Oid=‘“
????????????????+?GridView1.DataKeys[e.RowIndex].Value.ToString（）?+?“‘“;
????????????sqlcom?=?new?SqlCommand（sqlstr?sqlcon）;
????????????sqlcon.Open（）;
????????????sqlcom.ExecuteNonQuery（）;
????????????sqlcon.Close（）;
????????????GridView1.EditIndex?=?-1;
????????????bind（）;
????????}

????????//取消
????????protected?void?GridView1_RowCancelingEdit（object?sender?GridViewCancelEditEventArgs?e）
????????{
????????????GridView1.EditIndex?=?-1;
????????????bind（）;
????????}
????????//綁定
????????public?void?bind（）
????????{
????????????string?sqlstr?=?“select?*?from?BookTicket“;
????????????sqlcon?=?new?SqlConnection（strCon）;
????????????SqlDataAdapter?myda?=?new?SqlDataAdapter（sqlstr?sqlcon）;
????????????DataSet?myds?=?new?DataSet（）;
????????????sqlcon.Open（）;
????????????myda.Fill（myds?“BookTicket“）;
????????????GridView1.DataSource?=?myds;
????????????GridVie

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2011-06-06?21:45??AirTicket\
?????目錄???????????0??2011-06-06?11:53??AirTicket\AirTicket\
?????文件??????567339??2011-06-06?21:45??AirTicket\AirTicket.zip
?????目錄???????????0??2011-06-06?12:20??AirTicket\AirTicket\AirTicket\
?????文件?????????917??2011-05-30?17:14??AirTicket\AirTicket\AirTicket.sln
?????文件???????77824??2011-06-06?22:58??AirTicket\AirTicket\AirTicket.suo
?????文件????????9964??2011-06-06?12:22??AirTicket\AirTicket\AirTicket\AirTicket.csproj
?????文件????????1169??2011-06-06?12:22??AirTicket\AirTicket\AirTicket\AirTicket.csproj.user
?????目錄???????????0??2011-05-31?20:24??AirTicket\AirTicket\AirTicket\App_Code\
?????目錄???????????0??2011-06-06?15:46??AirTicket\AirTicket\AirTicket\bin\
?????文件???????36864??2011-06-06?21:37??AirTicket\AirTicket\AirTicket\bin\AirTicket.dll
?????文件???????85504??2011-06-06?21:37??AirTicket\AirTicket\AirTicket\bin\AirTicket.pdb
?????文件????????3059??2011-06-06?12:18??AirTicket\AirTicket\AirTicket\BookingInquiry.aspx
?????文件????????3361??2011-06-06?12:17??AirTicket\AirTicket\AirTicket\BookingInquiry.aspx.cs
?????文件?????????818??2011-06-06?12:18??AirTicket\AirTicket\AirTicket\BookingInquiry.aspx.designer.cs
?????文件????????5674??2011-06-06?17:55??AirTicket\AirTicket\AirTicket\BookTicket.aspx
?????文件????????7028??2011-06-06?17:51??AirTicket\AirTicket\AirTicket\BookTicket.aspx.cs
?????文件????????4325??2011-06-06?17:50??AirTicket\AirTicket\AirTicket\BookTicket.aspx.designer.cs
?????文件????????4273??2011-05-30?17:19??AirTicket\AirTicket\AirTicket\Computer.aspx
?????文件?????????331??2011-05-30?17:18??AirTicket\AirTicket\AirTicket\Computer.aspx.cs
?????文件?????????805??2011-05-30?17:19??AirTicket\AirTicket\AirTicket\Computer.aspx.designer.cs
?????文件???????17680??2011-06-06?21:36??AirTicket\AirTicket\AirTicket\ConfigEstablishment.aspx
?????文件???????20527??2011-06-06?21:37??AirTicket\AirTicket\AirTicket\ConfigEstablishment.aspx.cs
?????文件???????17922??2011-06-06?21:36??AirTicket\AirTicket\AirTicket\ConfigEstablishment.aspx.designer.cs
?????目錄???????????0??2011-06-06?11:53??AirTicket\AirTicket\AirTicket\DB_51aspx\
?????目錄???????????0??2011-06-06?11:53??AirTicket\AirTicket\AirTicket\image\
?????文件????????9996??2011-05-13?12:57??AirTicket\AirTicket\AirTicket\image\20073111530369.jpg
?????文件?????????334??2011-05-13?12:57??AirTicket\AirTicket\AirTicket\image\bar.jpg
?????文件?????????290??2011-05-13?12:57??AirTicket\AirTicket\AirTicket\image\c.gif
?????文件?????????152??2011-05-13?12:57??AirTicket\AirTicket\AirTicket\image\center.gif
?????文件????????4945??2011-05-13?12:57??AirTicket\AirTicket\AirTicket\image\from.gif
............此處省略54個文件信息