headerkeywordinfo.ascx

可以实现图书信息的管理笑话寻和山下湖

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="HeaderKeywordInfo.ascx.cs" Inherits="UserControls_Header_HeaderKeywordInfo" %>
<asp:Label ID="LabKey" runat="server" Font-Bold="True" Text="关键字信息:"></asp:Label><br />
<hr />
<asp:GridView ID="GvKeyword" runat="server" AllowPaging="True" AllowSorting="True"
    AutoGenerateColumns="False" BackColor="White" BorderColor="#CC9966" BorderStyle="None"
    BorderWidth="1px" CellPadding="4" DataSourceID="SdsKey"
    Width="100%">
    <FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />
    <Columns>
        <asp:BoundField DataField="Keyword_id" HeaderText="ID" ReadOnly="True" SortExpression="Keyword_id" />
        <asp:BoundField DataField="Keyword_name" HeaderText="关键字名称" SortExpression="Keyword_name" />
        <asp:HyperLinkField DataNavigateUrlFields="Keyword_id" DataNavigateUrlFormatString="~/Web/shiyan.aspx?Keyword_id={0}"
            HeaderText="编辑" Target="_blank" Text="编辑" />
        <asp:CommandField ShowDeleteButton="True" />
    </Columns>
    <RowStyle BackColor="White" ForeColor="#330099" />
    <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />
    <PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />
    <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />
</asp:GridView>
<asp:SqlDataSource ID="SdsKey" runat="server" ConnectionString="<%$ ConnectionStrings:db_KnowledgeConnectionString %>"
    SelectCommand="SELECT * FROM [tb_Keyword]" ConflictDetection="CompareAllValues" DeleteCommand="DELETE FROM [tb_Keyword] WHERE [Keyword_id] = @original_Keyword_id AND [Keyword_name] = @original_Keyword_name" InsertCommand="INSERT INTO [tb_Keyword] ([Keyword_id], [Keyword_name]) VALUES (@Keyword_id, @Keyword_name)" OldValuesParameterFormatString="original_{0}" UpdateCommand="UPDATE [tb_Keyword] SET [Keyword_name] = @Keyword_name WHERE [Keyword_id] = @original_Keyword_id AND [Keyword_name] = @original_Keyword_name">
    <DeleteParameters>
        <asp:Parameter Name="original_Keyword_id" Type="String" />
        <asp:Parameter Name="original_Keyword_name" Type="String" />
    </DeleteParameters>
    <UpdateParameters>
        <asp:Parameter Name="Keyword_name" Type="String" />
        <asp:Parameter Name="original_Keyword_id" Type="String" />
        <asp:Parameter Name="original_Keyword_name" Type="String" />
    </UpdateParameters>
    <InsertParameters>
        <asp:Parameter Name="Keyword_id" Type="String" />
        <asp:Parameter Name="Keyword_name" Type="String" />
    </InsertParameters>
</asp:SqlDataSource>