Professional ASP.Net 2.0 Databases (Electronic book text)

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 ControlsData Binding with the SqlDataSource Control, XML Data, and ObjectsSelecting, Updating, Deleting RecordsProgrammatically Creating and Adding ControlsXSL Transformations with XmlDataSource ControlUsing Generics with the ObjectDataSource ControlASP.NET 2.0 Site Navigation including Implementing Breadcrumbs and Binding to Other ControlsDisplaying and Editing Data Using TemplatesGridView Sorting and PagingAdvanced Data Source and Data-Bound Controls including Master/Detail Display, Displaying Images from a Database, and Using Themes with Data Bound ControlsTransactions in .NET and Interoperability between System.Transactions and System.EnterpriseServicesAdvanced ADO.NET for ASP.NET Data Display including DataSet Object, ADO.NET 2.0 DataTable, and Provider-Independent Data Access CodeAccessing 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.NETN-Tier Architecture with ASP.NET 2.0 and SQL Server 2005Best Practices for Creating ASP.NET Web Sites including Implementation of CLR Stored Procedures and Implementation of Layers