Scribd Logo
Upload

Welcome to Scribd!

  • 97 views

    07 ASP - NET Session10

    Uploaded by

    ajay_anav
    The document outlines tasks for developing ASP.NET web applications that access and display different types of data. It describes creating prototypes that retrieve data from a SQL Server database using SqlDataSource controls, access objects as data using ObjectDataSource controls, and access XML data from a web service using XmlDataSource controls. The tasks include adding connection strings, configuring data source and data controls, binding controls to data, and handling events for displaying and manipulating the data.

    Copyright:

    © All Rights Reserved
    Download as PPS, PDF, TXT or read online from Scribd

    07 ASP - NET Session10

    Uploaded by

    ajay_anav
    97 views7 pages
    The document outlines tasks for developing ASP.NET web applications that access and display different types of data. It describes creating prototypes that retrieve data from a SQL Server database using SqlDataSource controls, access objects as data using ObjectDataSource controls, and access XML data from a web service using XmlDataSource controls. The tasks include adding connection strings, configuring data source and data controls, binding controls to data, and handling events for displaying and manipulating the data.

    Original Title

    07_ASP.NET_Session10

    Copyright

    © © All Rights Reserved

    Available Formats

    PPS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document outlines tasks for developing ASP.NET web applications that access and display different types of data. It describes creating prototypes that retrieve data from a SQL Server database using SqlDataSource controls, access objects as data using ObjectDataSource controls, and access XML data from a web service using XmlDataSource controls. The tasks include adding connection strings, configuring data source and data controls, binding controls to data, and handling events for displaying and manipulating the data.

    Copyright:

    © All Rights Reserved
    Download as PPS, PDF, TXT or read online from Scribd
    Download as pps, pdf, or txt
    97 views7 pages

    07 ASP - NET Session10

    Uploaded by

    ajay_anav
    The document outlines tasks for developing ASP.NET web applications that access and display different types of data. It describes creating prototypes that retrieve data from a SQL Server database using SqlDataSource controls, access objects as data using ObjectDataSource controls, and access XML data from a web service using XmlDataSource controls. The tasks include adding connection strings, configuring data source and data controls, binding controls to data, and handling events for displaying and manipulating the data.

    Copyright:

    © All Rights Reserved
    Download as PPS, PDF, TXT or read online from Scribd
    Download as pps, pdf, or txt
    of 7

    Developing Web Applications Using ASP.

    NET
    Objectives

    In this session, you will learn to:


    Create and retrieve database connections by using the
    Web.Config file
    Access relational data by using the SqlDataSource control and
    data controls
    Access XML data by using the XmlDataSource control and
    data controls
    Access objects as data by using the ObjectDataSource control
    and data controls

    Ver. 1.0 Slide 1 of 7


    Developing Web Applications Using ASP.NET
    Demo: Accessing and Displaying Data

    Problem Statement:
    You are a developer in the Adventure Works organization, a
    fictitious bicycle manufacturer. You have been asked to assist
    in the development of the Business-to-Consumer (B2C) Web
    application and a related Business-to-Employee (B2E) extranet
    portal.
    Decisions on the design of the application have already been
    made. You have been asked to carry out a number of specific
    tasks in order to implement various elements of this design.

    Ver. 1.0 Slide 2 of 7


    Developing Web Applications Using ASP.NET
    Demo: Accessing and Displaying Data (Contd.)

    As part of the first phase of the B2C development, you have


    been asked to implement prototypes of pages that display and
    manipulate data from the AdventureWorks database.You have
    also been asked to implement prototypes of pages that display
    and manipulate data from custom object data sources and
    XML data from the TrailReport Web service.

    Ver. 1.0 Slide 3 of 7


    Developing Web Applications Using ASP.NET
    Demo: Accessing and Displaying Data (Contd.)

    Solution:
    To solve this problem, you need to perform following tasks:
    1. Create and Retrieve Database Connections
    a. Add a connection string for the AdventureWorks database to the
    Web.Config file.
    b. Programmatically retrieve the connection to the AdventureWorks
    database.
    c. Programmatically open the connection and verify that it is open.
    d. Test the database connectivity.

    Ver. 1.0 Slide 4 of 7


    Developing Web Applications Using ASP.NET
    Demo: Accessing and Displaying Data (Contd.)

    2. Access Data by Using SqlDataSource Controls and Data Controls


    a. Add a SqlDataSource control to the Products page.
    b. Set connection properties for the SqlDataSource control.
    c. Bind a DropDownList control to the SqlDataSource control.
    d. Add and configure a Subcategories GridView control with an
    associated SqlDataSource control.
    e. Define the columns for the gvwSubcategories control.
    f. Add and configure a Products GridView control and associated
    SqlDataSource control.
    g. Define columns and templates for the gvwProduct GridView control.
    h. Add and configure a Product Details DetailsView control and
    associated SqlDataSource control.
    i. Add a DataList control to the ProductDetails.aspx page.
    j. Add an SqlDataSourceControl to the page.
    k. Run and test the Web application.

    Ver. 1.0 Slide 5 of 7


    Developing Web Applications Using ASP.NET
    Demo: Accessing and Displaying Data (Contd.)

    3. Access Objects as Data with ObjectDataSource Controls


    a. Review the data-access code in the business object.
    b. Configure an ObjectDataSource control for business-data access.
    c. Add and configure a FormView control.
    d. Define the EmptyDataTemplate element for the FormView control.
    e. Define the ItemTemplate element for the FormView control.
    f. Define the InsertItemTemplate element for the FormView control.
    g. Add code to the Inserting event of the FormView control.
    h. Run and test the Web application.

    Ver. 1.0 Slide 6 of 7


    Developing Web Applications Using ASP.NET
    Demo: Accessing and Displaying Data (Contd.)

    4. Access XML Data by Using XmlDataSource Controls


    a. Add an XmlDataSource object to the TrailReport.aspx page.
    b. Add and configure a TreeView control for the TrailReport.aspx page.
    c. Add code to an event procedure for the TreeView control.
    d. Add code for the Page_Load event of the TrailReport.aspx page.
    e. Test the XML data handling of the Web application.

    Ver. 1.0 Slide 7 of 7

    You might also like