📄 userlist.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="userlist.aspx.cs" Inherits="userlist" %>
<!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>
<div style="text-align: center">
<table style="width: 590px; height: 259px">
<tr>
<td style="width: 295px; height: 21px">
查找用户名为<asp:TextBox ID="TextBox1" runat="server" Width="73px"></asp:TextBox>用户
<asp:Button ID="Button1" runat="server" Text="开始" OnClick="Button1_Click" Width="65px" />
<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/citymanage.aspx">城市列表</asp:HyperLink></td>
</tr>
<tr valign=top>
<td style="width: 295px; height: 62px">
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
DataKeyNames="ID" DataSourceID="SqlDataSource1" OnRowDeleted="GridView1_RowDeleted"
OnRowDeleting="GridView1_RowDeleting" Height="0px" Width="549px" CellPadding="4" ForeColor="#333333" GridLines="None">
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True"
SortExpression="ID" />
<asp:BoundField DataField="UID" HeaderText="UID" SortExpression="UID" />
<asp:BoundField DataField="UPower" HeaderText="UPower" SortExpression="UPower" />
<asp:BoundField DataField="UCityID" HeaderText="UCityID" SortExpression="UCityID" />
<asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />
<asp:TemplateField HeaderText="编辑与删除" ShowHeader="False">
<EditItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="True" CommandName="Update"
Text="更新"></asp:LinkButton>
<asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Cancel"
Text="取消"></asp:LinkButton>
</EditItemTemplate>
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Edit"
Text="编辑"></asp:LinkButton>
<asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Delete"
Text="删除"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<EditRowStyle BackColor="#999999" />
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:MMSConnectionString %>" DeleteCommand="DELETE FROM [Users] WHERE [ID] = @original_ID AND [UID] = @original_UID AND [UPower] = @original_UPower AND [UCityID] = @original_UCityID AND [Email] = @original_Email"
InsertCommand="INSERT INTO [Users] ([UID], [UPower], [UCityID], [Email]) VALUES (@UID, @UPower, @UCityID, @Email)"
OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [ID], [UID], [UPower], [UCityID], [Email] FROM [Users]"
UpdateCommand="UPDATE [Users] SET [UID] = @UID, [UPower] = @UPower, [UCityID] = @UCityID, [Email] = @Email WHERE [ID] = @original_ID AND [UID] = @original_UID AND [UPower] = @original_UPower AND [UCityID] = @original_UCityID AND [Email] = @original_Email">
<DeleteParameters>
<asp:Parameter Name="original_ID" Type="Int32" />
<asp:Parameter Name="original_UID" Type="String" />
<asp:Parameter Name="original_UPower" Type="Int32" />
<asp:Parameter Name="original_UCityID" Type="String" />
<asp:Parameter Name="original_Email" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="UID" Type="String" />
<asp:Parameter Name="UPower" Type="Int32" />
<asp:Parameter Name="UCityID" Type="String" />
<asp:Parameter Name="Email" Type="String" />
<asp:Parameter Name="original_ID" Type="Int32" />
<asp:Parameter Name="original_UID" Type="String" />
<asp:Parameter Name="original_UPower" Type="Int32" />
<asp:Parameter Name="original_UCityID" Type="String" />
<asp:Parameter Name="original_Email" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="UID" Type="String" />
<asp:Parameter Name="UPower" Type="Int32" />
<asp:Parameter Name="UCityID" Type="String" />
<asp:Parameter Name="Email" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
</td>
</tr>
<tr>
<td style="width: 295px">
</td>
</tr>
<tr>
<td style="width: 295px">
</td>
</tr>
</table>
</div>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -