deluser.aspx
资源名称:yjal.rar [点击查看]
上传用户:shjujing
上传日期:2022-07-28
资源大小:11244k
文件大小:2k
源码类别:
Email客户端
开发平台:
Visual C++
- <%@ Page Language="C#" MasterPageFile="~/Admin/MasterPage.master" AutoEventWireup="true" CodeFile="deluser.aspx.cs" Inherits="Manage_deluser" Title="用户删除" %>
- <asp:Content ID="Content1" ContentPlaceHolderID="main" Runat="Server">
- <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="UID,UserName"
- DataSourceID="SqlDataSource1" BackColor="#DEBA84" BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px" CellPadding="3" CellSpacing="2" OnRowDataBound="GridView1_RowDataBound">
- <Columns>
- <asp:BoundField DataField="UID" HeaderText="用户ID" InsertVisible="False" ReadOnly="True"
- SortExpression="UID" />
- <asp:BoundField DataField="UserName" HeaderText="用户名" ReadOnly="True" SortExpression="UserName" />
- <asp:BoundField DataField="Email" HeaderText="电子邮件" SortExpression="Email" />
- <asp:CommandField ShowDeleteButton="True" />
- </Columns>
- <FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
- <RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />
- <PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />
- <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />
- <HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />
- </asp:GridView>
- <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TZroomConnectionString %>"
- SelectCommand="SELECT [UID], [UserName], [Email] FROM [U_Info]" DeleteCommand="DELETE FROM [U_Info] WHERE [UID] = @UID AND [UserName] = @UserName" InsertCommand="INSERT INTO [U_Info] ([UserName], [Email]) VALUES (@UserName, @Email)" UpdateCommand="UPDATE [U_Info] SET [Email] = @Email WHERE [UID] = @UID AND [UserName] = @UserName">
- <DeleteParameters>
- <asp:Parameter Name="UID" Type="Int32" />
- <asp:Parameter Name="UserName" Type="String" />
- </DeleteParameters>
- <UpdateParameters>
- <asp:Parameter Name="Email" Type="String" />
- <asp:Parameter Name="UID" Type="Int32" />
- <asp:Parameter Name="UserName" Type="String" />
- </UpdateParameters>
- <InsertParameters>
- <asp:Parameter Name="UserName" Type="String" />
- <asp:Parameter Name="Email" Type="String" />
- </InsertParameters>
- </asp:SqlDataSource>
- </asp:Content>