Using the ASP.NET ControlParameter Object to represent the value of a control property. : SqlDataSource « ADO.net Database « ASP.NET Tutorial

ASP.NET Tutorial
1. ASP.Net Instroduction
2. Language Basics
3. ASP.net Controls
4. HTML Controls
5. Page Lifecycle
6. Response
7. Collections
8. Validation
9. Development
10. File Directory
11. Sessions
12. Cookie
13. Cache
14. Custom Controls
15. Profile
16. Configuration
17. LINQ
18. ADO.net Database
19. Data Binding
20. Ajax
21. Authentication Authorization
22. I18N
23. Mobile
24. WebPart
25. XML
Java
Java Tutorial
Java Source Code / Java Documentation
Java Open Source
Jar File Download
Java Articles
Java Products
Java by API
Photoshop Tutorials
Maya Tutorials
Flash Tutorials
3ds-Max Tutorials
Illustrator Tutorials
GIMP Tutorials
C# / C Sharp
C# / CSharp Tutorial
C# / CSharp Open Source
ASP.Net
JavaScript DHTML
JavaScript Tutorial
JavaScript Reference
HTML / CSS
HTML CSS Reference
C / ANSI-C
C Tutorial
C++
C++ Tutorial
Ruby
PHP
Python
Python Tutorial
Python Open Source
SQL Server / T-SQL
SQL Server / T-SQL Tutorial
Oracle PL / SQL
Oracle PL/SQL Tutorial
PostgreSQL
SQL / MySQL
MySQL Tutorial
VB.Net
VB.Net Tutorial
Flash / Flex / ActionScript
VBA / Excel / Access / Word
XML
XML Tutorial
Microsoft Office PowerPoint 2007 Tutorial
Microsoft Office Excel 2007 Tutorial
Microsoft Office Word 2007 Tutorial
ASP.NET Tutorial » ADO.net Database » SqlDataSource 
18. 8. 15. Using the ASP.NET ControlParameter Object to represent the value of a control property.
<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
  "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
    <title>Show Control Parameter</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>

    <asp:DropDownList
        id="ddlProducts"
        DataSourceID="srcProducts"
        DataTextField="Title"
        DataValueField="Id"
        Runat="server" />

    <asp:Button
        id="btnSelect"
        Text="Select"
        Runat="server" />

    <hr />

    <asp:DetailsView
        id="dtlProduct"
        DataSourceID="srcProductDetails"
        Runat="server" />

    <asp:SqlDataSource
        id="srcProducts"
        SelectCommand="SELECT Id,Title FROM Products"
        ConnectionString="<%$ ConnectionStrings:Products %>"
        Runat="server" />

    <asp:SqlDataSource
        id="srcProductDetails"
        SelectCommand="SELECT * FROM Products
            WHERE Id=@Id"
        ConnectionString="<%$ ConnectionStrings:Products %>"
        Runat="server">
        <SelectParameters>
            <asp:ControlParameter Name="Id" ControlID="ddlProducts"
                PropertyName="SelectedValue" />
        </SelectParameters>
    </asp:SqlDataSource>

    </div>
    </form>
</body>
</html>


File: Web.config

<configuration>
  <connectionStrings>
    <add name="Products" 
         connectionString="Data Source=.\SQLEXPRESS;
         AttachDbFilename=|DataDirectory|MyDatabase.mdf;Integrated Security=True;User Instance=True" />
  </connectionStrings>
</configuration>
18. 8. SqlDataSource
18. 8. 1. Connection to a mdf file
18. 8. 2. Connecting to Microsoft SQL Server
18. 8. 3. asp:SqlDataSource select command with parameters
18. 8. 4. Specify column from asp:SqlDataSource
18. 8. 5. Use connection string in asp:SqlDataSource and set the DeleteCommand and SelectCommand
18. 8. 6. Configure two asp:SqlDataSource with different SelectCommand
18. 8. 7. Executing Stored Procedures
18. 8. 8. Filtering Database Rows
18. 8. 9. Retrieves the records from the database by using a DataReader
18. 8. 10. Handling SQL Command Execution Errors
18. 8. 11. Handle the exception at the level of a DataBound control.
18. 8. 12. Canceling Command Execution when Deleting, Filtering, Inserting, Selecting, Updating
18. 8. 13. Using ASP.NET Parameters with the SqlDataSource Control
18. 8. 14. Declare each of the parameters used when executing the update command.
18. 8. 15. Using the ASP.NET ControlParameter Object to represent the value of a control property.
18. 8. 16. Show Page Control Parameter
18. 8. 17. Using the ASP.NET CookieParameter Object
18. 8. 18. Using the ASP.NET FormParameter Object
18. 8. 19. Using the ASP.NET ProfileParameter Object
18. 8. 20. Using the QueryStringParameter Object
18. 8. 21. Using the SessionParameter Object
18. 8. 22. Caching Database Data with the SqlDataSource Control
18. 8. 23. Link asp:GridView with asp:SqlDataSource
18. 8. 24. Bind asp:SqlDataSource with CheckBoxList and RadioButtonList (VB.net)
18. 8. 25. Link asp:DropDownList with asp:SqlDataSource
18. 8. 26. SqlDataSource with dynamic parameter
www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.