CourseSmart Reader

Advanced Program Using Visual Basic 2008, 4th Edition

by Bradley, Julia Case; Millspaugh, Anita

Publisher: McGraw-Hill Higher Education

Publishing Date: 2009/01/16

eText ISBN-10

0-07-729840-3

eText ISBN-13

978-0-07-729840-1

Print ISBN-10

0-07-351722-4

Print ISBN-13

978-0-07-351722-3

Saleable Print ISBN-10

0-07-351722-4

Saleable Print ISBN-13

978-0-07-351722-3

Table of Contents

1. Visual Studio and the .NET Framework, 1

The .NET Framework, 2

The Common Language Runtime, 2

The Class Library, 2

Compiling to Intermediate Language, 4

The References Collection, 5

Visual Studio, 6

Temporary Projects, 6

Setting Environment Options, 7

The Solution Explorer, 8

Partial Classes, 11

The Project Designer, 12

Deploying Windows Applications, 13

The VB My Objects, 13

Using Assembly Information, 14

Setting the Assembly Information, 14

Retrieving the Assembly Information, 16

Viewing a Program's Attributes, 17

Menus, Toolbars, and Status Bars, 18

Creating Menus with MenuStrips, 18

Creating Context Menus with ContextMenuStrips, 21

Creating Toolbars with ToolStrips, 22

Creating Status Bars with StatusStrips, 23

MDI Applications, 25

Multiple Document Interface, 25

Creating an MDI Project, 26

Adding a Window Menu, 26

The Singleton Design Pattern, 28

Splash Screen Forms, 29

About Box Forms, 31

Class Diagrams, 31

Creating a Class Diagram, 31

Customizing a Class Diagram, 32

Your Hands-On Programming Example, 34

2. Building Multitier Programs with Classes, 49

Object-Oriented Programming, 50

OOP Terminology, 50

Reusable Objects, 53

Multitier Applications, 53

Creating Classes, 54

Designing Your Own Class, 54

Creating Properties in a Class, 54

Constructors and Destructors, 56

A Basic Business Class, 58

Throwing and Catching Exceptions, 60

Alternatives to Exception Handling, 62

Modifying the User Interface to Validate at the Field Level, 63

Modifying the Business Class, 68

Displaying the Summary Data, 72

Namespaces, Scope, and Accessibility, 74

Accessibility Domains, 76

Creating Classes that Inherit, 77

Adding a New Class File, 77

Creating a Constructor, 78

Inheriting Variables and Methods, 78

Using Properties and Methods of the Base Class, 79

Passing Control Properties to a Component, 80

Creating an Enumeration, 81

Garbage Collection, 83

Your Hands-On Programming Example, 84

3. Windows Database Applications, 105

Visual Studio and Database Applications, 106

Accessing Data in the .NET Framework, 107

The Visual Studio IDE, 110

Creating a Database Application, 111

Local Database Files, 112

Creating a Windows Database Application—Step-by-Step, 112

Displaying Data in Individual Fields—Step-by-Step, 117

Selecting the Control Type for Details View, 118

Setting the Captions for Database Fields, 119

Formatting Bound Data, 120

Selecting a Record from a List, 123

Populating Combo Boxes with Data, 123

Adding a Combo Box for Selection—Step-by-Step, 124

Adding an Expression to Concatenate Fields, 125

Adding a Concatenated Field—Step-by-Step, 126

Sorting the Data for the ListBox, 127

Sorting with the BindingSource, 127

Modifying the SQL Select Statement, 127

Eliminating Unnecessary SQL Queries, 130

Using a Stored Procedure, 131

Creating a Stored Procedure in the VS IDE, 131

Retrieving Data by Using a Stored Procedure, 132

Multiple Tiers, 133

Creating a Data-Tier Component, 133

Coding the Form's Database Objects, 134

Binding Data Fields to Form Controls, 135

Creating a Data Tier—Step-by-Step, 137

Your Hands-On Programming Example, 141

4. Windows Database Using Related Tables, 149

Data Relationships, 150

One-to-Many Relationships, 150

Many-to-Many Relationships, 150

One-to-One Relationships, 151

Constraints, 152

Related Tables, 153

Creating a DataSet with More Than One Table, 153

Displaying Master/Detail Records—Step-by-Step, 153

Viewing or Setting a Relationship, 157

Creating a Table Lookup—Step-by-Step, 157

