DetailsView显示特定项

最新推荐文章于 2021-07-31 01:10:34 发布

hyl8218

最新推荐文章于 2021-07-31 01:10:34 发布

阅读量793

点赞数

分类专栏： ASP.NET 文章标签： asp string insert delete server

本文链接：https://blog.csdn.net/hyl8218/article/details/1545007

版权

ASP.NET 专栏收录该内容

37 篇文章 0 订阅

订阅专栏

DetailsView类的DateKey是只读的，所以不能通过他指定DetailsView的显示项。而通过SqlDataSource的FilterExpression，即可实现。

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:SqlServerConnectionString %>"
        DeleteCommand="DELETE FROM [Article] WHERE [ArticleID] = @ArticleID"
        InsertCommand="INSERT INTO [Article] ([Subject], [Tag], [Channel], [Type], [Text], [IsTopic]) VALUES (@Subject, @Tag, @Channel, @Type, @Text, @IsTopic)"
        SelectCommand="SELECT [ArticleID], [Subject], [Tag], [Channel], [Type], [Text], [IsTopic] FROM [Article] ORDER BY [ArticleID] DESC"
        UpdateCommand="UPDATE [Article] SET [Subject] = @Subject, [Tag] = @Tag, [Channel] = @Channel, [Type] = @Type, [Text] = @Text, [IsTopic] = @IsTopic WHERE [ArticleID] = @ArticleID"
        FilterExpression="ArticleID={0}" >
        <FilterParameters>
            <asp:QueryStringParameter ConvertEmptyStringToNull="true" QueryStringField="ArticleID" Type="Int32" Name="ArticleID" />
        </FilterParameters>
        <DeleteParameters>
            <asp:Parameter Name="ArticleID" Type="Int32" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="Subject" Type="String" />
            <asp:Parameter Name="Tag" Type="String" />
            <asp:Parameter Name="Channel" Type="String" />
            <asp:Parameter Name="Type" Type="String" />
            <asp:Parameter Name="Text" Type="String" />
            <asp:Parameter Name="IsTopic" Type="Boolean" />
            <asp:Parameter Name="ArticleID" Type="Int32" />
        </UpdateParameters>
        <InsertParameters>
            <asp:Parameter Name="Subject" Type="String" />
            <asp:Parameter Name="Tag" Type="String" />
            <asp:Parameter Name="Channel" Type="String" />
            <asp:Parameter Name="Type" Type="String" />
            <asp:Parameter Name="Text" Type="String" />
            <asp:Parameter Name="IsTopic" Type="Boolean" />
        </InsertParameters>
    </asp:SqlDataSource>