Visual Basic . NET database programming, Rod Stephens
Type
Label
Visual Basic . NET database programming, Rod Stephens
Language
eng
Illustrations
illustrations
Index
index present
Literary Form
non fiction
Main title
Visual Basic . NET database programming
Nature of contents
dictionaries
Oclc number
152217272
Responsibility statement
Rod Stephens
Summary
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, find specific records, sort data, perform complex queries, and use XML--an integral part of data handling in Visual Basic.NET
Table Of Contents
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 -- 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