book

Mastering Microsoft® Visual Basic® 2010

Name: Mastering Microsoft® Visual Basic® 2010
Author: Evangelos Petroutsos
ISBN: 9780470532874

by Evangelos Petroutsos

April 2010

Beginner

1056 pages

31h 5m

English

Sybex

Read now

Unlock full access

Copyright
Dear Reader,
Acknowledgments
About the Author
Introduction
The Mastering SeriesWho Should Read This Book?How about the Advanced Topics?The Structure of the BookDon't Miss the TutorialsDownloading This Book's Code
1. Visual Basic: The Language
1. Getting Started with Visual Basic 2010
1.1. Exploring the Integrated Development Environment1.1.1. The Start Page1.1.2. Starting a New Project1.1.3. Using the Windows Form Designer1.2. Creating Your First VB Application1.2.1. Making the Application More User Friendly1.3. Understanding the IDE Components1.3.1. The IDE Menus1.3.1.1. File Menu1.3.1.2. Edit Menu1.3.1.2.1. Edit Advanced Submenu1.3.1.2.2. Edit IntelliSense Submenu1.3.1.2.3. Edit Outlining Submenu1.3.1.3. View Menu1.3.1.4. Project Menu1.3.1.5. Build Menu1.3.1.6. Debug Menu1.3.1.7. Data Menu1.3.1.8. Format Menu1.3.1.9. Tools Menu1.3.1.10. Window Menu1.3.1.11. Help Menu1.3.2. The Toolbox Window1.3.3. The Solution Explorer Window1.3.4. The Properties Window1.3.5. The Output Window1.3.6. The Command and Immediate Windows1.3.7. The Error List Window1.4. Setting Environment Options1.5. Building a Console Application1.6. Using Code Snippets1.7. Using the My Component1.8. The Bottom Line
2. Handling Data
2.1. Variables2.1.1. Declaring Variables2.1.1.1. Variable-Naming Conventions2.1.1.2. Variable Initialization2.1.2. Types of Variables2.1.2.1. Numeric Variables2.1.2.1.1. Integer Variables2.1.2.1.2. Single- and Double-Precision Numbers2.1.2.1.3. The Decimal Data Type2.1.2.2. Infinity and Other Oddities2.1.2.2.1. Testing for Infinity and NaN2.1.2.3. Byte Variables2.1.2.4. Boolean Variables2.1.2.5. String Variables2.1.2.6. Character Variables2.1.2.7. Date Variables2.1.3. The Strict, Explicit, and Infer Options2.1.3.1. Type Inference2.1.4. Object Variables2.2. Variables as Objects2.2.1. Converting Variable Types2.2.1.1. Widening and Narrowing Conversions2.2.2. Formatting Numbers2.2.2.1. Standard Numeric Format Strings2.2.2.2. Picture Numeric Format Strings2.2.3. User-Defined Data Types2.2.4. Examining Variable Types2.2.4.1. Is It a Number, String, or Date?2.2.5. A Variable's Scope2.2.6. A Variable's Lifetime2.3. Constants2.4. Arrays2.4.1. Declaring Arrays2.4.2. Initializing Arrays2.4.2.1. Array Limits2.4.3. Multidimensional Arrays2.4.4. Collections2.5. The Bottom Line
3. Visual Basic Programming Essentials
3.1. Flow-Control Statements3.1.1. Decision Statements3.1.1.1. If...Then Statements3.1.1.2. If...Then...Else Statements3.1.1.3. Select Case Statements3.1.1.4. Short-Circuiting Expression Evaluation3.1.2. Loop Statements3.1.2.1. For...Next Loops3.1.2.2. For Each...Next Loops3.1.2.3. Do Loops3.1.2.4. While Loops3.1.3. Nested Control Structures3.1.4. The Exit and Continue Statements3.2. Writing and Using Procedures3.2.1. Subroutines3.2.2. Functions3.3. Arguments3.3.1. Argument-Passing Mechanisms3.3.1.1. By Value versus by Reference3.3.1.2. Returning Multiple Values3.3.2. Built-in Functions3.3.3. Custom Functions3.3.4. Passing Arguments and Returning Values3.3.4.1. Passing an Unknown Number of Arguments3.3.4.2. Named Arguments3.3.4.3. Functions Returning Arrays3.3.5. Overloading Functions3.3.5.1. VB2010 at Work: The OverloadedFunctions Project3.3.5.2. Documenting Functions3.4. The Bottom Line
2. Developing Windows Applications

