editnews.aspx

来自「microsoft公司在进行ASP.NET 2.0培训课时课堂操作演示代码。」· ASPX 代码 · 共 39 行

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="EditNews.aspx.cs" Inherits="Admins_EditNews" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <asp:FormView ID="FormView1" runat="server" DataKeyNames="NewsID" DataSourceID="SqlDataSource1"
        DefaultMode="Edit">
        <EditItemTemplate>
            <br />
            Title:
            <asp:TextBox ID="TitleTextBox" runat="server" Text='<%# Bind("Title") %>'></asp:TextBox><br />
            Contents:
            <asp:TextBox ID="ContentsTextBox" runat="server" Height="174px" Text='<%# Bind("Contents") %>'
                TextMode="MultiLine" Width="424px"></asp:TextBox><br />
            CategoryId:
            <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource2"
                DataTextField="CategoryName" DataValueField="CategoryId" SelectedValue='<%# Bind("CategoryId") %>'
                Width="130px">
            </asp:DropDownList><br />
            <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
                Text="更新"></asp:LinkButton>
            <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                Text="取消"></asp:LinkButton>
        </EditItemTemplate>
    </asp:FormView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NewsDBConnectionString %>"
        SelectCommand="SELECT * FROM [NewsInfo] WHERE ([NewsID] = @NewsID)" UpdateCommand="UPDATE [NewsInfo] SET [Title] = @Title, [Contents] = @Contents,[CategoryId] = @CategoryId WHERE [NewsID] = @NewsID">
        <UpdateParameters>
            <asp:Parameter Name="Title" Type="String" />
            <asp:Parameter Name="Contents" Type="String" />
            <asp:Parameter Name="CategoryId" Type="Int32" />
            <asp:Parameter Name="NewsID" Type="Int32" />
        </UpdateParameters>
        <SelectParameters>
            <asp:QueryStringParameter Name="NewsID" QueryStringField="NID" Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:NewsDBConnectionString %>"
        SelectCommand="SELECT * FROM [Categories]"></asp:SqlDataSource>
</asp:Content>