Beginning Visual Basic .Net Databases

by Reynolds, Matthew Et Al

• ISBN13: 9781861005557
• ISBN10: 1861005555
• Edition: 1st
• Format: Trade Paper
• Copyright: 2001-10-01
• Publisher: Springer-Verlag New York Inc

Summary

Teaches you how to build Visual Basic .NET applications that make effective use of databases. Every new concept is explained thoroughly with Try It Out examples, plenty of code samples, and end-of-chapter questions to test you. Softcover.

Table of Contents

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