Category.ascx

（完整代码） 1KB 

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="Category.ascx.cs" Inherits="MyPetShop.Category" %>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
    DataKeyNames="CategoryId" DataSourceID="SqlDataSource1">
    <Columns>
        <asp:BoundField DataField="CategoryId" HeaderText="CategoryId" 
            InsertVisible="False" ReadOnly="True" SortExpression="CategoryId" />
        <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
    </Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConflictDetection="CompareAllValues" 
    ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
    DeleteCommand="DELETE FROM [Category] WHERE [CategoryId] = @original_CategoryId AND (([Name] = @original_Name) OR ([Name] IS NULL AND @original_Name IS NULL))" 
    InsertCommand="INSERT INTO [Category] ([Name]) VALUES (@Name)" 
    OldValuesParameterFormatString="original_{0}" 
    SelectCommand="SELECT sum( [CategoryId]), [Name] FROM [Category]" 
    UpdateCommand="UPDATE [Category] SET [Name] = @Name WHERE [CategoryId] = @original_CategoryId AND (([Name] = @original_Name) OR ([Name] IS NULL AND @original_Name IS NULL))">
    <DeleteParameters>
        <asp:Parameter Name="original_CategoryId" Type="Int32" />
        <asp:Parameter Name="original_Name" Type="String" />
    </DeleteParameters>
    <InsertParameters>
        <asp:Parameter Name="Name" Type="String" />
    </InsertParameters>
    <UpdateParameters>
        <asp:Parameter Name="Name" Type="String" />
        <asp:Parameter Name="original_CategoryId" Type="Int32" />
        <asp:Parameter Name="original_Name" Type="String" />
    </UpdateParameters>
</asp:SqlDataSource>

24 小时内免费解锁 3 个项目，之后 1 积分/个。 规则说明

AI 解读 AI

登录后可用，每次 10 积分，解读结果公开显示在下面。

还没有人解读过这个文件。