Programming Data-Driven Web Applications with ASP.NET provides readers with a solid understanding of ASP.NET and how to effectively integrate databases with their Web sites. The key to making information instantly available on the Web is integrating the Web site and the database to work as one piece. The authors teach this using ASP.NET, server-side controls, ADO+, XML, and SOAP. The authors will teach readers how to manage data by using ASP.NET forms, exposing data through ASP+ Web Services, working with BLOBs, and using cookies and other features to secure their data.
(NOTE: Each chapter concludes with a Summary.)
I. WHAT IS .NET?1. What Is ASP.NET?
The Major Differences Between ASP and ASP.NET. Breaking Down the Parts of ASP.NET.2. What Is ADO.NET?
ADO.NET Explained. The Benefits of ADO.NET. ADO.NET Document Object Model.
II. READING AND DISPLAYING DATA.3. ADO.NET Managed Providers.
The Two Managed Providers. Managed Connections. Managed Commands. The DataReader. Managed Commands with Stored Procedures. The DataAdapter. Table and Column Mappings.4. Basic ANSI-SQL.
Setting Up Your Workspace. Getting Data from a Database. The WHERE Clause. The SubQuery. SQL Joins. Sorting Data. Updating Existing Data. Inserting New Data. Deleting Existing Data.5. Using a Basic DataGrid.
The ASP.NET DataGrid. Data Binding. Binding to Arrays. Binding to Collections. Binding to Properties. Binding to XML Files.6. Altering DataGrid Output.
Understanding DataGrid Properties. Paging with the DataGrid. Sorting Columns. BoundColumns.7. Working with ASP.NET Server Controls Templates.
What Is a Template? DataGrid .NET Server Control. DataList .NET Server Control. Repeater .NET Server Control.
III. UPDATING AND INPUTTING DATA.8. Gathering Data with ASP.NET Web Forms.
Button ASP.NET Server Control. TextBox ASP.NET Server Control. DropDownList ASP.NET Server Control. ListBox ASP.NET Server Control. CheckBox ASP.NET Server Control. CheckBoxList ASP.NET Server Control. RadioButton ASP.NET Server Control. RadioButtonList ASP.NET Server Control.9. Evaluating Data with ASP.NET Validation Controls.
Validation Controls and How They Work. Shared Validator Attributes. The RequiredFieldValidator Control. The RegularExpressionValidator Control. The CompareValidator Control. The RangeValidator Control. The CustomValidator Control. The ValidationSummary Control. One Control, Multiple Validators.10. Inputting and Editing Data Using the DataGrid and DataList.
An Overview of Editing Functions. Enabling Editing Using the DataGrid. Enabling Editing Using the DataList. Changing Output with the ItemCreated Event Using the DataGrid _and DataList. Enabling Item Selection Using the DataGrid and DataList. Tip-Using a DropDownList in a DataGrid.11. Editing and Filtering Data.
The DataTable Versus DataView. The DataTable: Filtering, Adding, Editing, Sorting, and Deleting _DataRows. The DataView: Filtering, Adding, Editing, Sorting, and Deleting. _DataRowViews. Using the SqlCommandBuilder to Save Changes Back to Your _Database. Bringing It Together.
IV. ADVANCED DATA CONCEPTS.12. XML and SOAP.
What Is XML? A Quick Refresher. Xml Server Control. XmlDocument and XslTransform. Working with XML Elements. Reading and Writing XML Files with the DataSet. SOAP (Simple Object Access Protocol).13. BLOB Uploading and Displaying.
Uploading Files Using HtmlInputFile. Using the HttpPostedFile. Working with the In Memory File-Saving it to a Database. Retrieving and Showing an Image from a Database.14. Exposing Data Through Web Services.
What Are Web Services? Building Simple Output Web Services. Building Input/Output Web Services. Consuming Web Services.15. Authentication.
Security Configuration. Types of Authentication. Using Forms Authentication. Role-based Forms Authentication.16. Data Caching.
What Is Caching? Using the Page Output Cache. Using the HttpCachePolicy Class to Enable Output Caching. Using Fragment Caching. Using the Cache APIs. Caching in Web Services.
V. APPENDIXES.Appendix A. ASP.NET Server Controls Reference.
ASP.NET Intrinsic Server Controls. ASP.NET Rich Server Controls. ASP.NET Style Objects.Appendix B. ADO.NET Object Model.
The Major Components of an ADO.NET Solution. ADO.NET Object Model. ASP.NET Managed Providers.Index.