Murach's ASP.NET 2.0 with C# 2005
How to use SQL data sources

This chapter shows you how to use the SqlDataSource control to access the data in a SQL Server database with little or no programming. Along the way, you'll learn how to use the DataList control to display lists of data in your ASP.NET applications.
Chapter 13 How to use SQL data sources
How to create a SQL data source 372
A Product List application that uses two SQL data sources 372
How to create a SqlDataSource control 374
How to define the connection 376
How to save the connection string in the web.config file 378
How to configure the Select statement 380
How to create a Where clause 382
How select parameters work 384
How to use the Query Builder 386
How to create a Select statement with the Query Builder 386
How to define the parameters 388
How to use the DataList control 390
How the DataList control works 390
How to define the templates for a data list 392
How to format a data list 394
How to use data binding 396
How to bind a list control to a data source 396
How to bind the controls in a template 398
The aspx file for the Product List application 400
How to use the advanced features of a SQL data source 402
How to create a data source that can update the database 402
How to change the data source mode 404
How to use caching 404


© Copyright 1998-2008 Mike Murach & Associates, Inc.  All rights reserved.

Murach's ASP.NET 2.0 with C# 2005

Learn more about this book

View the table of contents

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.