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




Murach's ASP.NET 2.0 Upgrader's Guide: VB 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.