Special Offers

Building Web Solutions with ASP.NET and ADO.NET
Author Dino Esposito (Wintellect)
Pages 416
Disk 1 Companion CD(s)
Level Int/Adv
Published 02/06/2002
ISBN 9780735615786
Price $49.99
To see this book's discounted price, select a reseller below.

More Information

About the Book
Table of Contents
Sample Chapter
Related Series
Related Books
About the Author

Support: Book & CD

Rate this book
Barnes Noble Amazon Quantum Books


Table of Contents

1   Data Bound .NET Controls3
    ASP.NET Data Binding3
        Feasible Data-Binding Sources4
        Simple Data Binding5
        Complex Data Binding6
    The DropDownList Web Control7
    The CheckBoxList Web Control9
    The RadioButtonList Web Control11
    The ListBox Web Control12
    The Repeater Control14
        Accessing Data Bound Information14
        Repeater Control Events16
    The DataList Control19
        Templates Specific to DataList20
        Events Specific to DataList21
        Relating Graphical and Data Elements23
    The DataGrid Control26
2   Pageable Data Grids29
    Constituent Items of DataGrid29
    Column Types31
    Binding Columns32
        Bound Columns33
        Button Columns34
        Link Columns37
        Programmatic Binding40
    Data Pagination43
        Semi-Automatic Pagination43
        Properties for Pagination45
        The Pager Bar45
        Pagination in Action47
        Customizing the Pager Bar48
        Custom Pagination54
    Sorting Columns59
        Setting Up Sorting60
        Auto-Reverse Sorting61
        Sorting Multiple Fields64
        Auto-Reverse Sorting for Multiple Columns64
        Showing Sorting Information66
    DataGrid Controls and Data Persistence68
        Scalability? What Was That?69
        Using the Session Object69
        Using the Cache Object70
        Using XML Files71
        Using Data Readers and Adapters72
        The Paradox of Pagination73
3   Templated DataGrid Controls75
    Binding Templated Columns75
    Templated Columns in Action78
        Concatenating Data Fields79
        Sorting Templated Columns80
        Grouping Columns Under a Single Header81
        Adjusting Column Margins83
        Customizing Column Headers85
    Creating Templates Dynamically88
        Loading Templates from Files88
        Managing Multiple Views for a Column89
        Loading Templates from Strings93
        Implementing ITemplate94
    Adapting Columns to Data97
        Showing Boolean Values97
        Showing Images99
        Showing Arrays100
4   Editing DataGrid Controls105
    The In-Place Editing Feature106
        Enabling In-Place Editing106
        Reading Text from Edited Fields111
        Updating the Data Source113
        A Long List of Drawbacks116
    Editing In Place Using Templates117
        Working with Template Controls118
        Adapting Layouts to Data120
    Adding New Rows126
        Setting Up the Add-Row Feature126
        Adding Blank Rows128
        Switching to Edit Mode129
        Updating the Table and the Grid130
5   Code Reusability in ASP.NET139
    Layers of ASP.NET Pages139
        From Spaghetti Code to Lasagna Code140
        Slimmer Pages141
    The Code-Behind Approach141
        Enabling Code-Behind142
        Writing Code-Behind Pages142
        Visual Inheritance for ASP.NET Pages145
    Embeddable Web Forms147
        Writing User Controls147
        Creating a New DateBox Control153
        Firing Events157
    Writing Custom Controls162
        A Labeled TextBox Control162
        Using Custom Controls165
        An Off-the-Shelf DataGrid Control167
        The UpdateView Event170
        The SortExpression Property171
6   Advanced Data Reporting175
    Item Selection175
        Enabling Item Selection 176
        Using the SelectedIndexChanged Event 179
        Selecting Rows Programmatically 181
        Selection and Drill-Down 183
        Filtered Views 185
    Allowing the Selection of Multiple Items 186
        Properties of the SuperGrid Control 187
        Layout of the SuperGrid Control 188
        Retrieving the Selected Items 193
    Selecting by Condition 195
        Changing the Background Color 196
        Evaluating the Condition 197
        Adding an Extra Column 198
    Aggregates and Summary Rows 201
        The Right Way to Query 202
        Creating Relations Between Tables 202
7   Disconnected Web Applications 211
    What Is the DataSet Object Really For? 212
        Implications for Web Applications 212
        DataSet and the DataGrid Control 213
        Towards Disconnected Applications 214
    Transparent Data Sources 215
        Working with the Cache Object 216
        Loading Data from a Generic Source 216
        Creating Subtables 217
    Batch Updates 219
        Locking Rows 220
        Applying In-Memory Changes 221
        Auto-Increment Fields 224
        Delete and Remove 226
        States of a Row 228
    An Offline Buffer for Data 229
        Loading a DataSet from XML 229
        The DiffGram Format 230
    Submitting Changes 233
        Detecting Changes 233
        Rejecting Changes 235
        Viewing Changes 235
        Generating Commands 239
        Command Builders 242
        Data Conflicts 246
8   Interoperable Web Applications255
    The COM Interop Services256
    Using ADO in .NET Applications257
        The ADODB Assembly258
        Getting a Recordset259
        ADO Server Cursors261
        Migration Issues262
    Adapting Recordset Objects to DataSet Objects262
        Loading a Recordset Object into a DataSet Object263
        Loading a Recordset Object into a DataTable Object264
        A Common Migration Scenario265
    From DataSet Objects to ADO Recordset Objects269
        Serializing DataSet Objects to XML Recordset Objects269
        XML Schemas for DataSet Objects270
        The ADO XML Schema271
        Creating an ADO XML Schema272
        From .NET Data to XML276
    XML Object Serialization278
        Enabling Object Serialization278
        Serializing to XML281
9   Web Services285
    Dynamic Link Web Libraries286
        Web Service Specifications286
        Underlying Technologies287
    .NET Web Services288
        The WebService Attribute288
        Changing the Default Namespace 289
        Defining Web Methods290
        Under the Hood of .NET Web Services293
        Invoking .NET Web Services296
        Creating Proxy Classes300
    Web Service Implementation304
        Contract Design304
        Minimizing Round-Trips305
        Authentication and Authorization306
        Managing State308
        Publishing and Deploying Web Services308
    Web Service Optimization 309
        Asynchronous Calls310
        SOAP Extensions312
        Extreme Optimization314
10   Exposing Data to .NET Applications317
    Exposing Proprietary Data318
        Using Tailor-Made Classes319
        The DirectoryListing Class320
        Creating In-Memory Tables324
        Using the DirectoryListing Class330
        Using OLE DB Providers333
    Inside .NET Data Providers335
        The Architecture of .NET Data Providers336
        Implementing a Connection338
        Implementing a Command340
        Implementing a Data Reader341
        Implementing a Data Adapter342
        Simple vs. Complex Data Providers343
    Writing a Simple Data Provider344
        The Table Mapping Mechanism345
        Filling the DataSet Object346
        Using the Simple Data Provider347
        Updating the Data Source348
AFTERWORD   Some Final Thoughts on the Future of ADO.NET355

Last Updated: January 30, 2002
Top of Page