Murach's ADO.NET 2.0 with VB 2005
How to use SQL data source controls

This chapter begins a section on using ADO.NET features in ASP.NET applications. It shows you how to use the SQL data source control and the GridView control, which let you handle database data in web applications with little or no coding.
Chapter 11 How to use SQL data source controls
How to create a SQL data source control 346
How to add a SQL data source control to a form 346
How to define the connection 348
How to save the connection string in the web.config file 350
How to configure the Select statement 352
How to create an Order By clause 352
How to create a Where clause 354
How select parameters work 356
How to use custom SQL statements or stored procedures 358
How to use custom SQL statements 358
How to use stored procedures 358
How to define the parameters for a custom SQL statement or stored procedure 360
How to use the GridView control 362
How the GridView control works 362
How to define the fields in a GridView control 364
Elements used to create and format fields 366
How to use a SQL data source 368
A Vendor Invoices application that uses two data sources 368
How to bind a GridView control to a data source 370
How to bind a list control to a data source 372
The aspx file for the Vendor Invoices page 374
The code-behind file for the Vendor Invoices page 374
How to use the advanced features of a data source control 378
How to create a data source control that can update the database 378
How to change the data source mode 380
How to use caching 380


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

Murach's ADO.NET 2.0 with VB 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.