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

public?partial?class?BuyCar?:?System.Web.UI.Page
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????if?（Session[“UserName“]?==?null）
????????{
????????????Response.Redirect（“~/Login.aspx“）;
????????}
????????else
????????{
????????????this.title?=?“買車首頁“;
????????????SqlConnection?conn?=?new?SqlConnection（）;
????????????conn.ConnectionString?=?System.Configuration.ConfigurationManager.ConnectionStrings[“Pubs“].ToString（）;
????????????string?str?=?“select?distinct?Car.*?from?CarTrade?where?Trade.OrderState=‘待交易‘?and?Trade.CarNo=Car.CarNo“;
????????????//“select?Car.*?from?CarTrade?where?Trade.OrderState=‘未交易‘?and?Trade.CarNo=Car.CarNo“;
????????????SqlDataAdapter?da?=?new?SqlDataAdapter（str?conn）;
????????????DataTable?dt?=?new?DataTable（）;
????????????da.Fill（dt）;
????????????GridView1.DataSource?=?dt;
????????????GridView1.DataBind（）;
????????}
????}
????protected?void?GridView1_PageIndexChanging（object?sender?GridViewPageEventArgs?e）
????{
????????GridView1.PageIndex?=?e.NewPageIndex;
????????GridView1.DataBind（）;
????}
????protected?void?GridView1_SelectedIndexChanged（object?sender?EventArgs?e）
????{
????????string?ID=this.GridView1.SelectedRow.Cells[1].Text.ToString（）;
????????Response.Redirect（“Details.aspx?CarNo=“+ID）;
????}
????protected?void?ButtonSearch_Click（object?sender?EventArgs?e）
????{
????????if?（TextBox1.Text?==?““）
????????{
????????????SqlConnection?conn?=?new?SqlConnection（）;
????????????conn.ConnectionString?=?System.Configuration.ConfigurationManager.ConnectionStrings[“Pubs“].ToString（）;
????????????string?str?=?“select?*?from?Car“;
????????????//“select?Car.*?from?CarTrade?where?Trade.OrderState=‘未交易‘?and?Trade.CarNo=Car.CarNo“;
????????????SqlDataAdapter?da?=?new?SqlDataAdapter（str?conn）;
????????????DataTable?dt?=?new?DataTable（）;
????????????da.Fill（dt）;
????????????GridView1.DataSource?=?dt;
????????????GridView1.DataBind（）;
????????}
????????else
????????{
????????????SqlConnection?conn?=?new?SqlConnection（）;
????????????conn.ConnectionString?=?System.Configuration.ConfigurationManager.ConnectionStrings[“Pubs“].ToString（）;
????????????string?str?=?“select?*?from?Car?where?CarName?like?‘“+TextBox1.Text.ToString（）+“%‘“;???
????????????SqlDataAdapter?da?=?new?SqlDataAdapter（str?conn）;
????????????DataTable?dt?=?new?DataTable（）;
????????????da.Fill（dt）;
????????????GridView1.DataSource?=?dt;
????????????GridView1.DataBind（）;
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2015-06-24?16:02??畢業(yè)設(shè)計文檔和代碼\
?????目錄???????????0??2015-06-24?16:00??畢業(yè)設(shè)計文檔和代碼\代碼\
?????目錄???????????0??2015-06-24?16:00??畢業(yè)設(shè)計文檔和代碼\代碼\App_Data\
?????文件?????3145728??2015-06-24?15:58??畢業(yè)設(shè)計文檔和代碼\代碼\App_Data\Car.mdf
?????文件?????1048576??2015-06-24?15:58??畢業(yè)設(shè)計文檔和代碼\代碼\App_Data\Car_log.ldf
?????文件????????2042??2015-06-16?23:24??畢業(yè)設(shè)計文檔和代碼\代碼\BuyCar.aspx
?????文件????????2754??2015-06-17?00:59??畢業(yè)設(shè)計文檔和代碼\代碼\BuyCar.aspx.cs
?????文件?????????598??2015-05-02?14:32??畢業(yè)設(shè)計文檔和代碼\代碼\ContactUs.aspx
?????文件?????????283??2015-05-02?14:16??畢業(yè)設(shè)計文檔和代碼\代碼\ContactUs.aspx.cs
?????文件?????????659??2015-06-15?20:20??畢業(yè)設(shè)計文檔和代碼\代碼\Default.aspx
?????文件?????????282??2015-05-01?19:19??畢業(yè)設(shè)計文檔和代碼\代碼\Default.aspx.cs
?????文件????????2809??2015-06-16?15:16??畢業(yè)設(shè)計文檔和代碼\代碼\Details.aspx
?????文件????????6373??2015-06-17?00:37??畢業(yè)設(shè)計文檔和代碼\代碼\Details.aspx.cs
?????文件????????1719??2015-06-15?20:17??畢業(yè)設(shè)計文檔和代碼\代碼\Login.aspx
?????文件????????5461??2015-05-30?17:37??畢業(yè)設(shè)計文檔和代碼\代碼\Login.aspx.cs
?????文件????????2300??2015-06-17?00:34??畢業(yè)設(shè)計文檔和代碼\代碼\MasterPage.master
?????文件????????1100??2015-05-29?12:12??畢業(yè)設(shè)計文檔和代碼\代碼\MasterPage.master.cs
?????文件????????1620??2015-05-28?22:50??畢業(yè)設(shè)計文檔和代碼\代碼\Register.aspx
?????文件????????2336??2015-05-28?22:52??畢業(yè)設(shè)計文檔和代碼\代碼\Register.aspx.cs
?????目錄???????????0??2015-06-24?16:00??畢業(yè)設(shè)計文檔和代碼\代碼\Seller\
?????文件????????3333??2015-06-17?10:14??畢業(yè)設(shè)計文檔和代碼\代碼\Seller\AddCar.aspx
?????文件????????4354??2015-06-17?10:14??畢業(yè)設(shè)計文檔和代碼\代碼\Seller\AddCar.aspx.cs
?????文件?????????362??2015-05-29?23:39??畢業(yè)設(shè)計文檔和代碼\代碼\Seller\Default.aspx
?????文件?????????288??2015-05-30?13:12??畢業(yè)設(shè)計文檔和代碼\代碼\Seller\Default.aspx.cs
?????文件????????2189??2015-06-12?21:48??畢業(yè)設(shè)計文檔和代碼\代碼\Seller\MasterPage.master
?????文件?????????592??2015-06-12?18:08??畢業(yè)設(shè)計文檔和代碼\代碼\Seller\MasterPage.master.cs
?????文件?????????503??2015-05-29?23:37??畢業(yè)設(shè)計文檔和代碼\代碼\Seller\styleSheet.css
?????文件????????2397??2015-06-03?15:41??畢業(yè)設(shè)計文檔和代碼\代碼\Seller\UpdateCar.aspx
?????文件????????4279??2015-06-17?10:29??畢業(yè)設(shè)計文檔和代碼\代碼\Seller\UpdateCar.aspx.cs
?????文件????????1550??2015-06-12?22:37??畢業(yè)設(shè)計文檔和代碼\代碼\Seller\UpdateSeller.aspx
?????文件????????2260??2015-06-16?23:19??畢業(yè)設(shè)計文檔和代碼\代碼\Seller\UpdateSeller.aspx.cs
............此處省略35個文件信息