Vrat Agarwal / Huddleston Beginning VB 2008 Databases

From Novice to Professional
1. ed
ISBN: 978-1-4302-0560-9
Verlag: Apress
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 409 Seiten

Beginning Visual Basic 2008 Databases teaches you everything you need to know about relational databases, SQL, and ADO.NET 2.0. It gives you a sound start in developing console and Windows database applications. The book also includes chapters on the new SQL Server XML data type and the forthcoming LINQ enhancements to the next version of Visual Basic. In addition to teaching you such basics as using SQL to communicate with databases, this book provides you with detailed, code-practical techniques to access data in VB 2008 across a range of coding situations.

Vidya Vrat Agarwal, a Microsoft .NET purist and an MCT, MCPD, MCTS, MCSD.NET, MCAD.NET, and MCSD, works with Lionbridge Technologies (NASDAQ: LIOX), and his business card reads 'Subject Matter Expert' (SME). He is also a lifetime member of the Computer Society of India (CSI). He started working on Microsoft .NET with its beta release. He has been involved in software development, evangelism, consultation, corporate training, and T3 programs on Microsoft .NET for various employers and corporate clients. His articles can be read at ProgrammersHeaven.com, and he also reviews .NET preparation kits, available at UCertify.com. He has contributed as technical reviewer to many books published by Apress, including Beginning VB 2008 Databases: From Novice to Professional. He lives with his beloved wife, Rupali, and lovely daughter, Vamika ('Pearly'). He believes that nothing will turn into a reality without them. He is the follower of the concept 'No pain, no gain' and believes that his wife is his greatest strength. He is a bibliophile; when he is not working on technical stuff, he likes to be with his family and also likes reading spiritual and occult science books. He blogs at http://Dotnetpassion.blogspot.com. You can reach him at [e-mail].

Autoren/Hrsg.

Vrat Agarwal, Vidya

Huddleston, James

Inhaltsverzeichnis

