📄 citymanage.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="citymanage.aspx.cs" Inherits="citymanage" %>
<!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>
<table width="743" height="335" border="1">
<tr align="center">
<td height="49" colspan="2">城市信息维护列表</td>
</tr>
<tr>
<td style="width: 359px; height: 393px;">
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" BackColor="White" BorderColor="#CC9966" BorderStyle="None"
BorderWidth="1px" CellPadding="4" DataKeyNames="CID" DataSourceID="SqlDataSource1"
Height="0px" Width="330px">
<FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />
<Columns>
<asp:BoundField DataField="CID" HeaderText="城市号" ReadOnly="True" SortExpression="CID" />
<asp:BoundField DataField="CName" HeaderText="城市名称" SortExpression="CName" />
<asp:BoundField DataField="CCountryNm" HeaderText="所在国家名称" SortExpression="CCountryNm" />
<asp:CommandField ShowDeleteButton="True" />
</Columns>
<RowStyle BackColor="White" ForeColor="#330099" />
<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />
<PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:MMSConnectionString %>" DeleteCommand="DELETE FROM [City] WHERE [CID] = @original_CID AND [CName] = @original_CName AND [CCountryNm] = @original_CCountryNm"
InsertCommand="INSERT INTO [City] ([CID], [CName], [CCountryNm]) VALUES (@CID, @CName, @CCountryNm)"
OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [City]"
UpdateCommand="UPDATE [City] SET [CName] = @CName, [CCountryNm] = @CCountryNm WHERE [CID] = @original_CID AND [CName] = @original_CName AND [CCountryNm] = @original_CCountryNm">
<DeleteParameters>
<asp:Parameter Name="original_CID" Type="Int32" />
<asp:Parameter Name="original_CName" Type="String" />
<asp:Parameter Name="original_CCountryNm" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="CName" Type="String" />
<asp:Parameter Name="CCountryNm" Type="String" />
<asp:Parameter Name="original_CID" Type="Int32" />
<asp:Parameter Name="original_CName" Type="String" />
<asp:Parameter Name="original_CCountryNm" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="CID" Type="Int32" />
<asp:Parameter Name="CName" Type="String" />
<asp:Parameter Name="CCountryNm" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
</td>
<td width="271" style="height: 393px"><table width="273" height="215" border="1" align="center">
<tr>
<td colspan="2"> 添加新的城市</td>
</tr>
<tr>
<td style="width: 96px"> 城市名:</td>
<td> <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 96px"> 所在国家</td>
<td> <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox></td>
</tr>
<tr align="center">
<td colspan="2">
<asp:Button ID="Button1" runat="server" Text="添加" OnClick="Button1_Click" /> </td>
</tr>
</table></td>
</tr>
<tr align="center">
<td colspan="2" style="height: 31px">
<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/userlist.aspx">进入用户例表</asp:HyperLink>
<asp:HyperLink ID="HyperLink2" runat="server" NavigateUrl="~/Default.aspx">HyperLink</asp:HyperLink></td>
</tr>
</table>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -