Murach's ASP.NET 2.0 Upgrader's Guide: C# Edition
How to use SQL and XML data sources

Data source controls are one of the most important new features of ASP.NET 2.0. In this chapter, you'll learn how to use the SQL and XML data sources to access data from a SQL Server database or an XML file with little or no programming.

Chapter 4 How to use SQL and XML data sources
An application that uses the new data access features 104
The Product List application 104
The design of the Halloween database 106
How to use a SQL data source 108
How to create a SQL data source 108
How to define the connection 110
How to save the connection string in the web.config file 112
How to configure the SELECT statement 114
How to create a WHERE clause 116
How select parameters work 118
How to use the Query Builder 120
How to create a SELECT statement with the Query Builder 120
How to define the parameters 122
How to use data binding 124
How to bind a list control to a data source 124
How to use the ASP.NET 2.0 Eval and Bind methods to bind data 126
The aspx file for the Product List application 128
How to use the advanced features of a SQL data source 130
How to create a data source that can update the database 130
How to change the data source mode 132
How to use caching 132
How to create and use a SQL cache dependency 134
How to use an XML data source 136
XML files that contain category and product data 136
How to create an XML data source 138
How to use XPath expressions for data sources and data binding 140
The aspx file for the XML version of the Product List application 142
The code-behind file for the XML version of the Product List application 144




Murach's ASP.NET 2.0 Upgrader's Guide: C# Edition

Learn more about this book

Add this book to your cart



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.