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

public?partial?class?admin?:?System.Web.UI.Page
{
????SqlConnection?sqlCn;
????SqlCommand?sqlCm;
????SqlDataAdapter?sqlDa;
????DataSet?ds?=?new?DataSet（）;

????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????sqlCn?=?new?SqlConnection（）;
????????sqlCm?=?new?SqlCommand（）;
????????sqlCn.ConnectionString?=?ConfigurationManager.AppSettings[“sqlCnStr“].ToString（）;
????????sqlCm.Connection?=?sqlCn;
????????if?（!IsPostBack）
????????????displayCustomer（）;
????}
????protected?void?dg_edit（object?sender?DataGridCommandEventArgs?e）
????{
????????Label1.Text?=?e.Item.Cells[0].Text;
????????TextBox1.Text?=?e.Item.Cells[1].Text;
????????TextBox2.Text?=?e.Item.Cells[2].Text;
????????TextBox3.Text?=?e.Item.Cells[3].Text;
????????TextBox4.Text?=?e.Item.Cells[4].Text;
????????TextBox5.Text?=?e.Item.Cells[5].Text;
????????TextBox6.Text?=?e.Item.Cells[6].Text;
????}
????protected?void?dg_delete（object?sender?DataGridCommandEventArgs?e）
????{
????????sqlCn.Open（）;
????????sqlCm.CommandText?=?“delete?from?Customer?where?cID=‘“?+?e.Item.Cells[0].Text?+?“‘“;
????????if?（sqlCm.ExecuteNonQuery（）?>?0）
????????????Response.Write（“ript>alert（‘delete?ok‘）;ript>“）;
????????else
????????????Response.Write（“ript>alert（‘delete?fail‘）ript>“）;
????????sqlCn.Close（）;
????????displayCustomer（）;
????}
????private?void?displayCustomer（）
????{
????????sqlCn.Open（）;
????????sqlCm.CommandText?=?“select?*?from?Customer“;
????????sqlDa?=?new?SqlDataAdapter（sqlCm）;
????????sqlDa.Fill（ds?“myCustomer“）;
????????sqlCn.Close（）;

????????DataGrid1.DataSource?=?ds.Tables[“myCustomer“];
????????DataGrid1.DataBind（）;
????}
????protected?void?Button1_Click（object?sender?EventArgs?e）
????{
????????sqlCn.Open（）;
????????sqlCm.CommandText?=?“update?Customer?set?cName=‘“?+?TextBox1.Text?+?“‘?cPassword=‘“?+?TextBox2.Text?+?“‘cSex=‘“?+?TextBox3.Text?+?“‘?cDoB=‘“?+?TextBox4.Text?+?“‘?cAddress=‘“?+?TextBox5.Text?+?“‘?cTel=‘“?+?TextBox6.Text?+?“‘?where?cID=‘“?+?Label1.Text?+?“‘“;
????????if?（sqlCm.ExecuteNonQuery（）?>?0）
????????????Response.Write（“ript>alert（‘update?ok‘）;ript>“）;
????????else
????????????Response.Write（“ript>alert（‘update?fail‘）ript>“）;
????????sqlCn.Close（）;
????????displayCustomer（）;
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-04-10?23:30??新建文件夾\
?????目錄???????????0??2017-06-30?22:44??新建文件夾\數據庫\
?????文件?????2359296??2017-06-30?22:00??新建文件夾\數據庫\myOrderfood.mdf
?????文件??????589824??2017-06-30?22:00??新建文件夾\數據庫\myOrderfood_log.LDF
?????目錄???????????0??2017-06-30?22:43??新建文件夾\網上訂餐\
?????文件????????4805??2017-06-30?17:25??新建文件夾\網上訂餐\admin.aspx
?????文件????????2508??2017-06-29?19:58??新建文件夾\網上訂餐\admin.aspx.cs
?????文件????????5520??2017-06-30?17:23??新建文件夾\網上訂餐\AllfoodManagement.aspx
?????文件????????4166??2017-06-30?16:34??新建文件夾\網上訂餐\AllfoodManagement.aspx.cs
?????文件????????2565??2017-06-30?13:04??新建文件夾\網上訂餐\Cdesserts.aspx
?????文件????????1065??2017-06-30?13:09??新建文件夾\網上訂餐\Cdesserts.aspx.cs
?????文件????????2560??2017-06-30?13:09??新建文件夾\網上訂餐\Cdrink.aspx
?????文件????????1058??2017-06-30?13:09??新建文件夾\網上訂餐\Cdrink.aspx.cs
?????文件????????2543??2017-06-30?13:11??新建文件夾\網上訂餐\Cmainfood.aspx
?????文件????????1061??2017-06-30?13:11??新建文件夾\網上訂餐\Cmainfood.aspx.cs
?????文件????????2537??2017-06-30?13:13??新建文件夾\網上訂餐\Csnack.aspx
?????文件????????1058??2017-06-30?13:13??新建文件夾\網上訂餐\Csnack.aspx.cs
?????文件????????2504??2017-06-30?19:49??新建文件夾\網上訂餐\Default.aspx
?????文件????????1036??2017-06-30?00:31??新建文件夾\網上訂餐\Default.aspx.cs
?????文件????????5416??2017-06-30?17:29??新建文件夾\網上訂餐\desserts.aspx
?????文件????????4197??2017-06-30?10:46??新建文件夾\網上訂餐\desserts.aspx.cs
?????文件????????2625??2017-06-30?14:36??新建文件夾\網上訂餐\display.aspx
?????文件????????1900??2017-06-30?16:00??新建文件夾\網上訂餐\display.aspx.cs
?????文件????????5413??2017-06-30?17:29??新建文件夾\網上訂餐\drink.aspx
?????文件????????4152??2017-06-30?12:32??新建文件夾\網上訂餐\drink.aspx.cs
?????文件????????5540??2017-06-30?17:23??新建文件夾\網上訂餐\foodMenagement.aspx
?????文件????????4149??2017-06-30?00:04??新建文件夾\網上訂餐\foodMenagement.aspx.cs
?????目錄???????????0??2017-06-30?22:43??新建文件夾\網上訂餐\images\
?????文件?????1289955??2017-06-12?21:50??新建文件夾\網上訂餐\images\1.jpeg
?????文件??????266406??2017-06-30?17:04??新建文件夾\網上訂餐\images\1.jpg
?????文件??????105607??2017-06-30?17:10??新建文件夾\網上訂餐\images\10.jpg
............此處省略85個文件信息