1 <%@ Page Language="C#" MasterPageFile="~/MasterPages/SamplePageWithCode.master"
2 AutoEventWireup="true" CodeFile="04_FullEditing.aspx.cs"
3 Inherits="_02_UpdatePanel_04_FullEditing"
4 Title="GridView w/inline Editing" %>
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 Even full editing is enabled.<br />
16 <br />
17 <atlas:UpdatePanel ID="UpdateGrid" runat="server" Mode="conditional">
18 <ContentTemplate>
19 <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" DataSourceID="NWindDb" PageSize="5">
20 <Columns>
21 <asp:CommandField ShowEditButton="True" />
22 </Columns>
23 </asp:GridView>
24 </ContentTemplate>
25 </atlas:UpdatePanel>
26 <asp:SqlDataSource ID="NWindDb" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindDb %>"
27 SelectCommand="SELECT [CustomerID], [CompanyName], [ContactName], [Country] FROM [Customers]" DeleteCommand="DELETE FROM [Customers] WHERE [CustomerID] = @CustomerID" InsertCommand="INSERT INTO [Customers] ([CustomerID], [CompanyName], [ContactName], [Country]) VALUES (@CustomerID, @CompanyName, @ContactName, @Country)" UpdateCommand="UPDATE [Customers] SET [CompanyName] = @CompanyName, [ContactName] = @ContactName, [Country] = @Country WHERE [CustomerID] = @CustomerID">
28 <DeleteParameters>
29 <asp:Parameter Name="CustomerID" Type="String" />
30 </DeleteParameters>
31 <UpdateParameters>
32 <asp:Parameter Name="CompanyName" Type="String" />
33 <asp:Parameter Name="ContactName" Type="String" />
34 <asp:Parameter Name="Country" Type="String" />
35 <asp:Parameter Name="CustomerID" Type="String" />
36 </UpdateParameters>
37 <InsertParameters>
38 <asp:Parameter Name="CustomerID" Type="String" />
39 <asp:Parameter Name="CompanyName" Type="String" />
40 <asp:Parameter Name="ContactName" Type="String" />
41 <asp:Parameter Name="Country" Type="String" />
42 </InsertParameters>
43 </asp:SqlDataSource>
44 </asp:Content>
|