Visual Basic . NET database programming
Visual Basic.NET Database Programming teaches with real-world scenarios how to load, display, manipulate, modify and save data in databases. It shows the reader how to build multi-tier applications that implement enterprise-wide business solutions, build Web Servers, manage large amounts of data, fi...
| Main Author: | |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
Indianapolis, Ind.
Que
2002
|
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- CH36;CHAPTER 10 A Single45;User Example
- A One45;Form Design
- A Tabbed Design
- Summary
- CH36;CHAPTER 11 Multi45;User Programming
- Program OrderEntryMultiUser
- Database Redesign
- Reservations
- Source Code
- Modi8226;cations
- Summary
- CH36;CHAPTER 12 Query By Example
- Features
- Programming the RecordList Form
- RecordList Form Internals
- Summary
- CH36;CHAPTER 13 Discovering Database Structure
- Learning About Servers
- Learning About Databases
- Learning About Tables
- Learning About Relationships
- Learning About Fields
- Meta45;Learning
- Program ExploreServer
- Program ExploreRelations
- Summary
- APPENDIX A SQL
- CREATE DATABASE
- DROP DATABASE
- ALTER DATABASE
- CREATE TABLE
- ALTER TABLE
- DROP TABLE
- CREATE INDEX App
- DROP INDEX
- CREATE VIEW
- DROP VIEW Part
- SELECT
- INSERT
- UPDATE
- DELETE
- Aggregate Functions
- Joins
- Summary
- APPENDIX B The Visual Basic 46;NET De
- Cover
- TOC36;Table of Contents
- INTRODUCTION
- Intended Audience
- How This Book Is Organized
- How To Use This Book
- Necessary Equipment
- Example Databases
- Online Samples44; Updates44; and Changes
- CH36;CHAPTER 1 Data Storage Alternatives
- Compiled In Data
- Registry
- Relational Databases
- Speci8226;c Relational Database Engines
- More Exotic Databases
- Summary
- CH36;CHAPTER 2 Database Design
- Application Design Approaches
- Requirements
- Entities
- Refining the Design
- Master45;Detail Relationships
- Normalization
- Keys
- Indexes
- Constraints
- Design Tools
- Designing Databases With Microsoft Access
- Building a Database with SQL
- Summary
- CH36;CHAPTER 3 Security
- Degrees of Security
- Controlling Privileges
- Controlling Access with Views
- SQL Server Security Procedures
- Summary
- CH36;CHAPTER 4 Off to See the Wizard
- Data Link Properties
- The Data Form Wizard
- Query Builder
- Data Adapter Con8226;guration Wizard
- Using The Data Adapter
- Summary
- CH36;CHAPTER 5 The DataSet Family of Objects
- DataSet
- DataTable
- DataRow
- DataColumn
- DataRelation
- DataView
- DataRowView
- Summary
- CH36;CHAPTER 6 Database Connections
- Data Connection Methods
- Program45;Generated Data
- XML Data
- SQL Server
- OLE DB
- Example Program RunScript
- Summary
- CH36;CHAPTER 7 XML Databases
- What Is XML63;
- Editing XML Files
- Schemas
- Loading XML Data in Visual Basic
- Saving XML Data From Visual Basic
- Overwriting Files
- Summary
- CH36;CHAPTER 8 Bound Controls
- Basic Binding
- Record Selection with Bound Controls
- Selecting a Calculated Field
- A TreeView Display
- DataViews
- Binding Controls with Code
- DataGrid
- Summary
- CH36;CHAPTER 9 Data Safety
- EasyDraw
- Storing Data
- Drawing Existing Objects
- Drawing New Objects
- DataSafe
- Menu Commands
- MRU List
- Data Validation
- Summary