lanmumanager.aspx

新闻管理后台源码,包括添加,删除,修改新闻

<%@ Page Language="C#" MasterPageFile="~/Manager.master" AutoEventWireup="true" EnableViewState ="false"  CodeFile="lanmuManager.aspx.cs" Inherits="lanmuManager" Title="栏目管理" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<table width="515" border="0" cellpadding="0" cellspacing="0">
  <!--DWLayoutTable-->
  <tr> 
    <td height="32" valign="top" style="width: 517px"><img src="images/manlanmu.png" width="512" height="32"></td>
  </tr>
  <tr> 
    <td height="32" valign="top" style="width: 517px">
        <asp:GridView ID="GridView1" runat="server" Width="507px" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="ITEMID" DataSourceID="lanmuDataSource1" CellPadding="4" ForeColor="#333333" GridLines="None" PageSize="5" OnRowDataBound="GridView1_RowDataBound" Font-Size="12px">
            <Columns>
                <asp:TemplateField HeaderText="栏目ID" InsertVisible="False" SortExpression="ITEMID"
                    Visible="False">
                    <EditItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Eval("ITEMID") %>'></asp:Label>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("ITEMID") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField ConvertEmptyStringToNull="False" HeaderText="栏目名称" SortExpression="ITEMNAME">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("ITEMNAME") %>' ValidationGroup="a"></asp:TextBox>
                        <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="TextBox1"
                            ErrorMessage="栏目名称不能为空" ValidationGroup="a"></asp:RequiredFieldValidator>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label2" runat="server" Text='<%# Bind("ITEMNAME") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField ConvertEmptyStringToNull="False" HeaderText="栏目描述" SortExpression="ITEMDESC">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("ITEMDESC") %>' ValidationGroup="a"></asp:TextBox>
                        <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="TextBox2"
                            ErrorMessage="栏目描述不能为空" ValidationGroup="a"></asp:RequiredFieldValidator>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label3" runat="server" Text='<%# Bind("ITEMDESC") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField ConvertEmptyStringToNull="False" HeaderText="栏目顺序" SortExpression="ITEMORDER">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("ITEMORDER") %>' ValidationGroup="a"></asp:TextBox>
                        <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="TextBox3"
                            ErrorMessage="栏目顺序不能为空" ValidationGroup="a"></asp:RequiredFieldValidator>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label4" runat="server" Text='<%# Bind("ITEMORDER") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField ShowHeader="False">
                    <EditItemTemplate>
                        <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="True" CommandName="Update"
                            Text="更新" ValidationGroup="a"></asp:LinkButton>
                        <asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Cancel"
                            Text="取消" ValidationGroup="a"></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="#507CD1" Font-Bold="True" ForeColor="White" />
            <RowStyle BackColor="#EFF3FB" Height="25px" />
            <EditRowStyle BackColor="#2461BF" />
            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" Height="30px" />
            <AlternatingRowStyle BackColor="White" />
        </asp:GridView>
        <asp:SqlDataSource ID="lanmuDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:news_manageConnectionString2 %>"
            DeleteCommand="DELETE FROM [t_Item] WHERE [ITEMID] = @ITEMID" InsertCommand="INSERT INTO [t_Item] ([ITEMNAME], [ITEMDESC], [ITEMORDER]) VALUES (@ITEMNAME, @ITEMDESC, @ITEMORDER)"
            SelectCommand="SELECT * FROM [t_Item]" UpdateCommand="UPDATE [t_Item] SET [ITEMNAME] = @ITEMNAME, [ITEMDESC] = @ITEMDESC, [ITEMORDER] = @ITEMORDER WHERE [ITEMID] = @ITEMID">
            <DeleteParameters>
                <asp:Parameter Name="ITEMID" Type="Int32" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="ITEMNAME" Type="String" />
                <asp:Parameter Name="ITEMDESC" Type="String" />
                <asp:Parameter Name="ITEMORDER" Type="Int32" />
                <asp:Parameter Name="ITEMID" Type="Int32" />
            </UpdateParameters>
            <InsertParameters>
                <asp:Parameter Name="ITEMNAME" Type="String" />
                <asp:Parameter Name="ITEMDESC" Type="String" />
                <asp:Parameter Name="ITEMORDER" Type="Int32" />
            </InsertParameters>
        </asp:SqlDataSource>
        &nbsp;</td>
  </tr>
  
  
</table>
</asp:Content>