editclient.aspx

一个简单的信息系统 系统用户管理 编辑系统用户 新增系统用户

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="editclient.aspx.cs" Inherits="editclient" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
        AutoGenerateColumns="False" BackColor="White" BorderColor="#336666" BorderStyle="Double"
        BorderWidth="3px" CellPadding="4" DataKeyNames="client_id" DataSourceID="SqlDataSource1"
        GridLines="Horizontal" Width="700px">
        <FooterStyle BackColor="White" ForeColor="#333333" />
        <Columns>
            <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
            <asp:BoundField DataField="client_id" HeaderText="客户编号" ReadOnly="True" SortExpression="client_id" />
            <asp:BoundField DataField="client_name" HeaderText="企业名称" SortExpression="client_name" />
            <asp:BoundField DataField="client_charge" HeaderText="负责人" SortExpression="client_charge" />
            <asp:BoundField DataField="client_level" HeaderText="企业级别" SortExpression="client_level" />
            <asp:BoundField DataField="address" HeaderText="企业地址" SortExpression="address" />
            <asp:BoundField DataField="email" HeaderText="E-Mail" SortExpression="email" />
            <asp:BoundField DataField="tell" HeaderText="办公电话" SortExpression="tell" />
        </Columns>
        <RowStyle BackColor="White" ForeColor="#333333" />
        <SelectedRowStyle BackColor="#339966" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#336666" ForeColor="White" HorizontalAlign="Center" />
        <HeaderStyle BackColor="#336666" Font-Bold="True" ForeColor="White" />
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:clientmanageConnectionString %>"
        DeleteCommand="delete from client WHERE client_id= @client_id"
        SelectCommand="SELECT * FROM [client]" 
        UpdateCommand="update client set client_name=@client_name,client_charge=@client_charge,client_level=@client_level,email=@email,tell=@tell,address=@address WHERE client_id= @client_id">
    </asp:SqlDataSource>
</asp:Content>