Chapter 9. Using the SqlDataSource Control

Listing 9.1 - ShowLocalConnection.aspx
Illustrates how to connect to a local SQL Server database.
Listing 9.2 - SqlConnectionStringBuilder.aspx
Illustrates how to sue the SqlConnectionStringBuilder class to build up a canonical connection string.
Listing 9.3 - ConnectOracle.aspx
Illustrates how to connect to an Oracle database from an ASP.NET page.
Listing 9.4 - Web.Config
Illustrates how to store a connection string in the web.config configuration file.
Listing 9.6 - Web.Config
Illustrates how to encrypt a connection string.
Listing 9.7 - ShowInlineCommands.aspx
Illustrates how to execute an inline SQL command.
Listing 9.8 - CountMoviesInCategory
Illustrates how to execute a SQL stored procedure.
Listing 9.10 - ShowFilterExpression.aspx
Illustrates how to filter database results.
Listing 9.11 - ShowDataSourceMode.aspx
Illustrates how to represent data with a SqlDataSource with either a DataSet (DataView) or DataReader.
Listing 9.12 - HandleError.aspx
Illustrates how to handle database execution errors with a SqlDataSource control gracefully.
Listing 9.13 - GridViewHandleError.aspx
Illustrates how you can handle errors with a databound control event.
Listing 9.14 - CancelCommand.aspx
Illustrates how you can cancel a database command.
Listing 9.15 - ShowDetailsView.aspx
Illustrates how to use ASP.NET parameters with the SqlDataSource control.
Listing 9.16 - ShowDetailsViewExplicit.aspx
Illustrates how to declare the size and type of parameters explicitly.
Listing 9.17 - ShowControlParameter.aspx
Illustrates how to use the ASP.NET ControlParameter object.
Listing 9.18 - ShowPageControlParameter.aspx
Illustrates how to use a ControlParameter to represent a property of the Page object.
Listing 9.19 - Vote.aspx
Illustrates how to use the ASP.NET CookieParameter object.
Listing 9.20 - ShowFormParameter.aspx
Illustrates how to use the ASP.NET FormParameter object.
Listing 9.21 - Web.config
Illustrates how to use the ASP.NET ProfileParameter object.
Listing 9.23 - ShowQueryStringParameterMaster.aspx
Illustrates how to create a master and detail pages by using the ASP.NET QueryStringParameter object.
Listing 9. 25 - ShowSessionParameter.aspx
Illustrates how to use the ASP.NET SessionParameter object.
Listing 9.26 - AddParameter.aspx
Illustrates how to add a parameter to a SqlDataSource programmatically.
Listing 9. 27 - ExecuteInsert.aspx
Illustrates how to execute the SqlDataSource Insert command outside of a databound control.
Listing 9.28 - PhotoGallery.aspx
Illustrates how to execute the SqlDataSource Select command programmatically.
Listing 9.30 - CacheSqlDataSource.aspx
Illustrates how to cache the data represented by a SqlDataSource control.

Need ASP.NET and Visual Studio 2008 Training? - Learn ASP.NET 3.5 from Stephen Walther, author of ASP.NET 3.5 Unleashed. We've provided ASP.NET training for NASA, Lockheed Martin, the National Science Foundation, Verizon, Boeing, the US House of Representatives, Kaiser, Petco, Mary Kay, and Microsoft. Why not your company?

Receive a four day, hands-on, intensive workshop.
We fly to you, anywhere in the world.
We can bring our own laptops.

To learn more, visit the Superexpert Training website.