Tabs for Contents, notes, highlights

Contents
Notes
Highlights

Detailed Table of Contents

Hide Contents, Notes, and Highlights

Search TermsShow Hide

« Back to eTextbook

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
Assemblies, 5
The References Collection, 5
ASP.NET, 6
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
Namespaces, 74
Scope, 74
Lifetime, 76
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
ADO.NET, 106
Accessing Data in the .NET Framework, 107
XML Data, 109
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
XML, 251
SOAP, 252
WSDL, 252
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
Debugging, 286
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
Cookies, 318
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, 327
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
Caching, 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
Generics, 449
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, 522
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
Threading, 534
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
Glossary, 625
INDEX, 634

Search Results

« Back to eTextbook


PAGE	Description

4	...