deluser.aspx

天织在线购物网站完整源码及文档 本网站是一套基于Web2.0思想设计、采用asp.net2.0开发的社区门户产品。它同时也是一套Web2.0全面解决方案

<%@ Page Language="C#" MasterPageFile="~/Manage/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>