Tuesday, 29 July 2014

Using Control Parameter with Details View in ASP.NET

ASP.NET ControlParameter and DetailsView example

  1. <%@ Page Language=“C#” %>

  3. <!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>

  5. <script runat=“server”>

  7. </script>

  9. <html xmlns=“http://www.w3.org/1999/xhtml”>
  10. <head runat=“server”>
  11.     <title>asp.net ControlParameter and DetailsView example</title>
  12. </head>
  13. <body>
  14.     <form id=“form1″ runat=“server”>
  15.     <div>
  16.         <h2 style=“color:Teal”>ControlParameter and DetailsView</h2>
  17.         <asp:SqlDataSource
  18.              ID=“SqlDataSource1″
  19.              runat=“server”
  20.              ConnectionString=“<%$ ConnectionStrings:NorthwindConnectionString %>”
  21.              SelectCommand=“SELECT ProductID, ProductName FROM Products”
  22.              >
  23.         </asp:SqlDataSource>
  24.         <asp:SqlDataSource
  25.              ID=“SqlDataSource2″
  26.              runat=“server”
  27.              ConnectionString=“<%$ ConnectionStrings:NorthwindConnectionString %>”
  28.              SelectCommand=“SELECT ProductID, ProductName, UnitPrice FROM Products WHERE ProductID=@ProductID”
  29.              >
  30.             <SelectParameters>
  31.                 <asp:ControlParameter ControlID=“DropDownList1″ Name=“ProductID” PropertyName=“SelectedValue” />
  32.             </SelectParameters>
  33.         </asp:SqlDataSource>
  34.         <asp:Label ID=“Label1″ runat=“server” Text=“Product” AssociatedControlID=“DropDownList1″ ForeColor=“SteelBlue” Font-Bold=“true”></asp:Label>
  35.         <asp:DropDownList
  36.              ID=“DropDownList1″
  37.              runat=“server”
  38.              DataSourceID=“SqlDataSource1″
  39.              DataTextField=“ProductName”
  40.              DataValueField=“ProductID”
  41.              AutoPostBack=“true”
  42.              ForeColor=“HotPink”
  43.              >
  44.         </asp:DropDownList>
  45.         <br /><br />
  46.         <asp:Label ID=“Label2″ runat=“server” Text=“Product Details” Font-Bold=“true” ForeColor=“Gray”></asp:Label>
  47.         <asp:DetailsView
  48.              ID=“DetailsView1″
  49.              runat=“server”
  50.              DataSourceID=“SqlDataSource2″
  51.              BackColor=“Snow”
  52.              ForeColor=“IndianRed”
  53.              BorderStyle=“Double”
  54.              BorderColor=“SteelBlue”
  55.              >
  56.         </asp:DetailsView>
  57.     </div>
  58.     </form>
  59. </body>
  60. </html>



Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)