Table of Contents
Introduction.
1. Developing Windows Forms Using Bound Controls.
Create a Bound List Box. Limit the Data Displayed
in a Bound List Box. Bind and View Individual Text Boxes Based Off a Selected
List Box Item. Edit and Update Data Using Bound Controls. Add and Delete
Records Using Bound Controls. Take Care of Error Handling with Bound Controls.
Put the Finishing Touches on a Data Bound Form. Bind Data to ComboBox and
DataGrid Controls. Drill Down to Data in the DataGrid Control.
2. Creating SQL Server Database Objects from Visual Studio .NET.
Create a New SQL Server Database from Within
Visual Studio .NET. Define Tables and Fields. Define a Primary Key and Other
Indexes. Define Relations Between Tables. Define Defaults and Constraints.
Create Views. Create Stored Procedures.
3. Viewing Data with ADO.NET.
Retrieve Data by Using the DataReader Object.
Retrieve Results from SQL Server by Using the DataTable Object. Locate Records
with the DataTable Object. Filter and Sort Records Using the DataView Object.
4. Manipulating Data with ADO.NET.
Edit Data and Update Changes That Are Made
to an ADO.NET DataSet Object. Add and Delete Rows in a Dataset with ADO.NET.
Execute Parameterized Stored Procedures in ADO.NET. Create and Execute On-the-Fly
Batch Updates by Using ADO.NET.
5. Working with Data in Web Forms.
Use Bound Controls with Web Form. Validate
Data Using Validation Controls. Populate DropDown and ListBox Controls.
Display Data Using the Table Control. Display Data Using the Repeater Control.
Display, Sort, and Page Data in the DataGrid Control. Add, Edit, and Delete
Data Using the DataGrid Control. Hyperlink from a Row in the Data Grid to
a Detail Page.
6. Creating Transact-SQL Commands.
Retrieve Unique Records Using Only a Select
Query. Use Variables and Functions in T-SQL. Use Wildcards and Ranges of
Values in a SQL Query. Find Records in a Table Without Corresponding Entries
in a Related Table? Take Advantage of Using Subqueries. Create, Modify,
and Delete Tables. Create a New Table with Data from Existing Tables? Create
and Call SQL Server 2000 User-Defined Functions.
7. Performing Common Database Tasks Using SQL-DMO.
Create a Dialog Box to Connect to a New Database,
Including Listing Available SQL Servers and Databases. Back Up and Verify
a SQL Server Database. Restore a SQL Server Database. Transfer Tables Between
SQL Server Databases. Create a Detach/Attach SQL Server Database Dialog
Box.
8. Taking Advantage of Data-Driven Techniques.
Work with Data-Bound Multi-Select List Boxes
Using Windows Forms. Use a Single Windows Form to Update Multiple Lookup
Tables. Create a Point-and-Click SQL Server Query Tool for Users Using a
Windows Form. Make a Generic Search Form in a Visual Basic .NET Desktop
Application. Work with Data-Bound Multi-Select List Boxes Using Web Forms.
Use a Single Web Form to Update Multiple Lookup Tables. Create a Point-and-Click
Query Tool for Users Using a Web Form. Make a Generic Search Form in an
ASP.NET Web Application.
9. Using Classes with Databases to Make Life Easier.
Define a Class in Visual Basic .NET. Create
a Class That Implements the Interface You Defined. Use Visual Studio .NET
Tools to Speed Up Writing ADO.NET Code. Control the Creation and Behavior
of Classes. Implement the Methods That Update the Database. Validate Data
Passed to Properties and Communicate Errors to Developers. Write Data Validation
Code That Can Be Reused in Other Classes.
10. Creating Reports Using Crystal Reports.
Create a Report Using Crystal Reports Report
Expert. Display a Report That Was Created. Add Calculated Fields to the
Crystal Reports Report. Select Whether the Report Will Be Displayed, Printed,
or Exported Using Visual Basic .NET Code. Determine Which Records Will Be
Printed at Runtime. Print Labels and Control the Order in Which Records
Will Be Printed. Create an Onscreen Report That Contains Hyperlinks.
11. Managing SQL Server Security.
Create Windows NT/2000 Users. Create Windows
NT/2000 Groups. Establish a Windows NT/2000 Authentication Mode. Establish
Mixed-Mode Authentication. Create a Standard Login. Create a Windows NT/2000
Login. Use a Fixed Server Role. Create a Database User Account. Use Statement
Permissions. Use Object Permissions. Use Fixed Database Roles. Create Custom
Database Roles. Create Application Roles.
12. Utilizing XML Data in Your Visual Basic .NET Applications.
Use XMLWriter to Create an XML Document.
Use XMLReader to Read an XML Document. Work with the XML Document Object
Model. Retrieve XML from SQL Server 2000. Work with Datasets and XML.
13. Creating XML Web Services.
Get Started with XML Web Services. Create
a Simple XML Web Service Using Parameters. Consume XML Web Services. Pass
a Dataset Back from an XML Web Service.
Appendix A. Desktop Development with ADO.
When to Use ADO (Local Database/Single Tier
Applications). Looking At the ADO Object Models. Referencing the Type Libraries.
Using the Connection Object. Working with the ADO Recordset Object. Executing
a SQL Server Stored Procedure By Using ActiveX Data Objects. Executing Batch
Updates with ADO and SQL Server. Creating SQL Server Objects with ActiveX
Data Objects. Conclusion.
Index.
About the Author
F. Scott Barker has worked as a developer in the Database field for over
13 years, first with Clipper, and with Microsoft Access for the last 6 years.
During his two years at Microsoft, Scott was a member of the Microsoft Access
and Foxpro teams. He was a Contributing Editor for two years for Access/Visual
Basic Advisor magazine, and currently writes articles for them. He has also
written for Databased Advisor Magazine, Smart Access, and Informant's Microsoft
Office and VBA Developer magazine. Scott has trained for Application Developers
Training Company and others all around the U.S. and is a frequent speaker
at Access Conferences throughout the U.S., Canada, South Asia, and Europe.
He was also rated as one of the top Access speakers at Microsoft TechEd95
U.S., and spoke at Microsoft European TechEd96.
