ISBN.nu logo
isbn.nu
search for books and compare prices
Search >
Tables of Contents for Beginning Visual Basic .Net Databases
Chapter/Section Title
Page #
Page Count
Introduction
1
1
Who is This Book for?
2
1
What Does This Book Cover?
2
1
What Do I Need to Use this Book?
2
1
Conventions
3
1
Customer Support
4
5
How to Download the Sample Code for the Book
4
1
Errata
5
1
E-mail Support
5
1
p2p.wrox.com
6
3
Relational Database Design
9
30
What is a Database?
10
2
Flat File Versus Relational Databases
10
2
Determining Database Requirements
12
3
Analyzing Our Business Needs
12
2
Determining the Information To Be Tracked
14
1
Determining the Logical Database Design
15
21
Defining Tables (Entities) and Fields (Attributes)
15
1
Identifying Tables and Fields
15
5
Identifying Keys
20
1
Primary Keys
20
1
Foreign Keys
21
2
Defining Relationships
23
1
One-To-One Relationships
23
1
One-To-Many Relationships
24
1
Many-To-Many Relationships
24
2
Referential Integrity
26
1
Normalizing the Data
26
1
First Normal Form
27
5
Second Normal Form
32
1
Third Normal Form
33
1
When To Denormalize
34
1
Defining Indexes
34
2
Testing the Logical Database Design
36
1
Implementing the Physical Database Design
36
1
Create, Test, and Refine
36
1
Summary
37
1
Exercises
37
2
Microsoft SQL Server 2000 Desktop Engine
39
38
The Microsoft SQL Server 2000 Desktop Engine
39
3
Microsoft SQL Server 2000 Defined
40
1
Why Use Desktop Engine Instead of Access?
41
1
Obtaining and Installing Desktop Engine
42
4
Where to Get a Copy of Desktop Engine
43
1
Installation Requirements
43
1
How To Install Desktop Engine
43
1
Understanding What was Installed
44
1
SQL Server Service
44
1
SQL Server Agent
44
1
Distributed Transaction Coordinator
44
1
Managing the Services with SQL Server Service Manager
44
2
Using Access to Work with Desktop Engine / SQL Server
46
27
Creating a New Desktop Engine / SQL Server Database from Microsoft Access
47
18
Upsizing an Existing Access Database To SQL Server 2000 Desktop Engine
65
8
Other Ways of Creating and Managing Desktop Engine Databases
73
1
Summary
74
1
Exercises
74
3
Querying the Database
77
26
Querying SQL Server Desktop Engine Databases
77
23
Transact SQL (T-SQL) versus Jet SQL
78
1
The Basics of T-SQL
78
1
Selecting Data from the Database
78
6
Filtering Data with WHERE
84
6
Modifying Data with INSERT, UPDATE, and DELETE
90
3
Beyond the Basics
93
1
Sorting Data with ORDER BY and GROUP BY
93
4
Retrieving Data from Multiple Tables Using JOINS
97
1
Retrieving Distinct Data
98
1
Using Subqueries
99
1
Unions
100
1
Summary
100
1
Exercises
101
2
Exploring the Server Explorer
103
24
Managing SQL Server Databases Using Server Explorer
103
15
The Views Node
103
4
The Stored Procedures Node
107
3
The Tables Node
110
6
The Database Diagrams Node
116
2
The Functions Node
118
1
Exploring the Rest of Server Explorer
118
6
SQL Server Databases Node
118
1
SQL Server Instances Node
119
3
Servers Node
122
2
The Data Connections Node
124
1
Summary
124
1
Exercises
125
2
The User Interface for the Database
127
46
The User Interface
128
1
Creating a Simple Database Application
129
38
A Brief Introduction to ADO.NET
130
1
The Data Source
131
1
The Data Connection
131
1
The DataAdapters
132
1
The DataSet
133
12
Building the Data Container
145
3
Binding Data to Controls
148
6
Displaying Database Information to the User
154
1
Compiling and Running the Project
154
2
What's Behind the Curtain?
156
5
Adding Additional Tables
161
6
Good Form Design
167
2
Summary
169
1
Questions
170
3
Data Access with ADO.NET
173
64
A Short History of Data Access
174
4
Data Access Technologies
175
3
Application Architectures
178
4
Client-Server
178
2
3-Tier
180
1
n-Tier
181
1
Current State of ADO
182
1
ADO's Strengths and Weaknesses
182
1
ADO.NET
183
54
Comparisons to ADO
184
1
ADO.NET Architecture
184
1
The DataSet Object
185
1
The DataTable Object
186
1
The DataColumn Object
187
2
The DataRow Object
189
7
The DataRelation Object
196
1
The Constraints Object
197
2
Updating the Database
199
3
DataSet Sample
202
9
ADO.NET Namespaces
211
2
The System.Data Namespace
213
1
The System.Data.OleDb and System.Data.SqlClient Namespaces
214
1
The System.Xml Namespace
215
1
Dataflow in ADO.NET
215
1
.NET Data Providers
216
11
DataReader Sample Project
227
8
Summary
235
1
Questions
235
2
Reading Data Into the DataSet
237
56
The Product Management System Overview
237
5
Creating the User Interface for the Search Screens
242
21
Creating the Base Search Form Project
243
11
Inheriting from the Base Search Form
254
4
Implementing the Unique Functionality of the Products Search Form
258
3
Implementing the Unique Functionality of the Suppliers Search Form
261
2
Using the DataSet to Retrieve Data
263
27
The DataSet Object
263
1
Populating a DataSet from Multiple Tables and Relating Them to Each Other
264
9
Populating a DataSet from a SQL Statement
273
2
Building the SQL Statement Based on User Input
275
15
Summary
290
1
Exercises
290
3
Data Binding
293
48
Simple Versus Complex Data Binding
293
33
Binding the Results To the DataGrid
294
3
Displaying the Search Results in the DataGrid
297
5
Creating the Base Add/View/Edit Form
302
11
Inheriting from the Base Data Form
313
1
Implementing the Unique Functionality of the Add/View/Edit Products Form
314
6
Implementing the Unique Functionality of the Add/View/Edit Suppliers Form
320
2
Making the DataSets Accessible
322
1
Ready to Roll
323
3
Validating User Input
326
6
Other Data Considerations
332
6
Using DataViews to Filter and Sort Data
332
3
Using the DataReader to Retrieve Single Rows
335
3
Summary
338
1
Exercises
338
3
Updating the DataSet and Handling Errors
341
40
Updating the Local Version of the DataSet
341
9
Modifying the Add/View/Edit Products and Suppliers Screens to Update the Local DataSet
342
1
Adding a New Record to the Local DataSet
342
2
Deleting a Record in the Local DataSet
344
3
Modifying an Existing Record in the Local DataSet
347
3
Saving the Changes to the Database
350
25
Handling Changed Records
351
12
Handling Deleted Records
363
4
Handling Added Records
367
8
Testing the New Capabilities of Our Forms
375
3
Summary
378
1
Exercises
379
2
Conflict Resolution
381
26
Handling Data Update Conflicts
381
17
Handling Update Conflicts with Optimistic or Pessimistic Concurrency
383
1
Implementing Optimistic Concurrency with DataSets
384
1
Version Number or Timestamp Method
384
12
The Saving All Values Method
396
2
Transactions
398
2
Transactions in Database Applications
398
2
Product Management System Tour
400
4
Running a Complex Products Search
400
1
Modifying Records Returned in the Search
401
1
Adding a New Record
402
2
Generate an Update Conflict
404
1
Summary
404
1
Exercises
405
2
ASP.NET
407
44
An Introduction
408
13
Suppliers and Products
411
9
Grid Layout vs. Flow Layout
420
1
An Inventory Web Application
421
13
Searching for Products
422
2
Improving Presentation of the DataGrid
424
2
Adding a Unit Price Column
426
1
Adding an InStock Column
427
4
Paging
431
3
Updating with Web Forms
434
15
Looking up Customers
435
6
Saving Changes
441
2
Adding Other Fields
443
3
Validating Data
446
2
Further Validation Controls
448
1
Summary
449
1
Exercises
449
2
ADO.NET and XML
451
52
What is XML?
451
4
A Sample XML Document
452
3
Attributes
455
1
Creating an XML Document
455
7
Saving DataSets as XML
456
6
Loading and Saving XML Data
462
13
Schemas
464
4
Checking the Validity of a Document
468
2
Checking Validity
470
5
Relational Data
475
6
Saving the DataSet
478
1
Loading the DataSet Again
479
2
XmlDataDocument
481
16
Changing the XML Changes the DataSet
481
1
Making Changes
482
5
Nodes
487
3
Changing the DataSet Changes the XML
490
7
Simplifying Data Manipulation with Typed DataSets
497
2
Summary
499
1
Exercises
500
3
Web Services
503
56
Building a Web Service
504
23
Designing Our Web Service
504
7
Finding the Code
511
1
SOAP Namespaces
511
1
Returning Shipping Details for an Order
512
1
Returning Shipping Details
513
3
Security Considerations
516
1
The GetShippingDetails Method
516
3
Building the GetShippingDetails Method
519
8
Consuming a Web Service
527
11
Testing More Eventualities
537
1
Error Logging
538
4
Logging Problems
538
4
Debugging SOAP
542
3
Directory Services
545
10
UDDI
545
3
Web Service Brokerages
548
1
SMS Messaging
549
1
Registering for the Service
549
2
Referencing the Web Service
551
1
Sending Messages
552
3
Summary
555
1
Exercises
556
3
Disconnected Data
559
64
Disconnected Data Access
559
2
A Data Access Layer
560
1
Building the Application
561
39
Retrieving Products
565
2
The ``Provider'' Class
567
2
The ConnectionMode and Connection Properties
569
2
Returning Data
571
7
Overriding the ToString Method
578
1
Remote Connections
579
5
Using the Remote Connection Mode
584
2
Creating RemoteConnection
586
1
A Slight Change to the Client
587
2
Switching Modes
589
1
Automatically Detecting the Connection Type
590
7
Exception Handling
597
3
Changing Data
600
12
Choosing Suppliers
600
1
Building the ``ProviderGetSuppliers'' Stored Procedure
600
1
Calling ``ProviderGetSuppliers''
601
5
Changing the Selected Supplier
606
5
Calling ``GetSuppliers'' from the Web Service
611
1
Saving Changes
612
9
Building ``SetProductDetails''
613
3
Testing the Changes
616
3
Saving Changes Over the Web Service
619
2
Summary
621
1
Exercises
621
2
Case Study - B2B Application Integration Using XML
623
58
Defining the Schema
624
3
Placing the Order
627
12
Transferring the Document
638
1
Web Service
638
1
FTP
638
1
E-mail
639
1
Message Queuing
639
1
Proprietary
639
1
Receiving and Processing the Order
639
39
Creating the Service
640
6
Responding to Order Requests
646
8
Processing the Order
654
14
Building the Windows Service
668
4
Sending the Order via a Web Service
672
6
Summary
678
3
Index
681