headerknowinfo.ascx

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

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="HeaderKnowInfo.ascx.cs" Inherits="UserControls_Header_HeaderKnowInfo" %>
<asp:Label ID="Label1" runat="server" Font-Bold="True" Text="知识条信息:"></asp:Label>
<asp:Button ID="BtnAddknow" runat="server" OnClick="BtnAddknow_Click" Text="添加" /><br />
<hr />
<asp:GridView ID="GvKnow" runat="server" AllowPaging="True" BackColor="White" BorderColor="#CC9966"
    BorderStyle="None" BorderWidth="1px" CellPadding="4" DataSourceID="SdsKnow" Width="100%" AutoGenerateColumns="False" AllowSorting="True" EmptyDataText="no data">
    <FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />
    <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" />
    <Columns>
        <asp:BoundField DataField="Knowledge_id" HeaderText="Knowledge_id" InsertVisible="False"
            ReadOnly="True" SortExpression="Knowledge_id" Visible="False" />
        <asp:BoundField DataField="Knowledge_title" HeaderText="标题" SortExpression="Knowledge_title" />
        <asp:BoundField DataField="Category_name" HeaderText="类别" SortExpression="Category_name" />
        <asp:BoundField DataField="Knowledge_issuetime" HeaderText="发布时间" SortExpression="Knowledge_issuetime" />
        <asp:BoundField DataField="Knowledge_accessory" HeaderText="附件" SortExpression="Knowledge_accessory" />
        <asp:HyperLinkField DataNavigateUrlFields="Knowledge_id" DataNavigateUrlFormatString="~/Web/ViewKnowDetail.aspx?Knowledge_id={0}"
            Text="查看全文" />
    </Columns>
</asp:GridView>
<asp:SqlDataSource ID="SdsKnow" runat="server" ConnectionString="<%$ ConnectionStrings:db_KnowledgeConnectionString %>" SelectCommand="SELECT tb_Knowledge.Knowledge_id,tb_Knowledge.Knowledge_issuetime, tb_Knowledge.Knowledge_title, tb_Knowledge.Knowledge_accessory, tb_Category.Category_name &#13;&#10;FROM tb_Knowledge &#13;&#10;INNER JOIN tb_Ref_know2cate ON tb_Knowledge.Knowledge_id = tb_Ref_know2cate.Knowledge_id &#13;&#10;INNER JOIN tb_Category ON tb_Category.Category_id = tb_Ref_know2cate.Category_id" ProviderName="<%$ ConnectionStrings:db_KnowledgeConnectionString.ProviderName %>"></asp:SqlDataSource>