| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273 |
- <%@ Page Language="C#" %>
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
- "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <script runat="server">
- protected void Search_Click(object sender, EventArgs e)
- {
- SqlDataSource1.SelectParameters["SearchTerm"].DefaultValue =
- Server.HtmlEncode(SearchField.Text);
- Label1.Text = "Searching for '" +
- Server.HtmlEncode(SearchField.Text) + "'";
- }
- protected void ExampleProductSearch_Click(object sender, EventArgs e)
- {
- SqlDataSource1.SelectParameters["SearchTerm"].DefaultValue =
- Server.HtmlEncode(ExampleProductSearch.Text);
- Label1.Text = "Searching for '" +
- Server.HtmlEncode(ExampleProductSearch.Text) + "'";
- SearchField.Text = ExampleProductSearch.Text;
- }
- </script>
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head id="Head1" runat="server">
- <title>UpdatePanel Trigger Example</title>
- <style type="text/css">
- body {
- font-family: Lucida Sans Unicode;
- font-size: 10pt;
- }
- button {
- font-family: tahoma;
- font-size: 8pt;
- }
- </style>
- </head>
- <body>
- <form id="form1" runat="server"
- defaultbutton="SearchButton" defaultfocus="SearchField">
- <div>
- Search for products in the Northwind database. For example,
- find products with
- <asp:LinkButton ID="ExampleProductSearch" Text="Louisiana" runat="server" OnClick="ExampleProductSearch_Click">
- </asp:LinkButton> in the title. <br /><br />
- <asp:TextBox ID="SearchField" runat="server"></asp:TextBox>
- <asp:Button ID="SearchButton" Text="Submit" OnClick="Search_Click"
- runat="server" />
- <fieldset>
- <legend>Northwind Products</legend>
- <asp:Label ID="Label1" runat="server"/>
- <br />
- <asp:GridView ID="GridView1" runat="server" AllowPaging="True"
- AllowSorting="True" DataSourceID="SqlDataSource1">
- <EmptyDataTemplate>
- No results to display.
- </EmptyDataTemplate>
- </asp:GridView>
- <asp:SqlDataSource ID="SqlDataSource1" runat="server"
- ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
- SelectCommand="SELECT [ProductName], [UnitsInStock] FROM
- [Alphabetical list of products] WHERE ([ProductName] LIKE
- '%' + @SearchTerm + '%')">
- <SelectParameters>
- <asp:Parameter Name="SearchTerm" Type="String" />
- </SelectParameters>
- </asp:SqlDataSource>
- </fieldset>
- </div>
- </form>
- </body>
- </html>
|