📄 updatauser.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="updatauser.aspx.cs" Inherits="Admin_updatauser" %>
<!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>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" ConflictDetection="CompareAllValues"
DataFile="~/App_Data/news.mdb" DeleteCommand="DELETE FROM [userinfo] WHERE [userID] = ? AND [username] = ? AND [pwd] = ? AND [E_mail] = ? AND [addedtime] = ?"
InsertCommand="INSERT INTO [userinfo] ( [username], [pwd], [E_mail], [addedtime]) VALUES (?, ?, ?, ?)"
OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [userinfo]"
UpdateCommand="UPDATE [userinfo] SET [username] = ?, [pwd] = ?, [E_mail] = ?, [addedtime] = ? WHERE [userID] = ? AND [username] = ? AND [pwd] = ? AND [E_mail] = ? AND [addedtime] = ?">
<DeleteParameters>
<asp:Parameter Name="original_userID" Type="Int32" />
<asp:Parameter Name="original_username" Type="String" />
<asp:Parameter Name="original_pwd" Type="String" />
<asp:Parameter Name="original_E_mail" Type="String" />
<asp:Parameter Name="original_addedtime" Type="DateTime" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="username" Type="String" />
<asp:Parameter Name="pwd" Type="String" />
<asp:Parameter Name="E_mail" Type="String" />
<asp:Parameter Name="addedtime" Type="DateTime" />
<asp:Parameter Name="original_userID" Type="Int32" />
<asp:Parameter Name="original_username" Type="String" />
<asp:Parameter Name="original_pwd" Type="String" />
<asp:Parameter Name="original_E_mail" Type="String" />
<asp:Parameter Name="original_addedtime" Type="DateTime" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="userID" Type="Int32" />
<asp:Parameter Name="username" Type="String" />
<asp:Parameter Name="pwd" Type="String" />
<asp:Parameter Name="E_mail" Type="String" />
<asp:Parameter Name="addedtime" Type="DateTime" />
</InsertParameters>
</asp:AccessDataSource>
</div>
<asp:FormView ID="FormView1" runat="server" AllowPaging="True" DataKeyNames="userID"
DataSourceID="AccessDataSource1">
<EditItemTemplate>
用户编号:
<asp:Label ID="userIDLabel1" runat="server" Text='<%# Eval("userID") %>'></asp:Label><br />
用户名:
<asp:TextBox ID="usernameTextBox" runat="server" Text='<%# Bind("username") %>'></asp:TextBox><br />
密码:
<asp:TextBox ID="pwdTextBox" runat="server" Text='<%# Bind("pwd") %>'></asp:TextBox><br />
E_mail:
<asp:TextBox ID="E_mailTextBox" runat="server" Text='<%# Bind("E_mail") %>'></asp:TextBox><br />
添加时间:
<asp:TextBox ID="addedtimeTextBox" runat="server" Text='<%# Bind("addedtime") %>'></asp:TextBox><br />
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
Text="更新"></asp:LinkButton>
<asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="取消"></asp:LinkButton>
</EditItemTemplate>
<InsertItemTemplate>
用户名:
<asp:TextBox ID="usernameTextBox" runat="server" Text='<%# Bind("username") %>'></asp:TextBox><br />
密码:
<asp:TextBox ID="pwdTextBox" runat="server" Text='<%# Bind("pwd") %>'></asp:TextBox><br />
E_mail:
<asp:TextBox ID="E_mailTextBox" runat="server" Text='<%# Bind("E_mail") %>'></asp:TextBox><br />
添加时间:
<asp:TextBox ID="addedtimeTextBox" runat="server" Text='<%# Bind("addedtime") %>'></asp:TextBox><br />
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
Text="插入"></asp:LinkButton>
<asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="取消"></asp:LinkButton>
</InsertItemTemplate>
<ItemTemplate>
用户编号:
<asp:Label ID="userIDLabel" runat="server" Text='<%# Eval("userID") %>'></asp:Label><br />
用户名:
<asp:Label ID="usernameLabel" runat="server" Text='<%# Bind("username") %>'></asp:Label><br />
密码:
<asp:Label ID="pwdLabel" runat="server" Text='<%# Bind("pwd") %>'></asp:Label><br />
E_mail:
<asp:Label ID="E_mailLabel" runat="server" Text='<%# Bind("E_mail") %>'></asp:Label><br />
添加时间:
<asp:Label ID="addedtimeLabel" runat="server" Text='<%# Bind("addedtime") %>'></asp:Label><br />
<asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit"
Text="编辑"></asp:LinkButton>
<asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete"
Text="删除"></asp:LinkButton>
<asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New"
Text="新建"></asp:LinkButton>
</ItemTemplate>
<HeaderTemplate>
管理用户信息
</HeaderTemplate>
</asp:FormView>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -