Professional Asp.net 2.0 Databases

by Thiru Thangarathinam

• ISBN13: 9780470041796
• ISBN10: 047004179X
• Format: Paperback
• Copyright: 2007-02-01
• Publisher: Wrox

Summary

Now you can uncover the secrets behind accessing and retrieving data from a wide range of data sources such as SQL Server[Trademark] and XML sources. This book walks you through the array of ADO.NET 2.0 features and clearly shows you how they can be used to develop database-driven web applications in ASP.NET.

Author Biography

Thiru Thangarathinam works for Intel Corporation in Phoenix, Arizona. He is an MVP and specializes in architecting, designing, and developing distributed enterprise-class applications using .NET-related technologies. He is the author of Professional ASP.NET 2.0 XML from Wiley and has also coauthored a number of books in .NET-related technologies. Thiru has also been a frequent contributor to leading technology-related online publications. At Intel, he is part of the team that is focused on developing the Enterprise Architecture and Service Oriented Architectures for Intel. He can be reached at [e-mail].

Table of Contents

Acknowledgments	p. xv
Introduction	p. xvii
Introduction	p. 1
Introduction to ASP.NET 2.0	p. 3
ASP.NET 2.0 Features	p. 3
Developer Productivity	p. 4
Administration and Management	p. 18
Speed and Performance	p. 20
Summary	p. 23
Introduction to ADO.NET 2.0	p. 25
What's New with ADO.NET 2.0	p. 25
Fundamental ADO.NET 2.0 Namespaces	p. 26
Fundamental ADO.NET Classes	p. 30
Understanding the Connected Layer of ADO.NET	p. 33
Understanding the Disconnected Layer of ADO.NET	p. 38
Summary	p. 44
ASP.NET 2.0 Data Controls	p. 45
Introducing Data Source Controls	p. 46
SqlDataSource Control	p. 47
XmlDataSource Control	p. 53
ObjectDataSource Control	p. 53
SiteMapDataSource Control	p. 56
Configuring Data Source Control Caching	p. 58
Introducing Data-Bound Controls	p. 59
GridView	p. 59
DetailsView	p. 63
FormView	p. 65
Menu	p. 66
Inline Data Binding Syntax	p. 66
XML Data Binding Syntax	p. 67
DropDownList, ListBox, RadioButtonList, and CheckBoxList	p. 68
Summary	p. 68
ASP.NET 2.0 Data Source and Data Bound Controls	p. 69
Data Binding with the SqlDataSource Control	p. 71
Introduction to the SqlDataSource Control	p. 72
Selecting Records	p. 74
Updating Records	p. 84
Deleting Records	p. 91
Encrypting the Connection String Stored in the Web.config File	p. 94
Programmatically Adding a SqlDataSource Control to the Page	p. 96
Sorting with the SqlDataSource Control	p. 97
Caching	p. 99
Cache Dependencies	p. 102
Summary	p. 108
Data Binding with XML Data	p. 109
Introduction to the XmlDataSource Control	p. 110
Data Binding with the XmlDataSource Control	p. 113
Updating XML Data	p. 123
Programmatically Creating an XmlDataSource Control	p. 126
XSL Transformations with XmlDataSource Control	p. 127
Handling Events Raised by the XmlDataSource Control	p. 128
Implementing Caching with the XmlDataSource Control	p. 129
Summary	p. 131
Data Binding with Objects	p. 133
Introduction to the ObjectDataSource Control	p. 134
Selecting Records	p. 137
Updating Records	p. 144
Inserting Data	p. 150
Deleting Records	p. 153
Programmatically Adding the ObjectDataSource Control	p. 156
Using Generics with the ObjectDataSource Control	p. 157
Caching	p. 162
Using Web Services with the ObjectDataSource Control	p. 163
Summary	p. 166
ASP.NET 2.0 Site Navigation	p. 167
Introduction to Site Navigation	p. 167
Implementing Site Navigation	p. 168
Implementing Breadcrumbs	p. 174
Programmatic Navigation	p. 177
Binding to Other Controls	p. 179
Creating Custom Attributes for a Sitemap	p. 180
Creating a Custom Sitemap Provider	p. 181
Using Multiple Sitemaps and Sitemap Providers	p. 192
Configuring Site Navigation to Use Security Trimmings	p. 193
Summary	p. 194
Displaying and Editing Data Using Templates	p. 195
ASP.NET 2.0 Templated Controls	p. 195
GridView	p. 196
DetailsView and FormView	p. 226
Summary	p. 229
GridView Sorting and Paging	p. 231
Sorting and Paging	p. 232
Sorting Data	p. 233
Paging Data	p. 241
Efficient Paging and Sorting Using Callbacks	p. 250
Summary	p. 250
Advanced Data Source and Data Bound Controls	p. 251
Advanced Controls	p. 251
Master/Detail Display	p. 252
Displaying Parent/Child View in a Single GridView	p. 254
Multiple Selections in GridView	p. 258
Displaying Images from a Database	p. 261
Creating Custom Templates for GridView	p. 266
Using Themes with Data Bound Controls	p. 270
Data Binding with the FormView Control	p. 274
Extending the GridView Control	p. 280
Summary	p. 283
Transactions	p. 285
Overview of Transactions	p. 286
ACID Properties	p. 286
Database Transactions	p. 286
Transactions in .NET 1.x	p. 288
Transactions in .NET 2.0	p. 297
Transaction Events	p. 308
Interoperability between System.Transactions and System.EnterpriseServices	p. 311
When to Use Transactions	p. 312
Summary	p. 313
Case Study: Creating an Online Rental Reservation System Using N-Tier Architecture with ASP.NET 2.0 and SQL Server 2005	p. 315
Overview of the Case Study	p. 316
Architecture of System	p. 319
Business Processes	p. 317
Implementation	p. 317
Database Design	p. 318
Implementation of CarRentalReservation Component	p. 322
Implementation of the Web Site	p. 331
Putting It All Together	p. 356
Summary	p. 356
ASP.NET and XML	p. 359
Advanced ADO.NET for ASPNET Data Display	p. 361
The DataSet Object	p. 362
DataSet Collections	p. 362
Creating and Using DataSet Objects	p. 363
Programmatically Creating DataSet Objects	p. 364
Strongly Typed DataSets	p. 366
ADO.NET 2.0 Enhancements to the DataSet	p. 372
ADO.NET 2.0 DataTable	p. 375
DataTable and XML	p. 375
Associating a DataReader with a DataTable	p. 377
Provider-Independent Data Access Code	p. 378
Provider Factory Class Hierarchy	p. 378
Creating a Generic Query Execution Framework	p. 379
Storing Connection Strings in Web.config	p. 383
Key Considerations	p. 384
Executing Commands Asynchronously	p. 384
Synchronous versus Asynchronous Execution of Commands	p. 384
Overview of Asynchronous Command Execution	p. 386
Multiple Active Result Sets (MARS)	p. 389
Enterprise Library Data Access Block	p. 393
What Is the Enterprise Data Access Block?	p. 393
Steps Involved in Using the Data Access Block	p. 394
Database Object	p. 395
Executing a Stored Procedure Using the EntLib Data Access Block	p. 397
Summary	p. 399
Accessing Data from SQL Server 2005	p. 401
Introduction to SQL Server 2005	p. 402
CLR in SQL Server 2005	p. 402
Managed Assemblies in SQL Server 2005	p. 403
New XML Features in SQL Server 2005	p. 411
For XML in SQL Server 2005	p. 412
Executing For XML Queries from ADO.NET	p. 414
XML Data Type in SQL Server 2005	p. 420
Working with XML Data-Typed Columns from AD0.NET	p. 426
In-Process Access to the XML Data Type Column	p. 426
Client-Side XML	p. 437
ASP.NET 2.0 Script Callback Feature	p. 437
Summary	p. 445
Case Study: Best Practices for Creating ASP.NET Web Sites	p. 447
Overview of the Case Study	p. 448
Architecture of System	p. 448
Business Processes	p. 449
Implementation	p. 450
Database Design	p. 450
Implementation of CLR Stored Procedures	p. 453
Implementation of the Data Access Layer	p. 456
Implementation of the Business Logic Layer	p. 465
Implementation of the Web Site	p. 470
Summary	p. 476
Index	p. 477
Table of Contents provided by Ingram. All Rights Reserved.