1;Contents at a Glance;5
2;Contents;6
3;About the Authors;19
4;About the Technical Reviewer;20
5;Acknowledgments;21
6;Introduction;22
6.1;Who This Book Is For;22
6.2;What This Book Covers;22
6.3;How This Book Is Organized;23
6.4;How to Download the Sample Code;23
6.5;Contacting the Author;23
7;Getting Your Tools;24
7.1;Obtaining Visual Studio 2008;25
7.2;Installing SQL Server Management Studio Express;26
7.3;Installing the Northwind Sample Database;27
7.4;Installing the AdventureWorks Sample Database;32
7.5;Summary;36
8;Getting to Know Your Tools;37
8.1;Microsoft . NET Framework Versions and the Green Bit and Red Bit Assembly Model;37
8.2;Using Microsoft Visual Studio 2008;38
8.3;Using SQL Server Management Studio Express;42
8.4;Summary;46
9;Getting to Know Relational Databases;47
9.1;What Is a Database?;47
9.2;Choosing Between a Spreadsheet and a Database;48
9.3;Why Use a Database?;48
9.4;Benefits of Using a Relational Database Management System;48
9.5;Comparing Desktop and Server RDBMS Systems;49
9.6;The Database Life Cycle;50
9.7;Mapping Cardinalities;51
9.8;Understanding Keys;53
9.9;Understanding Data Integrity;54
9.10;Normalization Concepts;55
9.11;Drawbacks of Normalization;56
9.12;Summary;56
10;Writing Database Queries;57
10.1;Comparing QBE and SQL;57
10.2;Beginning with Queries;59
10.3;Common Table Expressions;60
10.4;GROUP BY Clause;62
10.5;PIVOT Operator;64
10.6;ROW_ NUMBER() Function;66
10.7;PARTITION BY Clause;67
10.8;Pattern Matching;68
10.9;Aggregate Functions;73
10.10;DATETIME Functions;75
10.11;Joins;77
10.12;Summary;87
11;Manipulating Database Data;88
11.1;Retrieving Data;88
11.2;Using SELECT INTO Statements;97
11.3;Inserting Data;102
11.4;Updating Data;104
11.5;Deleting Data;107
11.6;Summary;108
12;Using Stored Procedures;109
12.1;Creating Stored Procedures;109
12.2;Modifying Stored Procedures;116
12.3;Displaying Definitions of Stored Procedures;118
12.4;Renaming Stored Procedures;119
12.5;Working with Stored Procedures in VB . NET;120
12.6;Deleting Stored Procedures;126
12.7;Summary;127
13;Using XML;128
13.1;Defining XML;128
13.2;Why XML?;129
13.3;Benefits of Storing Data As XML;129
13.4;Understanding XML Documents;130
13.5;Understanding the XML Declaration;131
13.6;Converting Relational Data to XML;132
13.7;Using the xml Data Type;138
13.8;Summary;140
14;Understanding Transactions;141
14.1;What Is a Transaction?;141
14.2;When to Use Transactions;142
14.3;Understanding ACID Properties;142
14.4;Transaction Design;143
14.5;Transaction State;144
14.6;Specifying Transaction Boundaries;144
14.7;T- SQL Statements Allowed in a Transaction;145
14.8;Local Transactions in SQL Server 2005;145
14.9;Distributed Transactions in SQL Server 2005;146
14.10;Guidelines to Code Efficient Transactions;147
14.11;How to Code Transactions;148
14.12;Summary;159
15;Getting to Know ADO.NET;160
15.1;Understanding ADO. NET;160
15.2;The Motivation Behind ADO. NET;161
15.3;Moving from ADO to ADO. NET;161
15.4;Understanding ADO. NET Architecture;164
15.5;Working with the SQL Server Data Provider;166
15.6;Working with the OLE DB Data Provider;171
15.7;Working with the ODBC Data Provider;175
15.8;Data Providers As APIs;184
15.9;Summary;185
16;Making Connections;186
16.1;Introducing the Data Provider Connection Classes;186
16.2;Connecting to SQL Server Express with SqlConnection;187
16.3;Improving Your Use of Connection Objects;194
16.4;Connecting to SQL Server Express with OleDbConnection;198
16.5;Summary;201
17;Executing Commands;202
17.1;Creating a Command;202
17.2;Executing Commands;207
17.3;Executing Commands with Multiple Results;210
17.4;Executing Statements;212
17.5;Command Parameters;215
17.6;Summary;219
18;Using Data Readers;220
18.1;Understanding Data Readers in General;220
18.2;Getting Data About Data;231
18.3;Getting Data About Tables;235
18.4;Using Multiple Result Sets with a Data Reader;238
18.5;Summary;241
19;Using Datasets and Data Adapters;242
19.1;Understanding the Object Model;243
19.2;Working with Datasets and Data Adapters;246
19.3;Propagating Changes to a Data Source;261
19.4;Concurrency;275
19.5;Using Datasets and XML;276
19.6;Using Data Tables Without Datasets;279
19.7;Understanding Typed and Untyped Datasets;281
19.8;Summary;282
20;Building Windows Forms Applications;284
20.1;Understanding Windows Forms;284
20.2;User Interface Design Principles;285
20.3;Best Practices for User Interface Design;285
20.4;Working with Windows Forms;287
20.5;Understanding the Design and Code Views;290
20.6;Sorting Properties in the Properties Window;291
20.7;Setting Properties of Solutions, Projects, and Windows Forms;293
20.8;Working with Controls;294
20.9;Setting Dock and Anchor Properties;297
20.10;Adding a New Form to the Project;302
20.11;Implementing an MDI Form;305
20.12;Summary;309
21;Building ASP.NET Applications;310
21.1;Understanding Web Functionality;310
21.2;Introduction to ASP. NET and Web Pages;311
21.3;Understanding the Visual Studio 2008 Web Site Types;312
21.4;Layout of an ASP. NET Web Site;315
21.5;Using Master Pages;323
21.6;Summary;328
22;Handling Exceptions;329
22.1;Handling ADO. NET Exceptions;329
22.2;Handling Database Exceptions;337
22.3;Summary;346
23;Working with Events;347
23.1;Understanding Events;347
23.2;Properties of Events;348
23.3;Design of Events;348
23.4;Common Events Raised by Controls;349
23.5;Event Generator and Consumer;349
23.6;Summary;357
24;Working with Text and Binary Data;358
24.1;Understanding SQL Server Text and Binary Data Types;358
24.2;Storing Images in a Database;359
24.3;Retrieving Images from a Database;366
24.4;Working with Text Data;370
24.5;Summary;379
25;Using LINQ;380
25.1;Introduction to LINQ;380
25.2;Architecture of LINQ;382
25.3;LINQ Project Structure;383
25.4;Using LINQ to Objects;384
25.5;Using LINQ to SQL;387
25.6;Using LINQ to XML;391
25.7;Summary;393
26;Using ADO.NET 3.5;394
26.1;Understanding ADO. NET 3.5 Entity Framework;394
26.2;Understanding the Entity Data Model;395
26.3;Working with the Entity Data Model;395
26.4;Summary;409
27;Index;410