.Net Home

.Net Articles

.Net Books

.Net Tools

.Net Keywords



.Net

Building Web Solutions with ASP.NET and ADO.NET

See more Amazon Details

Contents Listing

  Acknowledgments
    Introduction
PART I   DATA ACCESS AND REPORTING
1   Data Bound .NET Controls
    ASP.NET Data Binding
        Feasible Data-Binding Sources
        Simple Data Binding
        Complex Data Binding
    The DropDownList Web Control
    The CheckBoxList Web Control
    The RadioButtonList Web Control
    The ListBox Web Control
    The Repeater Control
        Accessing Data Bound Information
        Repeater Control Events
    The DataList Control
        Templates Specific to DataList
        Events Specific to DataList
        Relating Graphical and Data Elements
    The DataGrid Control
2   Pageable Data Grids
    Constituent Items of DataGrid
    Column Types
    Binding Columns
        Bound Columns
        Button Columns
        Link Columns
        Programmatic Binding
    Data Pagination
        Semi-Automatic Pagination
        Properties for Pagination
        The Pager Bar
        Pagination in Action
        Customizing the Pager Bar
        Custom Pagination
    Sorting Columns
        Setting Up Sorting
        Auto-Reverse Sorting
        Sorting Multiple Fields
        Auto-Reverse Sorting for Multiple Columns
        Showing Sorting Information
    DataGrid Controls and Data Persistence
        Scalability? What Was That?
        Using the Session Object
        Using the Cache Object
        Using XML Files
        Using Data Readers and Adapters
        The Paradox of Pagination
3   Templated DataGrid Controls
    Binding Templated Columns
    Templated Columns in Action
        Concatenating Data Fields
        Sorting Templated Columns
        Grouping Columns Under a Single Header
        Adjusting Column Margins
        Customizing Column Headers
    Creating Templates Dynamically
        Loading Templates from Files
        Managing Multiple Views for a Column
        Loading Templates from Strings
        Implementing ITemplate
    Adapting Columns to Data
        Showing Boolean Values
        Showing Images
        Showing Arrays
4   Editing DataGrid Controls
    The In-Place Editing Feature
        Enabling In-Place Editing
        Reading Text from Edited Fields
        Updating the Data Source
        A Long List of Drawbacks
    Editing In Place Using Templates
        Working with Template Controls
        Adapting Layouts to Data
    Adding New Rows
        Setting Up the Add-Row Feature
        Adding Blank Rows
        Switching to Edit Mode
        Updating the Table and the Grid
PART II   SMART AND EFFECTIVE DATA ACCESS AND REPORTING
5   Code Reusability in ASP.NET
    Layers of ASP.NET Pages
        From Spaghetti Code to Lasagna Code
        Slimmer Pages
    The Code-Behind Approach
        Enabling Code-Behind
        Writing Code-Behind Pages
        Visual Inheritance for ASP.NET Pages
    Embeddable Web Forms
        Writing User Controls
        Creating a New DateBox Control
        Firing Events
    Writing Custom Controls
        A Labeled TextBox Control
        Using Custom Controls
        An Off-the-Shelf DataGrid Control
        The UpdateView Event
        The SortExpression Property
6   Advanced Data Reporting
    Item Selection
        Enabling Item Selection
        Using the SelectedIndexChanged Event
        Selecting Rows Programmatically
        Selection and Drill-Down
        Filtered Views
    Allowing the Selection of Multiple Items
        Properties of the SuperGrid Control
        Layout of the SuperGrid Control
        Retrieving the Selected Items
    Selecting by Condition
        Changing the Background Color
        Evaluating the Condition
        Adding an Extra Column
    Aggregates and Summary Rows
        The Right Way to Query
        Creating Relations Between Tables
7   Disconnected Web Applications
    What Is the DataSet Object Really For?
        Implications for Web Applications
        DataSet and the DataGrid Control
        Towards Disconnected Applications
    Transparent Data Sources
        Working with the Cache Object
        Loading Data from a Generic Source
        Creating Subtables
    Batch Updates
        Locking Rows
        Applying In-Memory Changes
        Auto-Increment Fields
        Delete and Remove
        States of a Row
    An Offline Buffer for Data
        Loading a DataSet from XML
        The DiffGram Format
    Submitting Changes
        Detecting Changes
        Rejecting Changes
        Viewing Changes
        Generating Commands
        Command Builders
        Data Conflicts
PART III   INTEROPERABILITY
8   Interoperable Web Applications
    The COM Interop Services
    Using ADO in .NET Applications
        The ADODB Assembly
        Getting a Recordset
        ADO Server Cursors
        Migration Issues
    Adapting Recordset Objects to DataSet Objects
        Loading a Recordset Object into a DataSet Object
        Loading a Recordset Object into a DataTable Object
        A Common Migration Scenario
    From DataSet Objects to ADO Recordset Objects
        Serializing DataSet Objects to XML Recordset Objects
        XML Schemas for DataSet Objects
        The ADO XML Schema
        Creating an ADO XML Schema
        From .NET Data to XML
    XML Object Serialization
        Enabling Object Serialization
        Serializing to XML
9   Web Services
    Dynamic Link Web Libraries
        Web Service Specifications
        Underlying Technologies
    .NET Web Services
        The WebService Attribute
        Changing the Default Namespace
        Defining Web Methods
        Under the Hood of .NET Web Services
        Invoking .NET Web Services
        Creating Proxy Classes
    Web Service Implementation
        Contract Design
        Minimizing Round-Trips
        Authentication and Authorization
        Managing State
        Publishing and Deploying Web Services
    Web Service Optimization
        Asynchronous Calls
        SOAP Extensions
        Extreme Optimization
10   Exposing Data to .NET Applications
    Exposing Proprietary Data
        Using Tailor-Made Classes
        The DirectoryListing Class
        Creating In-Memory Tables
        Using the DirectoryListing Class
        Using OLE DB Providers
    Inside .NET Data Providers
        The Architecture of .NET Data Providers
        Implementing a Connection
        Implementing a Command
        Implementing a Data Reader
        Implementing a Data Adapter
        Simple vs. Complex Data Providers
    Writing a Simple Data Provider
        The Table Mapping Mechanism
        Filling the DataSet Object
        Using the Simple Data Provider
        Updating the Data Source
AFTERWORD   Some Final Thoughts on the Future of ADO.NET
INDEX

Google
Web www.techno.nildram.co.uk

Contents
View a contents listing.

Short
Short Description.


Keyword Pages

Keyword Bestsellers

.Net Bestsellers
The bestselling books on Amazon.

Articles

SAP and Windows Integration Move

Performance Testing Microsoft .Net Web Applications

Visit our site of the month Sarbanes-Oxley at www.sarbanesoxleyuk.co.uk
Visit our site of the month Sarbanes-Oxley at www.sarbanesoxleyuk.co.uk