1<%...@ Page Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="Test.aspx.cs"
 2    Inherits="DataSourceControl_Test" Title="数据源控件测试" %>
 3
 4<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
 5    <p>
 6        <asp:Label ID="lblMsg" runat="server" ForeColor="red" />
 7    </p>
 8    <table cellpadding="6">
 9        <tr>
10            <td valign="top">
11                <asp:DetailsView ID="DetailsView1" runat="server" AllowPaging="True" AutoGenerateRows="False"
12                    DataKeyNames="Id" DataSourceID="ObjectDataSource1" Height="50px" Width="125px" OnItemInserted="DetailsView1_ItemInserted">
13                    <Fields>
14                        <asp:BoundField DataField="Id" HeaderText="Id" InsertVisible="False" ReadOnly="True"
15                            SortExpression="Id" />
16                        <asp:BoundField DataField="ParentId" HeaderText="ParentId" SortExpression="ParentId" />
17                        <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
18                        <asp:BoundField DataField="PublishTime" HeaderText="PublishTime" SortExpression="PublishTime"
19                            InsertVisible="False" />
20                        <asp:BoundField DataField="Price" HeaderText="Price" SortExpression="Price" DataFormatString="{0:c}" HtmlEncode="False" />
21                        <asp:CheckBoxField DataField="IsGood" HeaderText="IsGood" SortExpression="IsGood" />
22                        <asp:CommandField ShowInsertButton="True" />
23                    </Fields>
24                </asp:DetailsView>
25            </td>
26            <td valign="top">
27                <asp:DetailsView ID="DetailsView2" runat="server" Height="50px" Width="125px" AutoGenerateRows="False" DataKeyNames="Id" DataSourceID="ObjectDataSource2">
28                    <Fields>
29                        <asp:BoundField DataField="Id" HeaderText="Id" InsertVisible="False" ReadOnly="True"
30                            SortExpression="Id" />
31                        <asp:BoundField DataField="ParentId" HeaderText="ParentId" SortExpression="ParentId" />
32                        <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
33                        <asp:BoundField DataField="PublishTime" HeaderText="PublishTime" SortExpression="PublishTime" />
34                        <asp:BoundField DataField="Price" HeaderText="Price" SortExpression="Price" DataFormatString="{0:c}" HtmlEncode="false" />
35                        <asp:CheckBoxField DataField="IsGood" HeaderText="IsGood" SortExpression="IsGood" />
36                    </Fields>
37                </asp:DetailsView>
38            </td>
39        </tr>
40    </table>
41    <p>
42        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="Id"
43            DataSourceID="ObjectDataSource1" AllowPaging="True" AllowSorting="True" OnRowUpdating="GridView1_RowUpdating">
44            <Columns>
45                <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowSelectButton="True" />
46                <asp:BoundField DataField="Id" HeaderText="Id" InsertVisible="False" ReadOnly="True"
47                    SortExpression="Id" />
48                <asp:BoundField DataField="ParentId" HeaderText="ParentId" SortExpression="ParentId"
49                    NullDisplayText="我的值是NULL" />
50                <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
51                <asp:BoundField DataField="PublishTime" HeaderText="PublishTime" SortExpression="PublishTime"
52                    ReadOnly="true" />
53                <asp:BoundField DataField="Price" HeaderText="Price" SortExpression="Price" DataFormatString="{0:c}" HtmlEncode="false" ApplyFormatInEditMode="True" />
54                <asp:CheckBoxField DataField="IsGood" HeaderText="IsGood" SortExpression="IsGood" />
55            </Columns>
56        </asp:GridView>
57    </p>
58    <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="GetTest"
59        TypeName="Test" InsertMethod="InsertTest" DeleteMethod="DeleteTest" UpdateMethod="UpdateTest"
60        OnInserting="ObjectDataSource1_Inserting" OnInserted="ObjectDataSource1_Inserted">
61        <InsertParameters>
62            <%...--ConvertEmptyStringToNull属性默认为true--%>
63            <asp:Parameter Name="parentId" Type="Int32" ConvertEmptyStringToNull="true" />
64            <asp:Parameter Name="name" Type="String" />
65            <asp:Parameter Name="publishTime" Type="DateTime" />
66            <asp:Parameter Name="price" Type="Decimal" />
67            <asp:Parameter Name="isGood" Type="Boolean" />
68            <asp:Parameter Direction="Output" Name="minId" Type="Int32" />
69        </InsertParameters>
70        <DeleteParameters>
71            <asp:Parameter Name="id" Type="Int32" />
72        </DeleteParameters>
73        <UpdateParameters>
74            <asp:Parameter Name="id" Type="Int32" />
75            <asp:Parameter Name="parentId" Type="Int32" />
76            <asp:Parameter Name="name" Type="String" />
77            <asp:Parameter Name="publishTime" Type="DateTime" />
78            <asp:Parameter Name="price" Type="Decimal" />
79            <asp:Parameter Name="isGood" Type="Boolean" />
80        </UpdateParameters>
81    </asp:ObjectDataSource>
82    <asp:ObjectDataSource ID="ObjectDataSource2" runat="server" OldValuesParameterFormatString="original_{0}"
83        SelectMethod="GetTestById" TypeName="Test">
84        <SelectParameters>
85            <asp:ControlParameter ControlID="GridView1" Name="id" PropertyName="SelectedValue"
86                Type="Int32" />
87        </SelectParameters>
88    </asp:ObjectDataSource>
89</asp:Content>
90