Murach's ASP.NET 3.5 with C# 2008
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 392
A Product List application that uses two SQL data sources 392
How to create a SqlDataSource control 394
How to define the connection 396
How to save the connection string in the web.config file 398
How to configure the Select statement 400
How to create a Where clause 402
How select parameters work 404
How to use the Query Builder 406
How to create a Select statement with the Query Builder 406
How to define the parameters 408
How to use the DataList control 410
How the DataList control works 410
How to define the templates for a data list 412
How to format a data list 414
How to use data binding 416
How to bind a list control to a data source 416
How to bind the controls in a template 418
The aspx file for the Product List application 420
How to use the advanced features of a SQL data source 422
How to create a data source that can update the database 422
How to change the data source mode 424
How to use caching 424


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

Murach's ASP.NET 3.5 with C# 2008

Learn more about this book

View the table of contents


More about the eBook



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.