1 <%@ Page Language="C#" MasterPageFile="~/MasterPages/SamplePageWithCode.master"
2 AutoEventWireup="true" CodeFile="01_MasterDetailMultiUP.aspx.cs"
3 Inherits="_05_OtherSamples_01_MasterDetailMultiUP"
4 Title="Master/Detail Multi UpdatePanel" %>
5 <asp:Content ID="Content1" ContentPlaceHolderID="MainContent" Runat="Server">
6 <asp:TextBox ID="CustomerSearch" runat="server"></asp:TextBox>
7 <asp:button ID="SearchButton" runat="server" Text="Search"/>
8 <atlas:AutoCompleteExtender ID="AutoComplete" runat="server">
9 <atlas:AutoCompleteProperties Enabled="true"
10 ServiceMethod="GetCustomerAbbr"
11 ServicePath="~/CustomerService.asmx"
12 TargetControlID="CustomerSearch" />
13 </atlas:AutoCompleteExtender>
14 <br />
15 This is a sample showing multiple GridViews and UpdatePanels all triggered off of
16 each other.<br />
17 Use the AutoComplete textbox above to browse the customers and select one.<br />
18 <br />
19 <atlas:UpdatePanel ID="UpdateGrid" runat="server" Mode="conditional">
20 <ContentTemplate>
21 <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" DataSourceID="NWindDb" PageSize="5" DataKeyNames="CustomerID">
22 <Columns>
23 <asp:CommandField ShowSelectButton="True" />
24 </Columns>
25 </asp:GridView>
26 </ContentTemplate>
27 <Triggers>
28 <atlas:ControlEventTrigger ControlID="SearchButton" EventName="Click" />
29 </Triggers>
30 </atlas:UpdatePanel>
31 <atlas:UpdatePanel ID="UpdateDetails" runat="server" Mode="conditional">
32 <ContentTemplate>
33 Orders:<br />
34 <asp:GridView ID="DetailsGrid" runat="server" AutoGenerateColumns="False" DataKeyNames="OrderID" DataSourceID="NWindDetails">
35 <Columns>
36 <asp:CommandField ShowSelectButton="True" />
37 <asp:BoundField DataField="OrderID" HeaderText="OrderID" InsertVisible="False" ReadOnly="True"
38 SortExpression="OrderID" />
39 <asp:BoundField DataField="CustomerID" HeaderText="CustomerID" SortExpression="CustomerID" />
40 <asp:BoundField DataField="ShipName" HeaderText="ShipName" SortExpression="ShipName" />
41 <asp:BoundField DataField="OrderDate" HeaderText="OrderDate" SortExpression="OrderDate" />
42 </Columns>
43 </asp:GridView>
44 <br />
45 <atlas:UpdatePanel ID="OrderDetailsP" runat="server">
46 <ContentTemplate>
47 <asp:GridView ID="OrderDetails" runat="server" AutoGenerateColumns="False" DataSourceID="OrderData">
48 <Columns>
49 <asp:BoundField DataField="ProductName" HeaderText="ProductName" SortExpression="ProductName" />
50 <asp:BoundField DataField="UnitPrice" HeaderText="UnitPrice" ReadOnly="True" SortExpression="UnitPrice" />
51 <asp:BoundField DataField="Quantity" HeaderText="Quantity" SortExpression="Quantity" />
52 <asp:BoundField DataField="Discount" HeaderText="Discount" ReadOnly="True" SortExpression="Discount" />
53 <asp:BoundField DataField="ExtendedPrice" HeaderText="ExtendedPrice" ReadOnly="True"
54 SortExpression="ExtendedPrice" />
55 </Columns>
56 </asp:GridView>
57 <asp:SqlDataSource ID="OrderData" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindDb %>"
58 SelectCommand="CustOrdersDetail" SelectCommandType="StoredProcedure">
59 <SelectParameters>
60 <asp:ControlParameter ControlID="DetailsGrid" Name="OrderID" PropertyName="SelectedValue"
61 Type="Int32" />
62 </SelectParameters>
63 </asp:SqlDataSource>
64 </ContentTemplate>
65 <Triggers>
66 <atlas:ControlEventTrigger ControlID="DetailsGrid" EventName="SelectedIndexChanged" />
67 </Triggers>
68 </atlas:UpdatePanel>
69 <asp:SqlDataSource ID="NWindDetails" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindDb %>"
70 SelectCommand="SELECT [OrderID], [CustomerID], [ShipName], [OrderDate] FROM [Orders] WHERE ([CustomerID] = @CustomerID)">
71 <SelectParameters>
72 <asp:ControlParameter ControlID="GridView1" Name="CustomerID" PropertyName="SelectedValue"
73 Type="String" />
74 </SelectParameters>
75 </asp:SqlDataSource>
76 </ContentTemplate>
77 <Triggers>
78 <atlas:ControlEventTrigger ControlID="GridView1" EventName="SelectedIndexChanged" />
79 </Triggers>
80 </atlas:UpdatePanel>
81 <asp:SqlDataSource ID="NWindDb" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindDb %>"
82 SelectCommand="SELECT [CustomerID], [CompanyName], [ContactName], [Country] FROM [Customers] WHERE ([CustomerID] = @CustomerID)">
83 <SelectParameters>
84 <asp:ControlParameter ControlID="CustomerSearch" Name="CustomerID" PropertyName="Text"
85 Type="String" />
86 </SelectParameters>
87 </asp:SqlDataSource>
88 </asp:Content>
|