?? menuxg.aspx
字號:
?<%@ Page Language="C#" AutoEventWireup="true" CodeFile="MenuXG.aspx.cs" Inherits="menu" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>無標題頁</title>
</head>
<body>
<form id="form1" runat="server">
<div style="background-image: url(3.jpg); background-repeat: no-repeat">
<br />
<asp:Label ID="Label1" runat="server" Style="font-weight: bolder; font-size: smaller;
color: darkorange; font-family: 幼圓" Text="按類別查詢" Width="88px"></asp:Label>
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="AccessDataSource1"
DataTextField="CLASSIDNAME" DataValueField="CLASSIDNAME" Width="98px">
</asp:DropDownList>
<asp:LinkButton ID="LinkButton1" runat="server" BorderStyle="Outset" PostBackUrl="~/subject.aspx"
Style="font-size: large; left: 339px; color: #6699cc; font-family: 華文琥珀; position: relative;
top: 6px; background-color: #ffff66">返回主頁</asp:LinkButton><br />
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/DB.mdb"
SelectCommand="SELECT DISTINCT [CLASSIDNAME] FROM [MENU]">
</asp:AccessDataSource>
<br />
<asp:Label ID="Label2" runat="server" Height="21px" Style="font-weight: bold; font-size: large;
text-transform: uppercase; color: #ffff33; font-family: 隸書" Text="修改菜單，請點擊選擇，并修改"
Width="293px"></asp:Label><br />
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"
DataKeyNames="ID" DataSourceID="AccessDataSource2" ForeColor="#333333" GridLines="None"
Width="563px" AllowPaging="True" AutoGenerateSelectButton="True">
<FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID" ReadOnly="True" SortExpression="ID" />
<asp:BoundField DataField="NAME" HeaderText="NAME" SortExpression="NAME" />
<asp:BoundField DataField="PRICE" HeaderText="PRICE" SortExpression="PRICE" />
<asp:BoundField DataField="CLASSID" HeaderText="CLASSID" SortExpression="CLASSID" />
<asp:BoundField DataField="SUPPLY" HeaderText="SUPPLY" SortExpression="SUPPLY" />
<asp:BoundField DataField="CLASSIDNAME" HeaderText="CLASSIDNAME" SortExpression="CLASSIDNAME" />
</Columns>
<RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
<PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource2" runat="server" DataFile="~/DB.mdb" SelectCommand="SELECT * FROM [MENU] WHERE ([CLASSIDNAME] = ?)">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" Name="CLASSIDNAME" PropertyName="SelectedValue"
Type="String" />
</SelectParameters>
</asp:AccessDataSource>
<br />
<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateDeleteButton="True"
AutoGenerateEditButton="True" AutoGenerateInsertButton="True" AutoGenerateRows="False"
BackColor="#DEBA84" BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px"
CellPadding="3" CellSpacing="2" DataKeyNames="ID" DataSourceID="AccessDataSource3"
Height="50px" OnPageIndexChanging="DetailsView1_PageIndexChanging" Width="125px" style="clear: none">
<FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
<EditRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />
<PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />
<Fields>
<asp:BoundField DataField="ID" HeaderText="ID" ReadOnly="True" SortExpression="ID" />
<asp:BoundField DataField="NAME" HeaderText="NAME" SortExpression="NAME" />
<asp:BoundField DataField="PRICE" HeaderText="PRICE" SortExpression="PRICE" />
<asp:BoundField DataField="CLASSID" HeaderText="CLASSID" SortExpression="CLASSID" />
<asp:BoundField DataField="SUPPLY" HeaderText="SUPPLY" SortExpression="SUPPLY" />
<asp:BoundField DataField="CLASSIDNAME" HeaderText="CLASSIDNAME" SortExpression="CLASSIDNAME" />
</Fields>
<HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />
</asp:DetailsView>
<br />
<br />
<asp:AccessDataSource ID="AccessDataSource3" runat="server" DataFile="~/DB.mdb" DeleteCommand="DELETE FROM [MENU] WHERE [ID] = ?"
InsertCommand="INSERT INTO [MENU] ([ID], [NAME], [PRICE], [CLASSID], [SUPPLY], [CLASSIDNAME]) VALUES (?, ?, ?, ?, ?, ?)"
SelectCommand="SELECT * FROM [MENU] WHERE ([ID] = ?)"
UpdateCommand="UPDATE [MENU] SET [NAME] = ?, [PRICE] = ?, [CLASSID] = ?, [SUPPLY] = ?, [CLASSIDNAME] = ? WHERE [ID] = ?">
<DeleteParameters>
<asp:Parameter Name="ID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="NAME" Type="String" />
<asp:Parameter Name="PRICE" Type="Single" />
<asp:Parameter Name="CLASSID" Type="String" />
<asp:Parameter Name="SUPPLY" Type="Int32" />
<asp:Parameter Name="CLASSIDNAME" Type="String" />
<asp:Parameter Name="ID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="ID" Type="Int32" />
<asp:Parameter Name="NAME" Type="String" />
<asp:Parameter Name="PRICE" Type="Single" />
<asp:Parameter Name="CLASSID" Type="String" />
<asp:Parameter Name="SUPPLY" Type="Int32" />
<asp:Parameter Name="CLASSIDNAME" Type="String" />
</InsertParameters>
<SelectParameters>
<asp:ControlParameter ControlID="GridView1" Name="ID" PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
</asp:AccessDataSource>
<br />
<br />
<br />
</div>
</form>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -