Beginning Visual Basic 2015

INTRODUCTION xxvii CHAPTER 1: WELCOME TO VISUAL BASIC 2015 1 Implementing Event-Driven Programming 2 Installing Visual Basic 2015 3 The Visual Studio 2015 IDE 5 The Profi le Setup Page 5 The Menu 6 The Toolbars 8 Creating a Simple Application 9 Windows in the Visual Studio 2015 IDE 10 Modifi ed Hungarian Notation 17 The Code Editor 18 Using the Help System 22 Summary 23 CHAPTER 2: THE MICROSOFT .NET FRAMEWORK 25 The .NET Vision 25 This Sounds Like Java 26 Where Now? 27 Writing Software for Windows 27 The .NET Framework Classes 28 Executing Code 30 Common Language Runtime 31 Code Loading and Execution 31 Application Isolation 31 Security 32 Interoperability 33 Exception Handling 33 The Common Type System and Common Language Specification 33 Summary 34 CHAPTER 3: WRITING SOFTWARE 37 Information and Data 37 Algorithms 38 What Is a Programming Language? 39 Working with Variables 40 Comments and Whitespace 43 Comments 43 Whitespace 45 Data Types 45 Working with Numbers 45 Common Integer Math Operations 46 Integer Math Shorthand 49 The Problem with Integer Math 50 Floating-Point Math 50 Working with Strings 53 Using Dates 62 Boolean 69 Storing Variables 69 Binary 69 Bits and Bytes 70 Representing Values 70 Converting Values 72 Methods 74 Why Use Methods? 74 Methods You’ve Already Seen 75 Building a Method 78 Choosing Method Names 81 Scope 82 Summary 84 CHAPTER 4: CONTROLLING THE FLOW 87 Making Decisions 87 The If Statement 88 The Else Statement 90 Allowing Multiple Alternatives with ElseIf 90 Nested If Statements 92 Single-Line If Statement 92 Comparison Operators 92 String Comparison 101 Select Case 102 Case-Insensitive Select Case 106 Multiple Selections 108 The Case Else Statement 109 Different Data Types with Select Case 110 Loops 110 The For...Next Loop 110 The Do...Loop Loops 116 Nested Loops 120 Quitting Early 121 Quitting Do...Loops 123 Infinite Loops 124 Summary 125 CHAPTER 5: WORKING WITH DATA STRUCTURES 127 Understanding Arrays 128 Defining and Using Arrays 128 Using For Each...Next 131 Passing Arrays as Parameters 133 Sorting Arrays 136 Going Backward 137 Initializing Arrays with Values 138 Understanding Enumerations 139 Using Enumerations 140 Determining the State 143 Setting Invalid Values 146 Understanding Constants 146 Using Constants 146 Different Constant Types 148 Structures 148 Building Structures 149 Adding Properties to Structures 152 Working with ArrayLists 153 Using an ArrayList 153 Deleting from an ArrayList 158 Showing Items in the ArrayList 161 Working with Collections 162 Creating CustomerCollection 163 Adding an Item Property 164 Building Lookup Tables with Hashtable 166 Using Hashtables 166 Cleaning Up: Remove, RemoveAt, and Clear 169 Case Sensitivity 172 Advanced Array Manipulation 173 Dynamic Arrays 173 Using Preserve 175 Summary 176 CHAPTER 6: BUILDING WINDOWS APPLICATIONS 179 Responding to Events 180 Counting Characters 184 Counting Words 188 Creating More Complex Applications 191 Creating the Toolbar 192 Creating the Status Bar 195 Creating an Edit Box 196 Clearing the Edit Box 197 Responding to Toolbar Buttons 199 Using Multiple Forms 202 About Dialog 202 Summary 206 CHAPTER 7: DISPLAYING DIALOGS 209 The MessageBox 210 Available Icons for MessageBox 210 Available Buttons for MessageBox 211 Setting the Default Button 211 Miscellaneous Options 212 The Show Method Syntax 212 Example Message Boxes 214 The OpenFileDialog Control 218 The OpenFileDialog Control 218 The Properties of OpenFileDialog 218 OpenFileDialog Methods 220 Using the OpenFileDialog Control 221 The SaveDialog Control 226 The Properties of SaveFileDialog 226 SaveFileDialog Methods 227 Using the SaveFileDialog Control 227 The FontDialog Control 231 The Properties of FontDialog 231 The Methods of FontDialog 232 Using the FontDialog Control 232 The ColorDialog Control 235 The Properties of ColorDialog 236 Using the ColorDialog Control 237 The PrintDialog Control 238 The Properties of PrintDialog 239 Using the PrintDialog Control 240 The PrintDocument Class 240 The Properties of the PrintDocument Class 240 Printing a Document 241 The FolderBrowserDialog Control 248 The Properties of FolderBrowserDialog 248 Using the FolderBrowserDialog Control 249 Summary 252 CHAPTER 8: CREATING MENUS 255 Understanding Menu Features 255 Images 256 Access Keys 256 Shortcut Keys 256 Check Marks 256 The Properties Window 257 Creating Menus 259 Designing the Menus 259 Adding Toolbars and Controls 261 Coding Menus 263 Coding the View Menu and Toolbars 267 Testing Your Code 269 Context Menus 272 Creating Context Menus 272 Enabling and Disabling Menu Items and Toolbar Buttons 275 Summary 279 CHAPTER 9: DEBUGGING AND ERROR HANDLING 283 Major Error Types 284 Syntax Errors 284 Execution Errors 288 Logic Errors 288 Debugging 289 Creating a Sample Project 289 Setting Breakpoints 306 Debugging Using the Watch Window and QuickWatch Dialog Box 313 Debugging with the Autos Window 316 Debugging with the Locals Window 316 Error Handling 318 Using Structured Error Handling 319 Summary 321 CHAPTER 10: BUILDING OBJECTS 325 Understanding Objects 326 Encapsulation 327 Methods and Properties 327 Events 328 Visibility 328 What Is a Class? 329 Building Classes 330 Reusability 330 Designing an Object 332 State 332 Behavior 333 Storing State 333 Real Properties 336 Read/Write Properties 339 Auto-Implemented Properties 342 The IsMoving Method 343 Constructors 345 Inheritance 346 Adding New Methods and Properties 348 Adding a GetPowerToWeightRatio Method 350 Changing Defaults 352 Polymorphism: Scary Word, Simple Concept 354 Overriding More Methods 354 Inheriting from the Object Class 356 Objects and Structures 357 The Framework Classes 357 Namespaces 358 The Imports Statement 360 Creating Your Own Namespace 361 Inheritance in the .NET Framework 364 Summary 365 CHAPTER 11: ADVANCED OBJECT-ORIENTED TECHNIQUES 367 Building a Favorites Viewer 368 Internet Shortcuts and Favorites 368 Using Classes 371 Scanning Favorites 377 Viewing Favorites 384 An Alternative Favorite Viewer 386 Building a Favorites Tray 387 Displaying Favorites 388 Using Shared Properties and Methods 392 Using Shared Properties 392 Using Shared Methods 397 Understanding Object-Oriented Programming and Memory Management 398 Garbage Collection 400 Releasing Resources 400 Defragmentation and Compaction 401 Summary 402 CHAPTER 12: ACCESSING DATA USING STRUCTURED QUERY LANGUAGE 405 What You Need to Complete This Chapter’s Exercises 406 What Is a Database? 407 Database Tables 407 Primary and Foreign Keys 413 Queries 415 Understanding Basic SQL Syntax 415 Using SELECT Statement 416 Using the JOIN Statement 417 Using the UPDATE Statement 419 Using the DELETE Statement 419 Using the INSERT Statement 420 Using the SQL Comment 421 Executing Queries in SQL Server 421 Summary 425 CHAPTER 13: DATABASE PROGRAMMING WITH SQL SERVER AND ADO.NET 427 ADO.NET 428 ADO.NET Data Namespaces 428 The SqlConnection Class 429 Working with the Connection String Parameters 430 Opening and Closing the Connection 431 The SqlCommand Class 431 The SqlDataAdapter Class 434 The DataSet Class 438 DataView 438 The ADO.NET Classes in Action 440 Data Binding 450 BindingContext and CurrencyManager 450 Binding Controls 451 Binding Examples 452 Summary 480 CHAPTER 14: ASP.NET 483 Thin]Client Architecture 484 Web Forms versus Windows Forms 485 Windows Forms Advantages 485 Web Forms Advantages 485 Web Applications: The Basic Pieces 486 Web Servers 486 Browsers 486 HyperText Markup Language 487 JavaScript 487 Cascading Style Sheets 487 Active Server Pages 488 Benefits of ASP.NET Web Pages 488 Special Website Files 488 Development 489 Controls: The Toolbox 489 Building Websites 490 Creating a Web Form for Client] and Server]Side Processing 490 Website Locations with VS 2015 495 Performing Data Entry and Validation 498 Using the GridView to Build a Data]Driven Web Form 507 Summary 512 CHAPTER 15: DEPLOYING YOUR APPLICATION 515 What Is Deployment? 516 ClickOnce Deployment 516 XCOPY Deployment 521 Visual Studio 2015 Setup Application Options 522 Deploying Different Solutions 522 Private Assemblies 523 Shared Assemblies 523 Deploying Desktop Applications 524 Deploying Web Applications 524 Deploying XML Web Services 524 Useful Tools 525 Summary 525 CHAPTER 16: WINDOWS 8 APPS 529 Windows 8 Application Design Principles 530 Using Touch 530 Application Commands 531 Windows 8 Controls 532 Coding Windows 8 Apps with XAML 533 Creating Your First Windows 8 App 534 Application Layout 548 Application Views 548 Screen Sizes and Orientation 548 Summary 553 APPENDIX: EXERCISE SOLUTIONS 557 INDEX 569