Queries and Filters, 159

Using a Parameterized Query, 160

Creating a Parameterized Query—Step-by-Step, 160

Filtering a DataSet, 162

Filtering a DataSet—Step-by-Step, 164

Unbound Data Fields, 166

Referring to Records and Fields, 167

Retrieving a Related Parent Row, 168

Retrieving Related Child Rows, 170

Many-to-Many Relationships, 172

Retrieving Matching Rows, 173

The Titles Authors M:N Program, 175

Multitier Considerations, 178

Formatting a Grid at Run Time, 178

Your Hands-On Programming Example, 179

5. Windows Database Updates, 187

A Simple Update in a Grid, 188

Updating a DataSet, 188

Database Handling in the Visual Studio IDE, 189

The Data Objects, Methods, and Properties, 191

The TableAdapter and TableAdapterManager, 194

The BindingSource Object, 195

Binding Source Properties and Methods, 196

Binding Source Update Methods, 197

Binding Source Events, 198

DataSet Updating, 198

SQL Statements for Updates, 198

Concurrency, 199

Testing Update Programs, 199

Updating a DataSet in Bound Controls, 199

The Logic of an Update Program, 200

User Options during an Update, 201

The Add and Save Logic, 202

The Delete and Cancel Logic, 204

The Edit Logic, 205

A Complete Update Program, 206

Navigating from a Combo Box Selection, 210

Validating User Input Data, 212

Checking for Nulls, 212

Adding Validation to a Details View Program, 213

Adding Validation to the DataSet for a DataGridView Program, 215

Handling Data Exceptions, 217

The DataGridView DataError Event, 217

The BindingSource DataError Event, 218

Updating Related Tables, 218

Parent and Child Relationships, 219

Hierarchical Updates, 220

A Related Table Update Program—Step-by-Step, 220

Security Considerations, 232

Your Hands-On Programming Example, 232

6. Services, 249

Concepts and Terminology, 250

Windows Communication Foundation (WCF), 251

More Acronyms, 252

Creating a WCF Service, 252

Create a Hello World Service—Step-by-Step, 252

Testing a Service—Step-by-Step, 255

Consuming a WCF Service, 256

Create a Project to Consume the Service—Step-by-Step, 256

Performing Calculations in a WCF Service, 259

Accessing Data through a WCF Service, 261

Creating a Data WCF Service—Step-by-Step, 261

The DataSet Merge Method, 266

Placing Validation and Access Code in the Data-Tier Projects, 266

Writing Validation Code, 267

Setting Properties of the Dataset Fields, 268

Working with Related Tables, 268

Your Hands-On Programming Example, 268

7. Web Applications, 275

Web Applications, 276

Client/Server Web Applications, 276

Types of Web Sites, 278

File System Web Sites, 278

IIS Web Sites, 279

Remote Sites and FTP Sites, 279

Creating Web Sites, 279

Web Page Files, 280

Web Forms in the Visual Studio IDE, 281

Control Types, 282

Event Handling, 284

Button Controls, 285

The Hyperlink Control, 287

Including Images on Web Pages, 288

The Calendar Control, 289

Layout and Design of Web Forms, 290

Current Standards for Page Layout, 291

Cascading Style Sheets, 291

Using DIV Elements to Lay Out a Web Page, 295

Creating a Page Layout—Step-by-Step, 295

Master Pages and Content Pages, 304

Creating a Master Page—Step-by-Step, 305

Setting the Tab Order, 311

Using the Validation Controls, 312

Displaying Asterisks, 314

Testing for Validity, 314

The Web Application Objects, 315

State Management, 315

Overview of State Management Techniques, 316

Application and Session Objects, 317

The ViewState, 319

Retaining the Values of Variables, 319

Login Features, 321

The Login Controls, 321

Adding Login Controls to an Application, 324

Using the Web Site Administration Tool, 324

Setting Up a Login Application, 325

AJAX Control Toolkit, 328

Download and Use AJAX Controls—Step-by-Step, 328

Use a SlideShow Extender Control—Step-by-Step, 330

Partial Page Updates, 333

Other AJAX Notes, 334

ASP.NET Page Life Cycle, 334

Managing Web Projects, 335

Location of Files, 335

Opening a Saved Web Site, 335

Moving and Renaming a Web Project, 335

Copying and Publishing Web Sites, 336

