Professional ASP.NET 2.0 Databases, Wrox
C# Online.NET Book Review
ASP.NET 2.0 is great for designing dynamic Web pages. And, dynamic pages require a database. But, when it comes to finding a book to help you cope with ASP.NET and database, there are two problems. Firstly, there are very few books out there aimed at middle level developers: The majority of ASP.NET books are aimed either low—at novices and beginners—or high—at high intermediate or expert developers. Secondly, there are few books addressing database issues from the ASP.NET point of view. For example, there are many ADO.NET titles; but, the majority of them focus on Windows Forms applications.
This book is not for beginners: Rather, it is for intermediate or higher level developers with ASP.NET and relational database experience. Not only is this book aimed squarely at intermediate level ASP.NET developers; but, also, it is dedicated to using database from ASP.NET. Thus, it fills a very sparsely populated niche in the market.
This book shows how to use advanced ASP.NET 2.0 features, ADO.NET, and SQL Server to advantage in creating a scalable, n-tier Web site.
The book begins with introductory chapters on ASP.NET 2.0, ADO.NET 2.0, and ASP.NET data source and data bound controls. Next, the book covers ASP.NET 2.0 data source and data bound controls in detail including samples and reference material. Then, the book describes advanced ASP.NET functionalities like site navigation, paging, sorting, and templates. Finally, the book illuminates ADO.NET 2.0 transactions, advanced ADO.NET features, and XML usage in SQL Server. This last section contain some real-life case studies involved with source and data bound controls.
Our author is a prolific technical writer with more than a dozen titles to his credit. This book is written in tutorial style.
All of the source code examples are in the C# language. No prior experience in ASP.NET programming or with Visual Studio 2005 is assumed.
All of the source code examples are in the C# and ASP.NET languages.
Professional ASP.NET 2.0 Databases is an excellent tutorial on intermediate to advanced ASP.NET and ADO.NET database functionality.
Now you can uncover the secrets behind accessing and retrieving data from a wide range of data sources such as SQL Server 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.
You’ll first gain an in-depth understanding of the data source controls that enable data binding in the ASP.NET platform. Next you’ll uncover the advanced features of ASP.NET, including site navigation, implementing sorting and paging, and editing data in templates. You’ll then focus on designing transactions in ADO.NET 2.0, displaying data, and utilizing SQL Server 2005 XML.
Throughout the chapters, you’ll find examples and source code (with ASP.NET examples written in C#) that you can integrate into your applications. This will enable you to leverage ADO.NET and ASP.NET features so you can easily create a scalable N-Tier web site.
Some of the topics covered include:
- ASP.NET 2.0 Data Controls
- Data Binding with the SqlDataSource Control, XML Data, and Objects
- Selecting, Updating, Deleting Records
- Programmatically Creating and Adding Controls
- XSL Transformations with XmlDataSource Control
- Using Generics with the ObjectDataSource Control
- ASP.NET 2.0 Site Navigation including Implementing Breadcrumbs and Binding to Other Controls
- Displaying and Editing Data Using Templates
- GridView Sorting and Paging
- Advanced Data Source and Data-Bound Controls including Master/Detail Display, Displaying Images :* from a Database, and Using Themes with Data Bound Controls
- Transactions in .NET and Interoperability between System.Transactions and System.EnterpriseServices
- Advanced ADO.NET for ASP.NET Data Display including DataSet Object, ADO.NET 2.0 DataTable, and Provider-Independent Data Access Code
- Accessing Data from SQL Server 2005 including CLR in SQL Server 2005, New XML Features in SQL Server 2005, and Working with XML Data-Typed Columns from ADO.NET
- N-Tier Architecture with ASP.NET 2.0 and SQL Server 2005
- Best Practices for Creating ASP.NET Web Sites including Implementation of CLR Stored Procedures and Implementation of Layers
About the author(s)
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.
Table of Contents (abbreviated)
- Part I: Introduction.
- Chapter 1: Introduction to ASP.NET 2.0.
- Chapter 2: Introduction to ADO.NET 2.0.
- Chapter 3: ASP.NET 2.0 Data Controls.
- Part II: ASP.NET 2.0 Data Source and Data Bound Controls.
- Chapter 4: Data Binding with the SqlDataSource Control.
- Chapter 5: Data Binding with XML Data.
- Chapter 6: Data Binding with Objects.
- Chapter 7: ASP.NET 2.0 Site Navigation.
- Chapter 8: Displaying and Editing Data Using Templates.
- Chapter 9: GridView Sorting and Paging.
- Chapter 10: Advanced Data Source and Data Bound Controls.
- Chapter 11: Transactions.
- Chapter 12: Case Study: Creating an Online Rental Reservation System Using N-Tier Architecture with ASP.NET 2.0 and SQL Server 2005.
- Part III: ASP.NET and XML.
- Chapter 13: Advanced ADO.NET for ASP.NET Data Display.
- Chapter 14: Accessing Data from SQL Server 2005.
- Chapter 15: Case Study: Best Practices for Creating ASP.NET Web Sites.