file.aspx

计算机实验课在线答疑系统 09年毕业设计

<%@ Page Language="C#" MasterPageFile="~/admin/adminMasterPage.master" AutoEventWireup="true" CodeFile="file.aspx.cs" Inherits="file" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <br />
    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
        DataSourceID="SqlDataSource1" DataKeyNames="id" AutoGenerateColumns="False" HorizontalAlign="Center" CellPadding="4" ForeColor="#333333" GridLines="None">
        <Columns>
            <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True"
                SortExpression="id" />
            <asp:BoundField DataField="Send_FileName" HeaderText="文件名称" SortExpression="Send_FileName" />
            <asp:BoundField DataField="Send_File" HeaderText="文件路径" SortExpression="Send_File" />
            <asp:BoundField DataField="Send_UserName" HeaderText="上传者" SortExpression="Send_UserName" />
            <asp:BoundField DataField="Send_Time" HeaderText="上传时间" SortExpression="Send_Time" />
            <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ButtonType="Button" />
        </Columns>
        <RowStyle HorizontalAlign="Left" BackColor="#F7F6F3" ForeColor="#333333" />
        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <EditRowStyle BackColor="#999999" />
        <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
        <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
        <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
        DeleteCommand="DELETE FROM [SendFile] WHERE [id] = @id" InsertCommand="INSERT INTO [SendFile] ([Accept_UserName], [Send_UserName], [Send_File], [Send_Time], [Send_FileName]) VALUES (@Accept_UserName, @Send_UserName, @Send_File, @Send_Time, @Send_FileName)"
        SelectCommand="SELECT * FROM [SendFile] ORDER BY [Send_Time] DESC" UpdateCommand="UPDATE [SendFile] SET [Accept_UserName] = @Accept_UserName, [Send_UserName] = @Send_UserName, [Send_File] = @Send_File, [Send_Time] = @Send_Time, [Send_FileName] = @Send_FileName WHERE [id] = @id">
        <DeleteParameters>
            <asp:Parameter Name="id" Type="Int32" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="Accept_UserName" Type="String" />
            <asp:Parameter Name="Send_UserName" Type="String" />
            <asp:Parameter Name="Send_File" Type="String" />
            <asp:Parameter Name="Send_Time" Type="String" />
            <asp:Parameter Name="Send_FileName" Type="String" />
            <asp:Parameter Name="id" Type="Int32" />
        </UpdateParameters>
        <InsertParameters>
            <asp:Parameter Name="Accept_UserName" Type="String" />
            <asp:Parameter Name="Send_UserName" Type="String" />
            <asp:Parameter Name="Send_File" Type="String" />
            <asp:Parameter Name="Send_Time" Type="String" />
            <asp:Parameter Name="Send_FileName" Type="String" />
        </InsertParameters>
    </asp:SqlDataSource>
</asp:Content>