This book explains how to use ASP.NET 2.0 and SQL Server 2005 most efficiently together. It covers all crucial performance issues and illustrates optimal techniques with enterprise-quality development. Performance is always an issue, and optimizing database access is one of the most daunting performance challenges facing web developers. With Brennan Stehling as your guide, you'll explore the many overlaps of web and database technologies, including configuration, programming, performance tuning, and deployment. You'll learn how to make high-performance database access not just a goal, but a reality.

In this book, you’ll be introduced to the features and capabilities of ASP.NET 3.5, as well as the foundation that ASP.NET provides. Updated for the latest release of Visual Studio, this new edition adds five hundred pages of great new content compared to the original 2.0 version of the book. Including both printed and downloadable VB and C# code examples, this edition focuses even more on experienced programmers and advanced web development. New coverage includes new chapters on IIS 7 development, LINQ, ASP.NET, Silverlight, and many others.

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

Provides information on the features and functions of ASP.NET 2.0, covering such topics as Web server controls, working with Master Pages, themes and skins, data binding, working with XML, and caching.

The all-new approach for experienced ASP.NET professionals! ASP.NET is Microsoft's technology for building dynamically generated web pages from database content. Originally introduced in 2002, ASP.NET has undergone many changes in multiple versions and iterations as developers have gained a decade of experience with this popular technology. With that decade of experience, this edition of the book presents a fresh, new overhauled approach. A new focus on how to build ASP.NET sites and applications relying on field-tested reliable methods Integration of "One ASP.NET" philosophy treating ASP.NET Web Forms and ASP.NET MVC as equal tools each with their proper time and place Coverage of hot new ASP.NET 4.5 additions such as the Web API, Websockets and HTML5 & CSS3 use in layout but only to the extent that the tools themselves are practical and useful for working ASP.NET developers Professional ASP.NET 4.5 in C# and VB is an essential tool for programmers who need to be productive and build reliably performing sites with the latest ASP.NET Framework and Visual Studio.

What is this book about? Written by a high-profile team of ASP.NET experts, this fully updated Professional guide enables you to take full advantage of the power and possibilities of ASP.NET 1.1. You travel beyond the basics of ASP.NET Web pages, server controls, and data management to a complete understanding of Web services, debugging, performance, migration, and real-world applications. All code has been rechecked and verified to work correctly with ASP.NET 1.1, and enhancements like improved security and better performance are thoroughly examined and reviewed. This comprehensive, in-depth, practical guidebook enables you to master new levels of Web application development with the .NET Framework. What does this book cover? Here's what you will learn from this book: How to get started with ASP.NET and the .NET Framework Ways to create ASP.NET pages, work with server controls, and manage data Methods for developing, securing, and configuring Web applications Basics of base class libraries, components, and extensibility Security and performance improvements inherent in version 1.1 How Web services and ASP.NET function in the mobile arena Debugging, performance, migration, and interoperability Processes for applying this knowledge in real-world development contexts Who is this book for? This book is for programmers who have a solid understanding of ASP and want to develop sophisticated ASP.NET 1.1 applications using the .NET Framework. You should be familiar with VB or C-based syntax (C++, JavaTM, or C#).

ASP.NET Programming with C# and SQL Server, International Edition covers the basics of ASP.NET, C#, and SQL Server along with advanced topics including object-oriented programming and how to build Web sites that incorporate authentication and security. After completing this text, you will be able to use ASP.NET to build professional quality, database-driven Web sites.