Your Hands-On Programming Example, 336

8. Web Database Applications, 351

Data Access in ASP.NET, 352

Data Source Controls, 352

Displaying Data on a Form with a Data Source, 355

Creating a Parameterized Query—Step-by-Step, 359

Displaying Data from Related Tables, 362

Adding Related Tables—Step-by-Step, 363

Displaying Related Data on Multiple Pages, 364

Creating Multiple Pages—Step-by-Step, 365

Selecting Data in a GridView, 366

Data Readers versus Datasets, 368

Updating a Database, 368

Updating with a Data Source Control, 369

Exception Handling, 378

Validating Input Data, 379

Multiple Tiers, 381

Using an ObjectDataSource, 381

Creating a Service for Database Updating—Step-by-Step, 381

Maintaining the State of List Boxes, 387

Maintaining the Selection of a Drop-Down List, 387

Maintaining the List in a Dynamic List Box, 387

Unbound Controls, 388

Using Unbound Controls with a SqlDataSource, 388

Using Unbound Controls with an ObjectDataSource, 390

Adding a Table from the IDE, 391

Creating Custom Error Pages, 392

Using Validation Controls, 393

Your Hands-On Programming Example, 394

9. Reports, 403

Writing Reports, 404

Creating and Displaying a Crystal Report, 404

Creating a Grouped Report—Step-by-Step, 404

Displaying a Report from a Windows Form—Step-by-Step, 410

Using the Report Designer, 412

Modifying the Products Report—Step-by-Step, 413

Displaying a Report from a Web Form, 419

Selecting from Multiple Reports, 420

Your Hands-On Programming Example, 421

10. Collections, 431

Referencing Collection Items, 432

System.Collections Namespace, 432

Using Stacks, 434

Using Queues, 434

Using Hash Tables, 435

Sorted Lists, 436

Using the Example Program, 437

Using Array Lists, 440

Creating a Collection of Objects, 441

A Collection of Student Objects, 441

Declaring a Collection, 441

Adding Objects to a Collection, 442

Removing an Element from a Collection, 442

Retrieving an Element from a Collection, 442

Using For Each / Next, 442

The Completed Program, 443

Using an Items Collection, 446

Generic Classes, 450

Generic Collections, 452

Your Hands-On Programming Example, 456

11. User Controls, 465

Windows User Controls, 466

The Control Author versus the Developer, 466

Creating a New Control, 466

Inheriting from an Existing Control, 467

Creating an Inherited User Control—Step-by-Step, 467

Adding Properties to a Control, 471

Adding Events to a Control, 472

Putting It All Together, 474

Creating a Composite User Control, 475

Web User Controls, 480

Creating a Web User Control—Step-by-Step, 480

Your Hands-On Programming Example, 483

12. Help Files, 491

HTML Help Workshop, 492

Setting Up Help, 492

A Help Facility, 492

File Types, 494

Creating the Files, 494

Creating a Help Facility, 495

Creating a Help Facility—Step-by-Step, 495

Connecting the HTML Help File to an Application, 500

Continuing the Step-by-Step Exercise, 501

Adding Help to a Menu, 501

Modifying Help Files, 502

Connecting Context-Sensitive Help Topics to Controls, 503

Adding a Help Button to a Message Box, 503

The Help Button, 503

Other Forms of User Assistance, 504

13. Additional Topics in Visual Basic, 507

Device Applications, 508

Using Emulators, 508

Smart Device Applications, 508

A First Smart Device Application—Step-by-Step, 510

A Database Application, 514

Windows Presentation Foundation (WPF), 517

The Roles of Designer and Programmer, 517

WPF Features, 518

Creating a WPF Project, 518

A WPF Calculation Example, 520

A Multiple-Window Example, 521

Interoperability, 521

LINQ Keywords, 522

A First Look at LINQ, 523

Additional LINQ Keywords, 524

LINQ to SQL, 524

LINQ to XML, 528

World-Ready Programs, 531

Globalization, Localizability, and Localization, 531

Writing a Localized Hello World—Step-by-Step, 533

Background Workers, 534

Your Hands-On Programming Example, 537

A. Answers to Feedback Questions, 541

B. Review of Introductory VB Concepts, 553

C. Deployment, 599

D. Tips and Shortcuts for Mastering the Environment, 607

Please use the Print button in the CourseSmart Reader header.