4. GUI Design and Event-Driven Programming
4.1. On Designing Windows Applications4.2. Building a Loan Calculator4.2.1. Understanding How the Loan Calculator Application Works4.2.2. Designing the User Interface4.2.2.1. Aligning the Controls4.2.3. Programming the Loan Application4.2.4. Validating the Data4.3. Building a Calculator4.3.1. Designing the User Interface4.3.2. Programming the MathCalculator4.3.2.1. Coding the Math Operations4.3.3. Using the Basic Debugging Tools4.3.4. Exception Handling4.4. The Bottom Line
5. Basic Windows Controls
5.1. The TextBox Control5.1.1. Basic Properties5.1.1.1. TextAlign5.1.1.2. MultiLine5.1.1.3. MaxLength5.1.1.4. ScrollBars5.1.1.5. WordWrap5.1.1.6. AcceptsReturn, AcceptsTab5.1.1.7. CharacterCasing5.1.1.8. PasswordChar5.1.1.9. ReadOnly, Locked5.1.2. Text-Manipulation Properties5.1.2.1. Text5.1.2.2. Lines5.1.3. Text-Selection Properties5.1.3.1. SelectedText5.1.3.2. SelectionStart, SelectionLength5.1.3.3. HideSelection5.1.4. Undoing Edits5.1.5. VB 2010 at Work: The TextPad Project5.1.5.1. The Editing Commands5.1.5.2. The Process and Format Menus5.1.5.3. Search and Replace Operations5.1.5.4. The Undo/Redo Commands5.1.6. Capturing Keystrokes5.1.6.1. Capturing Function Keys5.1.7. Autocomplete Properties5.2. The ListBox, CheckedListBox, and ComboBox Controls5.2.1. Basic Properties5.2.1.1. IntegralHeight5.2.1.2. Items5.2.1.3. MultiColumn5.2.1.4. SelectionMode5.2.1.5. Sorted5.2.1.6. Text5.2.2. Manipulating the Items Collection5.2.2.1. The Add Method5.2.2.2. The Insert Method5.2.2.3. The Clear Method5.2.2.4. The Count Property5.2.2.5. The CopyTo Method5.2.2.6. The Remove and RemoveAt Methods5.2.2.7. The Contains Method5.2.3. Selecting Items5.2.4. VB 2010 at Work: The ListBox Demo Project5.2.4.1. The Add Item Buttons5.2.4.2. Removing Items from the Two Lists5.2.4.3. Moving Items Between Lists5.2.5. Searching the ListBox5.2.5.1. VB 2010 at Work: The ListBoxFind Application5.2.6. The ComboBox Control5.2.6.1. Adding Items to a ComboBox at Runtime5.2.6.2. VB 2010 At Work: The FlexCombo Project5.3. The ScrollBar and TrackBar Controls5.3.1. The ScrollBar Control5.3.1.1. VB 2010 at Work: The Colors Project5.3.1.2. The ScrollBar Control's Events5.3.1.3. Handling the Events in the Colors Application5.3.2. The TrackBar Control5.3.2.1. VB 2010 at Work: The Inches Project5.4. The Bottom Line
6. Working with Forms
6.1. The Appearance of Forms6.1.1. Properties of the Form Object6.1.1.1. AcceptButton, CancelButton6.1.1.2. AutoScaleMode6.1.1.3. AutoScroll6.1.1.4. AutoScrollPosition6.1.1.5. AutoScrollMargin6.1.1.6. AutoScrollMinSize6.1.1.7. FormBorderStyle6.1.1.8. ControlBox6.1.1.9. MinimizeBox, MaximizeBox6.1.1.10. MinimumSize, MaximumSize6.1.1.11. KeyPreview6.1.1.12. SizeGripStyle6.1.1.13. StartPosition, Location6.1.1.14. TopMost6.1.1.15. Size6.1.2. Placing Controls on Forms6.1.3. Setting the TabIndex Property6.1.4. VB 2010 at Work: The Contacts Project6.1.4.1. Handling Keystrokes6.1.5. Anchoring and Docking6.1.5.1. Anchoring Controls6.1.5.2. Docking Controls6.1.6. Splitting Forms into Multiple Panes6.1.7. Form Events6.1.7.1. The Activated and Deactivate Events6.1.7.2. The FormClosing and FormClosed Events6.1.7.3. The Resize, ResizeBegin, and ResizeEnd Events6.1.7.4. The Scroll Event6.1.7.5. The Paint Event6.2. Loading and Showing Forms6.2.1. The Startup Form6.2.2. Controlling One Form from within Another6.2.2.1. Sharing Variables between Forms6.2.3. Forms versus Dialog Boxes6.2.3.1. VB 2010 at Work: The MultipleForms Project6.3. Building Dynamic Forms at Runtime6.3.1. The Form's Controls Collection6.3.1.1. VB 2010 at Work: The ShowControls Project6.3.1.2. VB 2010 at Work: The DynamicForm Project6.3.2. Creating Event Handlers at Runtime6.4. Designing Menus6.4.1. The Menu Editor6.4.2. The ToolStripMenuItem Properties6.4.2.1. Programming Menu Commands6.4.2.2. Using Access and Shortcut Keys6.4.2.2.1. Access Keys6.4.2.2.2. Shortcut Keys6.4.3. Manipulating Menus at Runtime6.4.3.1. Creating Short and Long Menus6.4.3.2. Adding and Removing Commands at Runtime6.4.3.3. Creating Context Menus6.5. The Bottom Line
7. More Windows Controls
7.1. The Common Dialog Controls7.1.1. Using the Common Dialog Controls7.1.2. The ColorDialog Control7.1.2.1. AllowFullOpen7.1.2.2. AnyColor7.1.2.3. Color7.1.2.4. CustomColors7.1.2.5. SolidColorOnly7.1.3. The FontDialog Control7.1.3.1. AllowScriptChange7.1.3.2. AllowVerticalFonts7.1.3.3. Color, ShowColor7.1.3.4. FixedPitchOnly7.1.3.5. Font7.1.3.6. FontMustExist7.1.3.7. MaxSize, MinSize7.1.3.8. ShowApply7.1.3.9. ShowEffects7.1.4. The OpenDialog and SaveDialog Controls7.1.4.1. AddExtension7.1.4.2. CheckFileExists7.1.4.3. CheckPathExists7.1.4.4. DefaultExt7.1.4.5. DereferenceLinks7.1.4.6. FileName7.1.4.7. Filter7.1.4.8. FilterIndex7.1.4.9. InitialDirectory7.1.4.10. RestoreDirectory7.1.4.11. FileNames7.1.4.12. MultiSelect7.1.4.13. ReadOnlyChecked, ShowReadOnly7.1.4.14. The OpenFile and SaveFile Methods7.1.4.15. VB 2010 at Work: Multiple File Selection7.1.5. The FolderBrowserDialog Control7.1.5.1. RootFolder7.1.5.2. SelectedPath7.1.5.3. ShowNewFolderButton7.1.5.4. VB 2010 at Work: Folder Browsing Demo Project7.2. The RichTextBox Control7.2.1. The RTF Language7.2.2. Text Manipulation and Formatting Properties7.2.2.1. SelectedText7.2.2.2. SelectionStart, SelectionLength7.2.2.3. SelectionAlignment7.2.2.4. SelectionIndent, SelectionRightIndent, SelectionHangingIndent7.2.2.5. SelectionBullet, BulletIndent7.2.2.6. SelectionTabs7.2.3. Methods7.2.3.1. SaveFile7.2.3.2. LoadFile7.2.3.3. Select, SelectAll7.2.4. Advanced Editing Features7.2.4.1. CanUndo, CanRedo7.2.4.2. UndoActionName, RedoActionName7.2.4.3. Undo, Redo7.2.5. Cutting, Copying, and Pasting7.2.6. VB 2010 at Work: The RTFPad Project7.2.6.1. The File Menu7.2.6.2. The Edit Menu7.2.6.3. The Format Menu7.2.6.4. The Search & Replace Dialog Box7.3. The TreeView and ListView Controls7.3.1. Tree and List Structures7.3.2. The TreeView Control7.3.2.1. Adding Nodes at Design Time7.3.2.2. Adding Nodes at Runtime7.3.2.2.1. Adding New Nodes7.3.3. The ListView Control7.3.3.1. The Columns Collection7.3.3.2. ListView Items and Subitems7.3.3.3. The Items Collection7.3.3.4. The SubItems Collection7.3.3.5. Processing Selected Items7.3.4. VB 2010 at Work: The CustomExplorer Project7.4. The Bottom Line
3. Working with Custom Classes and Controls
8. Working with Objects
8.1. Classes and Objects8.2. What Is a Class?8.2.1. Classes Combine Code with Data8.3. Building the Minimal Class8.3.1. Adding Code to the Minimal Class8.3.2. Using Property Procedures8.3.2.1. Throwing Exceptions8.3.2.2. Implementing Read-Only Properties8.3.2.2.1. Calculating Property Values on the Fly8.3.2.3. Auto-Implemented Properties8.3.3. Customizing Default Members8.3.3.1. Customizing the ToString Method8.3.3.2. Customizing the Equals Method8.3.3.3. Know What You Are Comparing8.3.3.4. The Is Operator8.3.4. Custom Enumerations8.3.4.1. VB 2010 at Work: The Contacts Project8.3.4.1.1. Adding, Editing, and Deleting Contacts8.3.5. Object Constructors8.3.6. Using the SimpleClass in Other Projects8.3.7. Firing Events8.3.8. Instance and Shared Methods8.4. A "Real" Class8.4.1. Nesting Classes8.5. Operator Overloading8.5.1. VB 2010 at Work: The LengthUnits Class8.5.1.1. Implementing Unary Operators8.5.1.2. Handling Variants8.6. The Bottom Line
9. Building Custom Windows Controls
9.1. On Designing Windows Controls9.2. Enhancing Existing Controls9.2.1. Building the FocusedTextBox Control9.2.1.1. Adding Functionality to Your Custom Control9.2.1.2. Testing the FocusedTextBox Control9.2.1.3. Classifying the Control's Properties9.3. Building Compound Controls9.3.1. VB 2010 at Work: The ColorEdit Control9.3.1.1. Testing the ColorEdit Control9.4. Building User-Drawn Controls9.4.1. VB 2010 at Work: The Label3D Control9.4.1.1. Label3D Control Specifications9.4.1.2. Designing the Custom Control9.4.1.3. Testing Your New Control9.4.1.4. Changed Events9.4.2. Raising Custom Events9.4.3. Using the Custom Control in Other Projects9.5. Designing Irregularly Shaped Controls9.6. Customizing List Controls9.6.1. Designing Owner-Drawn ListBox Controls9.7. The Bottom Line
10. Applied Object-Oriented Programming
10.1. Issues in Object-Oriented Programming10.1.1. Classes versus Objects10.1.2. Objects versus Object Variables10.1.2.1. Uninitialized and Nullable Variables10.1.2.2. Exploring Value Types10.1.2.3. Exploring Reference Types10.1.3. Properties versus Fields10.1.4. Shared versus Instance Members10.1.5. Type Casting10.1.6. Early versus Late Binding10.1.7. Discovering a Variable's Type10.2. Inheritance10.2.1. How to Apply Inheritance10.2.2. Designing with Inheritance10.3. Extension Methods10.4. Polymorphism10.4.1. Building the Shape Class10.4.1.1. Testing the Shape Class10.5. Who Can Inherit What?10.5.1. Parent Class Keywords10.5.2. Derived Class Keywords10.5.3. Parent Class Member Keywords10.5.4. Derived Class Member Keyword10.5.5. VB 2010 At Work: The InheritanceKeywords Project10.5.6. MyBase and MyClass10.5.7. Putting Inheritance to Work10.5.8. The Class Diagram Designer10.6. The Bottom Line
4. Working with the .NET Framework
11. The Framework at Large
11.1. What Is the Framework?11.2. Using Snippets11.3. Using the My Component11.3.1.11.3.1.1. My.Application11.3.1.2. My.Computer11.3.1.3. My.Forms11.3.1.4. My.Settings11.3.1.5. My.User11.3.1.6. My.WebServices11.3.2. How to Use the My Component11.4. The IO Namespace11.4.1. The Directory Class11.4.2. The File Class11.4.3. The DriveInfo Class11.4.4. The DirectoryInfo Class11.4.5. The Path Class11.4.6. Streaming Data11.5. Drawing and Painting11.5.1.11.5.1.1. The Graphics Object11.5.1.2. The Point Class11.5.1.3. The Rectangle Class11.5.1.4. The Size Class11.5.1.5. The Color Class11.5.1.6. The Font Class11.5.1.7. The Pen Class11.5.1.8. The Brush Class11.5.2. Drawing Methods11.5.3. Gradients11.6. The Image Class11.7. Printing11.7.1. The PrintDocument Control11.7.2. The PrintDialog Control11.7.3. The PageSetupDialog Control11.7.4. The PrintPreviewDialog Control11.7.5. Page Geometry11.7.6. Basic Printing Methods11.7.7. VB 2010 at Work: Generating a Simple Printout11.8. Handling Strings and Characters11.8.1. The Char Class11.8.1.1. Properties11.8.1.2. Methods11.8.2. The String Class11.8.2.1. Properties11.8.2.2. Methods11.8.3. The StringBuilder Class11.8.3.1. Properties11.8.3.2. Methods11.8.3.3. VB 2010 at Work: Test-Driving the StringBuilder Class11.9. Handling Dates and Time11.9.1. The DateTime Class11.9.1.1. Properties11.9.1.2. Methods11.9.1.3. Date Conversion Methods11.9.1.4. Dates as Numeric Values11.9.2. The TimeSpan Class11.9.2.1. Properties11.9.2.1.1. Field Properties11.9.2.1.2. Interval Properties11.9.2.2. Methods11.9.3. The StopWatch Class11.10. The Bottom Line
12. Storing Data in Collections
12.1. Advanced Array Topics12.1.1. Sorting Arrays12.1.2. Searching Arrays12.1.2.1. VB 2010 at Work: The ArraySearch Application12.1.2.2. The Binary Search Algorithm12.1.3. Performing Other Array Operations12.1.3.1. Array Limitations12.2. Collection Types12.2.1. Creating Collections12.2.1.1. Adding and Removing List Items12.2.1.2. Collection Initializers12.2.1.3. Extracting Items from a Collection12.2.2. Sorting Lists12.2.3. Searching Lists12.2.4. Iterating Through a List12.3. The Dictionary Collection12.4. The HashTable Collection12.4.1. VB 2010 at Work: The WordFrequencies Project12.5. The SortedList Collection12.6. Other Collections12.7. The IEnumerator and IComparer Interfaces12.7.1. Enumerating Collections12.7.2. Custom Sorting12.7.2.1. Implementing the IComparer Interface12.7.2.2. Implementing Multiple Comparers12.8. The Bottom Line
13. XML in Modern Programming
13.1. A Very Quick Introduction to XML13.1.1. XML Schema13.1.2. Numbers and Dates in XML13.2. Manipulating XML with VB13.2.1. XML as a Data Type13.2.2. Saving and Loading XML Documents13.3. Traversing XML Documents13.3.1. The Element and Elements Methods13.3.2. Ancestors and Descendants Methods13.3.3. Attribute Property13.3.4. VB Axis Properties13.3.5. Editing XML Documents13.4. VB 2010 at Work: Manipulating XML Data13.4.1. Locating Information in the Document13.4.2. Editing the Document13.4.3. Using XML Segments as Literals13.4.4. Using Lambda Expressions13.5. XML Serialization13.5.1. The Serialization Process13.5.2. Serializing Individual Objects13.5.3. Serializing Custom Objects13.5.4. Serializing Collections of Objects13.6. Other Types of Serialization13.6.1. Deserializing Individual Objects13.6.1.1. Serializing Collections13.7. The Bottom Line
14. An Introduction to LINQ
14.1. What Is LINQ?14.1.1. LINQ Components14.2. LINQ to Objects14.2.1. Anonymous Types and Extension Methods14.2.2. Querying Arbitrary Collections14.2.3. Aggregating with LINQ14.2.4. Some Practical LINQ Examples14.2.4.1. Grouping and Aggregating14.2.5. Transforming Objects with LINQ14.3. LINQ to XML14.3.1. Adding Dynamic Content to an XML Document14.3.1.1. Transforming XML Documents14.3.1.2. Working with XML Files14.4. LINQ to SQL14.4.1. Retrieving Data with the ExecuteQuery Method14.4.2. Working with LINQ to SQL Classes14.4.2.1. The DataContext Object14.4.2.2. Accessing the Tables with LINQ14.4.3. Navigation Methods14.4.4. Updates14.4.4.1. Creating a New Order14.5. The Bottom Line
5. Developing Data-Driven Applications
15. Programming with ADO.NET
15.1. What Is a Database?15.1.1. Using Relational Databases15.1.2. Obtaining the Northwind and Pubs Sample Databases15.1.3. Exploring the Northwind Database15.1.3.1. Products Table15.1.3.2. Suppliers Table15.1.3.3. Categories Table15.1.3.4. Customers Table15.1.3.5. Orders Table15.1.3.6. Order Details Table15.1.3.7. Employees Table15.1.3.8. Shippers Table15.1.4. Exploring the Pubs Database15.1.4.1. Titles Table15.1.4.2. Authors Table15.1.4.3. TitleAuthor Table15.1.4.4. Publishers Table15.1.5. Understanding Relations15.1.5.1. Referential Integrity15.1.5.2. Visual Database Tools15.2. SQL: An Overview15.2.1. Executing SQL Statements15.2.1.1. Using SQL Server Management Studio15.2.1.2. Using Visual Studio15.2.2. Selection Queries15.2.2.1. Limiting the Selection with WHERE15.2.2.2. Combining Data from Multiple Tables15.2.2.3. Aliasing Table Names15.2.2.4. Aliasing Column Names15.2.2.5. Skipping Duplicates with DISTINCT15.2.2.6. The LIKE Operator15.2.2.7. Null Values and the ISNULL Function15.2.2.8. Sorting the Rows with ORDER BY15.2.3. Working with Calculated Fields15.2.4. Calculating Aggregates15.2.5. Using SQL Joins15.2.5.1. Left Joins15.2.5.2. Right Joins15.2.5.3. Full Joins15.2.5.4. Inner Joins15.2.6. Grouping Rows15.2.6.1. Limiting Groups with HAVING15.3. Action Queries15.3.1. Deleting Rows15.3.2. Inserting New Rows15.3.3. Editing Existing Rows15.4. Stream- versus Set-Based Data Access15.5. The Basic Data-Access Classes15.5.1. The Connection Class15.5.2. The Command Class15.5.2.1. Executing Stored Procedures15.5.2.2. Executing Selection Queries15.5.2.3. Using Commands with Parameters15.5.2.4. Retrieving Multiple Values from a Stored Procedure15.5.2.5. Handling Special Characters15.5.2.6. Empty Strings versus Null Values15.5.3. The DataReader Class15.5.3.1. Reading Multiple Result Sets15.5.3.2. VB 2010 at Work: Building a Simple Data-Driven Application15.6. The Bottom Line
16. Developing Data-Driven Applications
16.1. Using Business Objects16.1.1. VB 2010 at Work: The NWOrders Application16.1.1.1. The Application's Interface16.1.1.2. Implementing the Data-Access Layer with Custom Objects16.1.1.2.1. Creating a New Order16.1.1.2.2. Saving the New Order16.1.1.3. Implementing the Data-Access Layer with LINQ to SQL16.1.1.4. Using the TransactionScope Class16.2. Storing Data in DataSets16.2.1. Filling DataSets16.2.1.1. The DataAdapter Class16.2.1.1.1. Passing Parameters Through the DataAdapter16.2.1.2. The CommandBuilder Class16.2.2. Accessing the DataSet's Tables16.2.3. Working with Rows16.2.4. Handling Null Values16.2.5. Adding and Deleting Rows16.2.6. Navigating Through a DataSet16.2.6.1. Row States and Versions16.3. Performing Update Operations16.3.1. Updating the Database with the DataAdapter16.3.2. Handling Identity Columns16.4. VB 2010 at Work: The SimpleDataSet Project16.5. The Bottom Line
17. Using the Entity Data Model
17.1. The Entity Framework: Raising the Data Abstraction Bar17.1.1. How Will You Benefit from the Entity Framework?17.1.1.1. Preserving the Expressiveness of the Data Model17.1.1.2. A Richer Set of Modeling Constructs for Representing Data17.1.1.2.1. Complex Type for Complex Properties17.1.1.2.2. Many-to-Many as a Simple Relation Between Entities17.1.1.2.3. Inheritance Applied to Data17.1.1.3. Data Store Technology and Brand Independence17.1.1.4. Isolating the Application from the Data Structural Changes17.1.2. Entity Data Model: Model-First Approach17.1.2.1. Using the EDM Designer17.1.2.2. Creating a New Entity Data Model17.1.2.3. Connecting the EDM to a Database17.1.2.4. Creating an Entity17.1.2.5. Creating a Primary Key17.1.2.6. Creating a Scalar Property17.1.2.7. Entity Data Model Under the Hood17.1.2.7.1. The Conceptual Model: The CSDL Content17.1.2.7.2. The Logical Model: The SSDL Content17.1.2.7.3. The Mapping Specification: C-S Mapping Content17.1.2.7.4. Data as Objects in the Entity Framework17.1.2.8. Adding an Inheritance Relationship Between Entities17.1.2.8.1. Entity Framework Inheritance Mapping17.1.2.9. Adding a Complex Property to an Entity17.1.2.10. Adding a One-to-Many Association17.1.2.11. Adding a Many-to-Many Association17.1.2.12. Generate the Database Structure17.2. Putting the EDM to Work17.2.1. Querying the Entity Data Model17.2.1.1. Using LINQ to Entities17.2.1.1.1. Listing All of the Entities in a Database17.2.1.1.2. Finding an Entity Using a LINQ Query17.2.1.1.3. Finding an Entity of a Specific Type in the Inheritance Hierarchy17.2.1.2. Using Entity SQL17.2.1.3. Using Query Builder Methods and the ObjectQuery Class17.2.1.4. Deferred Loading and Navigation Properties17.2.1.4.1. Using the Include Method17.2.1.4.2. Using Explicit Loading17.2.1.4.3. Using Deferred Loading17.2.1.4.4. Choosing the Right Loading Strategy17.2.2. Modifying the Data with the Entity Framework17.2.2.1. Inserting New Instances17.2.2.2. Deleting an Entity Instance17.2.2.3. Updating an Entity Instance17.2.2.4. Establishing Relationship Between Entity Instances17.2.2.5. Using Transactions in the Entity Framework17.2.2.5.1. Coordinating Transactions with External Operations17.3. Reverse-Engineering an Entity Data Model17.4. The Bottom Line
18. Building Data-Bound Applications
18.1. Working with Typed DataSets18.1.1. Generating a Typed DataSet18.1.2. Exploring the Typed DataSet18.2. Data Binding18.2.1. Using the BindingSource Class18.2.1.1. Handling Identity Columns18.2.1.2. Adjusting the DataSet18.3. Designing Data-Driven Interfaces the Easy Way18.3.1. Enhancing the Navigational Tools18.3.2. Binding Hierarchical Tables18.3.2.1. Using the BindingSource as a Data Source18.3.3. Adjusting the Appearance of the DataGridView Control18.3.3.1. Displaying Lookup Columns in a DataGridView Control18.3.4. Editing the Data in Hierarchical Tables18.3.4.1. Updating Hierarchical DataSets18.3.5. Building More-Functional Interfaces18.3.5.1. Viewing the Deleted Rows18.3.6. Data Binding with LINQ18.3.6.1. Enabling the Binding with the DataView Class18.3.6.2. Using LINQ to Filter Products Data18.4. The Bottom Line
6. Developing for the Web
19. Accessing the Web
19.1. The WebBrowser Control19.1.1. WebBrowser Control under the Hood19.1.2. WebBrowser Control Properties19.1.2.1. Dock19.1.2.2. URL19.1.2.3. AllowNavigation19.1.2.4. ScrollBarsEnabled19.1.2.5. AllowBrowserDrop19.1.2.6. WebBrowserShortcutsEnabled19.1.2.7. IsWebBrowserContextMenuEnabled19.1.2.8. ScriptErrorsSuppressed19.1.2.9. DocumentText19.1.2.10. DocumentStream19.1.2.11. Document19.1.3. WebBrowser Control Methods19.1.3.1. Navigate19.1.3.2. Go Methods19.1.3.3. Stop19.1.3.4. Refresh19.1.3.5. Show Methods19.1.3.6. Print19.1.4. WebBrowser Control Events19.1.4.1. Navigating19.1.4.2. DocumentCompleted19.1.5. VB 2010 at Work: The Stock Quotes Project19.1.5.1. Obtaining the HTML Widget19.1.5.2. Creating the Stock Quotes Project19.1.5.3. Displaying the Stock Quotes Badge inside the WebBrowser Control19.2. Accessing the Web with the WebClient and HttpWebRequest/Response Classes19.2.1. The WebClient Class19.2.2. WebClient Class Properties19.2.2.1. QueryString19.2.2.2. Headers19.2.2.3. ResponseHeaders19.2.3. WebClient Class Methods19.2.3.1. Download Methods19.2.3.2. Download*Async Methods19.2.3.3. OpenRead and OpenReadAsync Methods19.2.3.4. Upload and Upload*Async Methods19.2.3.5. CancelAsync Method19.2.4. WebClient Class Event19.2.4.1. Download*Completed and Upload*Completed events19.2.5. WebClient Asynchronous Download Example19.2.6. HttpWebRequest and HttpWebResponse Classes19.2.6.1. Managing Cookies with HttpWebRequest and HttpWebResponse19.3. Putting It All Together: The Address Visualization Form19.3.1. Composing Web Services19.3.1.1. Yahoo! Geocoding API19.3.1.2. Google Maps Service19.3.2. Coding Address Visualization Form19.3.2.1. Assembling the Address Visualization Form19.3.2.2. Constructing the Geocoding Service URL and Query Parameters19.3.2.3. Invoking the Yahoo! Geocoding Web Service19.3.2.4. Processing the Yahoo! Geocoding Service Response19.3.2.5. Displaying Coordinates on the Map19.4. The Bottom Line
20. Building Web Applications
20.1. Developing for the Web20.2. Understanding HTML and XHTML20.3. Working with HTML20.3.1. Page Construction20.3.2. Text Management20.3.3. Horizontal Rules20.3.4. Images20.3.5. Links20.3.6. Embedding Media20.3.7. Comments20.3.8. Scripts20.3.9. Lists20.3.10. Tables20.3.11. Page Formatting20.3.12. Forms and Form Elements20.4. Cascading Style Sheets (CSS)20.4.1. Formatting Styles with CSS20.4.2. Page Formatting with CSS20.5. JavaScript20.5.1. AJAX20.6. Microformats20.7. Server-Side Technologies20.8. Creating a Web Application20.9. Controls20.9.1. Standard Controls20.9.2. Data Controls20.9.3. Validation Controls20.9.4. Navigation Controls20.9.5. Login Controls20.9.6. WebParts Controls20.9.7. AJAX Extensions Controls20.9.8. Reporting Controls20.9.9. HTML Controls20.10. Maintaining State20.11. Master Pages20.12. ASP.NET Objects20.13. Postback20.14. VB 2010 at Work: Online Ordering Application20.14.1. Creating the Project20.14.2. Creating the Products Web Form20.14.3. Creating the Quantity Web Form20.14.3.1. Creating the Cart Web Form20.15. The Bottom Line
21. Building and Using Web Services
21.1. Using ASP.NET and WCF Web Services21.1.1. What Is a Service?21.1.2. Consuming Web Services21.1.3. ASP.NET Web Services21.1.4. WCF21.2. Understanding Technologies Associated with Web Services21.2.1. SOAP21.2.2. WSDL21.2.3. SOAP Discovery21.2.4. UDDI21.3. Creating a Simple ASP.NET Web Service21.3.1. Setting Up the Web Service21.3.2. Testing the Web Service21.3.3. Consuming the Web Service21.4. Developing a Stand-Alone Web Service21.4.1. Building MyWebService21.4.2. Deploying MyWebService21.4.3. Consuming MyWebService21.4.3.1. Adding a Web Reference21.4.3.2. Adding the Code-Behind21.5. Simple AJAX Implementation21.6. Building and Using WCF Services21.6.1. Building a WCF Service21.6.1.1. Configuring WCF Services21.7. ADO.NET Data Services21.7.1.21.7.1.1. Filtering21.7.1.2. The Basic Query Operators21.7.2. Building a Windows Client21.7.3. Submitting Updates21.7.4. Performing Transactions21.7.5. Securing Your Data Service21.8. The Bottom Line
A. The Bottom Line
A.1. Chapter 1: Getting Started with Visual Basic 2010A.2. Chapter 2: Handling DataA.3. Chapter 3: Visual Basic Programming EssentialsA.4. Chapter 4: GUI Design and Event-Driven ProgrammingA.5. Chapter 5: Basic Windows ControlsA.6. Chapter 6: Working with FormsA.7. Chapter 7: More Windows ControlsA.8. Chapter 8: Working with ProjectsA.9. Chapter 9: Building Custom Windows ControlsA.10. Chapter 10: Applied Object-Oriented ProgrammingA.11. Chapter 11: The Framework at LargeA.12. Chapter 12: Storing Data in CollectionsA.13. Chapter 13: XML in Modern ProgrammingA.14. Chapter 14: An Introduction to LINQA.15. Chapter 15: Programming with ADO.NETA.16. Chapter 16: Developing Data-Driven ApplicationsA.17. Chapter 17: Using the Entity Data ModelA.18. Chapter 18: Building Data-Bound ApplicationsA.19. Chapter 19: Accessing the WebA.20. Chapter 20: Building Web ApplicationsA.21. Chapter 21: Building and Using Web Services

Overview

The new edition of the ultimate comprehensive guide to Microsoft Visual Basic

Where most VB books start with beginner level topics, Mastering Visual Basic 2010 vaults you right into intermediate and advanced coverage. From the core of the language and user interface design to developing data-driven applications, this detailed book brings you thoroughly up to speed and features numerous example programs you can use to start building your own apps right away.

Covers Visual Basic 2010, part of Microsoft's Visual Studio integrated development environment (IDE), which includes C#, C++, Visual Web Developer, and ASP.NET, along with Visual Basic
Explains topics in the thorough, step-by-step style of all books in the Mastering series, providing you ample instruction, tips, and techniques
Helps you build your own applications by supplying sample code you can use to start development
Includes review exercises in each chapter to reinforce concepts as you learn

All the books in the Sybex Mastering series feature comprehensive and expert coverage of topics you can put to immediate use.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9780470532874Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills