Beginning Visual Basic .Net Databases,9781861005557

Beginning Visual Basic .Net Databases

by
Edition: 1st
ISBN13: 9781861005557
ISBN10: 1861005555
Format: Trade Paper
Pub. Date: 2001-10-01
Publisher(s): Springer-Verlag New York Inc
  • Free Shipping Icon

    This Item Qualifies for Free Shipping!*

    *Excludes marketplace orders.

List Price: $52.49

Rent Book

Select for Price
Add to Cart
There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Buy from our Marketplace starting at $19.78

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

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

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.