book

Visual Basic® 2010 Programmer's Reference

Name: Visual Basic® 2010 Programmer's Reference
Author: Rod Stephens
ISBN: 9780470499832

by Rod Stephens

March 2010

Intermediate to advanced

1271 pages

31h 57m

English

Wrox

Read now

Unlock full access

Copyright
ABOUT THE AUTHOR
CREDITS
ACKNOWLEDGMENTS
INTRODUCTION
SHOULD YOU USE VISUAL BASIC 2010?WHO SHOULD READ THIS BOOKHOW THIS BOOK IS ORGANIZEDPart I: IDEPart II: Getting StartedPart III: Object-Oriented ProgrammingPart IV: GraphicsPart V: Interacting with the EnvironmentPart VI: AppendixesBONUS CHAPTERSHOW TO USE THIS BOOKNECESSARY EQUIPMENTCONVENTIONSSOURCE CODEERRATAP2P.WROX.COMIMPORTANT URLS
I. IDE
1. Introduction to the IDE
1.1. DIFFERENT IDE APPEARANCES1.2. IDE CONFIGURATIONS1.3. PROJECTS AND SOLUTIONS1.4. STARTING THE IDE1.5. CREATING A PROJECT1.6. SAVING A PROJECT1.7. SUMMARY
2. Menus, Toolbars, and Windows
2.1. MENUS2.1.1. File2.1.2. Edit2.1.3. View2.1.4. Project2.1.5. Build2.1.6. Debug2.1.7. Data2.1.8. Format2.1.9. Tools2.1.9.1. Macros2.1.9.2. Options2.1.10. Test2.1.11. Help2.2. TOOLBARS2.3. SECONDARY WINDOWS2.3.1. Toolbox2.3.2. Properties Window2.4. SUMMARY
3. Customization
3.1. ADDING COMMANDS3.2. MAKING KEYBOARD SHORTCUTS3.3. SUMMARY
4. Windows Forms Designer
4.1. SETTING DESIGNER OPTIONS4.2. ADDING CONTROLS4.3. SELECTING CONTROLS4.4. COPYING CONTROLS4.5. MOVING AND SIZING CONTROLS4.6. ARRANGING CONTROLS4.7. SETTING PROPERTIES4.7.1. Setting Group Properties4.7.2. Setting Different Properties for Several Controls4.7.3. Using Smart Tags4.8. ADDING CODE TO CONTROLS4.9. SUMMARY

5. WPF Designer
5.1. EDITOR WEAKNESSES5.2. RECOGNIZING DESIGNER WINDOWS5.3. ADDING CONTROLS5.4. SELECTING CONTROLS5.5. COPYING CONTROLS5.6. MOVING AND SIZING CONTROLS5.7. SETTING PROPERTIES5.8. SETTING GROUP PROPERTIES5.9. ADDING CODE TO CONTROLS5.10. SUMMARY
6. Visual Basic Code Editor
6.1. MARGIN ICONS6.2. OUTLINING6.3. TOOLTIPS6.4. INTELLISENSE6.5. CODE COLORING AND HIGHLIGHTING6.6. CODE SNIPPETS6.6.1. Using Snippets6.6.2. Creating Snippets6.7. ARCHITECTURAL TOOLS6.7.1. Rename6.7.2. Go To Definition6.7.3. Go To Type Definition6.7.4. Highlight References6.7.5. Find All References6.7.6. Generate From Usage6.8. THE CODE EDITOR AT RUNTIME6.9. SUMMARY
7. Debugging
7.1. THE DEBUG MENU7.2. THE DEBUG WINDOWS SUBMENU7.3. THE BREAKPOINTS WINDOW7.4. THE COMMAND AND IMMEDIATE WINDOWS7.5. SUMMARY
II. Getting Started
8. Selecting Windows Forms Controls
8.1. CONTROLS OVERVIEW8.2. CHOOSING CONTROLS8.2.1. Containing and Arranging Controls8.2.2. Making Selections8.2.3. Entering Data8.2.4. Displaying Data8.2.5. Providing Feedback8.2.6. Initiating Action8.2.7. Displaying Graphics8.2.8. Displaying Dialog Boxes8.2.9. Supporting Other Controls8.3. THIRD-PARTY CONTROLS8.4. SUMMARY
9. Using Windows Forms Controls
9.1. CONTROLS AND COMPONENTS9.2. CREATING CONTROLS9.2.1. Creating Controls at Design Time9.2.2. Adding Controls to Containers9.2.3. Creating Controls at Runtime9.3. PROPERTIES9.3.1. Properties at Design Time9.3.1.1. Compound Properties9.3.1.2. Restricted Properties9.3.1.3. Collection Properties9.3.2. Properties at Runtime9.3.3. Useful Control Properties9.3.3.1. Anchor9.3.3.2. Dock9.3.4. Position and Size Properties9.4. METHODS9.5. EVENTS9.5.1. Creating Event Handlers at Design Time9.5.2. WithEvents Event Handlers9.5.3. Setting Event Handlers at Runtime9.5.4. Control Array Events9.5.5. Validation Events9.5.5.1. Integrated Validation9.5.5.2. Separated Validation9.5.5.3. Deferred Validation9.6. SUMMARY
10. Windows Forms
10.1. TRANSPARENCY10.2. ABOUT, SPLASH, AND LOGIN FORMS10.3. MOUSE CURSORS10.4. ICONS10.4.1. Application Icons10.4.2. Notification Icons10.5. PROPERTIES ADOPTED BY CHILD CONTROLS10.6. PROPERTY RESET METHODS10.7. OVERRIDING WNDPROC10.8. SDI AND MDI10.8.1. MDI Features10.8.2. MDI Events10.8.3. MDI versus SDI10.9. MRU LISTS10.10. DIALOG BOXES10.11. WIZARDS10.12. SUMMARY
11. Selecting WPF Controls
11.1. CONTROLS OVERVIEW11.2. CONTAINING AND ARRANGING CONTROLS11.3. MAKING SELECTIONS11.4. ENTERING DATA11.5. DISPLAYING DATA11.6. PROVIDING FEEDBACK11.7. INITIATING ACTION11.8. PRESENTING GRAPHICS AND MEDIA11.9. PROVIDING NAVIGATION11.10. MANAGING DOCUMENTS11.11. DIGITAL INK11.12. SUMMARY
12. Using WPF Controls
12.1. WPF CONCEPTS12.1.1. Separation of User Interface and Code12.1.2. WPF Control Hierarchies12.2. WPF IN THE IDE12.2.1. Editing XAML12.2.2. Editing Visual Basic Code12.3. XAML FEATURES12.3.1. Objects12.3.2. Resources12.3.3. Styles12.3.4. Templates12.3.5. Transformations12.3.6. Animations12.3.7. Drawing Objects12.3.7.1. Line12.3.7.2. Ellipse12.3.7.3. Rectangle12.3.7.4. Polygon12.3.7.5. Polyline12.3.7.6. Path12.4. PROCEDURAL WPF12.5. DOCUMENTS12.5.1. Flow Documents12.5.2. Fixed Documents12.5.3. XPS Documents12.6. SUMMARY
13. WPF Windows
13.1. WINDOW APPLICATIONS13.2. PAGE APPLICATIONS13.2.1. Browser Applications13.2.2. Frame Applications13.2.3. PageFunction Applications13.2.4. Wizard Applications13.3. SUMMARY
14. Program and Module Structure
14.1. HIDDEN FILES14.2. CODE FILE STRUCTURE14.2.1. Code Regions14.2.2. Conditional Compilation14.2.2.1. Setting Constants in Code14.2.2.2. Setting Constants with the Project's Compilation Settings14.2.2.3. Predefined Constants14.2.2.4. DEBUG14.2.2.4.1. Assert14.2.2.4.2. Fail14.2.2.4.3. IndentSize, Indent, Unindent, and IndentLevel14.2.2.4.4. Write, WriteLine, WriteIf, and WriteLineIf14.2.2.5. TRACE14.2.2.6. CONFIG14.2.2.7. Debugging Level Constants14.2.3. Namespaces14.3. TYPOGRAPHIC CODE ELEMENTS14.3.1. Comments14.3.2. XML Comments14.3.3. Line Continuation14.3.4. Implicit Line Continuation14.3.5. Line Joining14.3.6. Line Labels14.4. SUMMARY
15. Data Types, Variables, and Constants
15.1. DATA TYPES15.2. TYPE CHARACTERS15.3. DATA TYPE CONVERSION15.3.1. Narrowing Conversions15.3.2. Data Type Parsing Methods15.3.3. Widening Conversions15.3.4. The Convert Class15.3.5. ToString15.4. VARIABLE DECLARATIONS15.4.1. Attribute_List15.4.2. Accessibility15.4.3. Shared15.4.4. Shadows15.4.5. ReadOnly15.4.6. Dim15.4.7. WithEvents15.4.8. Name15.4.9. Bounds_List15.4.10. New15.4.11. As Type and Inferred Types15.4.12. Initialization_Expression15.4.12.1. Initializing Arrays15.4.12.2. Initializing Object Arrays15.4.12.3. Initializing XML Variables15.5. INITIALIZING COLLECTIONS15.5.1. Multiple Variable Declarations15.6. OPTION EXPLICIT AND OPTION STRICT15.7. SCOPE15.7.1. Block Scope15.7.2. Procedure Scope15.7.3. Module Scope15.7.4. Namespace Scope15.7.5. Restricting Scope15.8. PARAMETER DECLARATIONS15.9. PROPERTY PROCEDURES15.10. ENUMERATED DATA TYPES15.11. ANONYMOUS TYPES15.12. NULLABLE TYPES15.13. CONSTANTS15.13.1. Accessibility15.13.2. As Type15.13.3. Initialization_Expression15.14. DELEGATES15.15. NAMING CONVENTIONS15.16. SUMMARY
16. Operators
16.1. ARITHMETIC OPERATORS16.2. CONCATENATION OPERATORS16.3. COMPARISON OPERATORS16.4. LOGICAL OPERATORS16.5. BITWISE OPERATORS16.6. OPERATOR PRECEDENCE16.7. ASSIGNMENT OPERATORS16.8. THE STRINGBUILDER CLASS16.9. DATE AND TIMESPAN OPERATIONS16.10. OPERATOR OVERLOADING16.11. OPERATORS WITH NULLABLE TYPES16.12. SUMMARY
17. Subroutines and Functions
17.1. SUBROUTINES17.1.1. Attribute_List17.1.2. Inheritance_Mode17.1.3. Accessibility17.1.4. Subroutine_Name17.1.5. Parameters17.1.5.1. ByVal17.1.5.2. ByRef17.1.5.3. Arrays Declared ByVal and ByRef17.1.5.4. Parenthesized Parameters17.1.5.5. Optional17.1.5.6. Optional versus Overloading17.1.5.7. Parameter Arrays17.1.6. Implements interface.subroutine17.1.7. Statements17.2. FUNCTIONS17.3. PROPERTY PROCEDURES17.4. EXTENSION METHODS17.5. LAMBDA FUNCTIONS17.6. RELAXED DELEGATES17.7. PARTIAL METHODS17.8. SUMMARY
18. Program Control Statements
18.1. DECISION STATEMENTS18.1.1. Single-Line If Then18.1.2. Multiline If Then18.1.3. Select Case18.1.3.1. To18.1.3.2. Is18.1.3.3. Comma-Separated Expressions18.1.4. Enumerated Values18.1.5. IIf18.1.6. If18.1.7. Choose18.2. LOOPING STATEMENTS18.2.1. For Next18.2.2. Non-Integer For Next Loops18.2.3. For Each18.2.4. Enumerators18.2.5. Iterators18.2.6. Do Loop Statements18.2.7. While End18.2.8. Exit and Continue18.3. GOTO18.4. SUMMARY
19. Error Handling
19.1. BUGS VERSUS UNPLANNED CONDITIONS19.1.1. Catching Bugs19.1.2. Catching Unplanned Conditions19.1.3. Global Exception Handling19.2. STRUCTURED ERROR HANDLING19.2.1. Exception Objects19.2.2. StackTrace Objects19.2.3. Throwing Exceptions19.2.4. Re-throwing Exceptions19.2.5. Custom Exceptions19.3. VISUAL BASIC CLASSIC ERROR HANDLING19.3.1. On Error GoTo Line19.3.2. On Error Resume Next19.3.3. On Error GoTo 019.3.4. On Error GoTo −119.3.5. Error-Handling Mode19.4. STRUCTURED VERSUS CLASSIC ERROR HANDLING19.5. THE ERR OBJECT19.6. DEBUGGING19.7. SUMMARY
20. Database Controls and Objects
20.1. AUTOMATICALLY CONNECTING TO DATA20.1.1. Connecting to the Data Source20.1.2. Adding Data Controls to the Form20.2. AUTOMATICALLY CREATED OBJECTS20.3. OTHER DATA OBJECTS20.4. DATA OVERVIEW20.5. CONNECTION OBJECTS20.6. TRANSACTION OBJECTS20.7. DATA ADAPTERS20.8. COMMAND OBJECTS20.8.1. DataSet20.8.2. DataTable20.8.3. DataRow20.8.4. DataColumn20.8.5. DataRelation20.8.6. Constraints20.8.6.1. ForeignKeyConstraint20.8.6.2. UniqueConstraint20.9. DATAVIEW20.10. DATAROWVIEW20.11. SIMPLE DATA BINDING20.12. CURRENCYMANAGER20.13. COMPLEX DATA BINDING20.14. SUMMARY
21. LINQ
21.1. INTRODUCTION TO LINQ21.2. BASIC LINQ QUERY SYNTAX21.2.1. From21.2.2. Where21.2.3. Order By21.2.4. Select21.2.5. Using LINQ Results21.3. ADVANCED LINQ QUERY SYNTAX21.3.1. Join21.3.2. Group By21.3.3. Aggregate Functions21.3.4. Set Operations21.3.5. Limiting Results21.4. LINQ FUNCTIONS21.5. LINQ EXTENSION METHODS21.5.1. Method-Based Queries21.5.2. Method-Based Queries with Lambda Functions21.5.3. Extending LINQ21.6. LINQ TO OBJECTS21.7. LINQ TO XML21.7.1. XML Literals21.7.2. LINQ Into XML21.7.3. LINQ Out Of XML21.8. LINQ TO ADO.NET21.8.1. LINQ to SQL and LINQ to Entities21.8.2. LINQ to DataSet21.9. PLINQ21.10. SUMMARY
22. Custom Controls
22.1. CUSTOM CONTROLS IN GENERAL22.1.1. Create the Control Project22.1.2. Make a Toolbox Icon22.1.3. Test in the UserControl Test Container22.1.4. Make a Test Project22.1.5. Test the Control in the Test Project22.1.6. Implement Properties, Methods, and Events22.2. OTHER CUSTOM CONTROL TASKS22.2.1. Add the Control to the Toolbox22.2.2. Assign Attributes22.2.3. Manage Design Time and Runtime22.3. DERIVED CONTROLS22.3.1. Shadowing Parent Features22.3.2. Hiding Parent Features22.4. COMPOSITE CONTROLS22.5. CONTROLS BUILT FROM SCRATCH22.6. COMPONENTS22.7. INVISIBLE CONTROLS22.8. PICKING A CONTROL CLASS22.9. CONTROLS AND COMPONENTS IN EXECUTABLE PROJECTS22.9.1. UserControls in Executable Projects22.9.2. Inherited UserControls in Executable Projects22.9.3. Controls in Executable Projects22.9.4. Inherited Controls in Executable Projects22.9.5. Components in Executable Projects22.10. CUSTOM COMPONENT SECURITY22.10.1. Strongly Named Assemblies22.10.2. Using a Signature Authority22.11. SUMMARY
23. Drag and Drop, and the Clipboard
23.1. DRAG-AND-DROP EVENTS23.1.1. A Simple Example23.1.2. Learning Data Types Available23.1.3. Dragging within an Application23.1.4. Accepting Dropped Files23.1.5. Dragging Serializable Objects23.1.6. Changing Format Names23.1.7. Dragging Multiple Data Formats23.2. USING THE CLIPBOARD23.3. SUMMARY
24. UAC Security
24.1. UAC OVERVIEW24.2. DESIGNING FOR UAC24.3. ELEVATING PROGRAMS24.3.1. User24.3.2. Calling Program24.3.3. Called Program24.4. SUMMARY
III. Object-Oriented Programming
25. OOP Concepts
25.1. CLASSES25.2. ENCAPSULATION25.3. INHERITANCE25.3.1. Inheritance Hierarchies25.3.2. Refinement and Abstraction25.3.3. "Has-a" and "Is-a" Relationships25.3.4. Adding and Modifying Class Features25.3.5. Interface Inheritance25.4. POLYMORPHISM25.5. METHOD OVERLOADING25.6. EXTENSION METHODS25.7. SUMMARY
26. Classes and Structures
26.1. CLASSES26.1.1. Attribute_list26.1.2. Partial26.1.3. Accessibility26.1.4. Shadows26.1.5. Inheritance26.1.5.1. Of type_list26.1.5.2. Inherits parent_class26.1.6. Implements interface26.2. STRUCTURES26.2.1. Structures Cannot Inherit26.2.2. Structures Are Value Types26.2.3. Memory Required26.2.4. Heap and Stack Performance26.2.5. Object Assignment26.2.6. Parameter Passing26.2.7. Boxing and Unboxing26.3. CLASS INSTANTIATION DETAILS26.4. STRUCTURE INSTANTIATION DETAILS26.5. GARBAGE COLLECTION26.5.1. Finalize26.5.2. Dispose26.6. CONSTANTS, PROPERTIES, AND METHODS26.7. EVENTS26.7.1. Declaring Events26.7.1.1. attribute_list26.7.1.2. accessibility26.7.1.3. Shadows26.7.1.4. parameters26.7.1.5. Implements interface.event26.7.2. Raising Events26.7.3. Catching Events26.7.4. Declaring Custom Events26.7.5. Shared Variables26.7.6. Shared Methods26.8. SUMMARY
27. Namespaces
27.1. THE IMPORTS STATEMENT27.1.1. Automatic Imports27.1.2. Namespace Aliases27.1.3. Namespace Elements27.2. THE ROOT NAMESPACE27.3. MAKING NAMESPACES27.4. CLASSES, STRUCTURES, AND MODULES27.5. RESOLVING NAMESPACES27.6. SUMMARY
28. Collection Classes
28.1. WHAT IS A COLLECTION?28.2. ARRAYS28.2.1. Array Dimensions28.2.2. Lower Bounds28.2.3. Resizing28.2.4. Speed28.2.5. Other Array Class Features28.2.5.1. Array.Reverse28.2.5.2. Array.Sort28.2.5.3. Array.BinarySearch28.3. COLLECTIONS28.3.1. ArrayList28.3.2. StringCollection28.3.3. Strongly Typed Collections28.3.4. Read-Only Strongly Typed Collections28.3.5. NameValueCollection28.4. DICTIONARIES28.4.1. ListDictionary28.4.2. Hashtable28.4.3. HybridDictionary28.4.4. Strongly Typed Dictionaries28.4.5. Other Strongly Typed Derived Classes28.4.6. StringDictionary28.4.7. SortedList28.5. COLLECTIONSUTIL28.6. STACKS AND QUEUES28.6.1. Stack28.6.2. Queue28.7. GENERICS28.8. COLLECTION INITIALIZERS28.9. SUMMARY
29. Generics
29.1. ADVANTAGES OF GENERICS29.2. DEFINING GENERICS29.2.1. Generic Constructors29.2.2. Multiple Types29.2.3. Constrained Types29.3. USING GENERICS29.3.1. Imports Aliases29.3.2. Derived Classes29.4. PREDEFINED GENERIC CLASSES29.5. GENERIC METHODS29.6. GENERICS AND EXTENSION METHODS29.7. SUMMARY
IV. Graphics
30. Drawing Basics
30.1. DRAWING OVERVIEW30.2. DRAWING NAMESPACES30.2.1. System.Drawing30.2.2. System.Drawing.Drawing2D30.2.3. System.Drawing.Imaging30.2.4. System.Drawing.Text30.2.5. System.Drawing.Printing30.3. GRAPHICS30.3.1. Drawing Methods30.3.1.1. DrawBezier30.3.1.2. DrawBeziers30.3.1.3. DrawClosedCurve30.3.1.4. DrawPath30.3.2. Flling Methods30.3.3. Other Graphics Properties and Methods30.3.4. Anti-Aliasing30.3.4.1. SmoothingMode30.3.4.2. TextRenderingHint30.3.4.3. InterpolationMode30.3.4.4. Speed Considerations30.3.5. Transformation Basics30.3.5.1. Transformation Mathematics30.3.5.2. Transformation Code30.3.6. Advanced Transformations30.3.7. Saving and Restoring Graphics State30.4. DRAWING EVENTS30.5. SUMMARY
31. Brushes, Pens, and Paths
31.1. PEN31.1.1. Alignment31.1.2. CompoundArray31.1.3. Custom Line Caps31.1.4. Pen Transformations31.2. BRUSH31.2.1. SolidBrush31.2.2. TextureBrush31.2.3. HatchBrush31.2.4. LinearGradientBrush31.2.5. PathGradientBrush31.3. GRAPHICSPATH OBJECTS31.4. GARBAGE-COLLECTION ISSUES31.5. SUMMARY
32. Text
32.1. DRAWING TEXT32.2. TEXT FORMATTING32.2.1. FormatFlags32.2.2. Tab Stops32.2.3. Trimming32.3. MEASURESTRING32.4. FONT METRICS32.5. SUMMARY
33. Image Processing
33.1. IMAGE33.2. BITMAP33.2.1. Loading Bitmaps33.2.2. Saving Bitmaps33.2.3. Implementing AutoRedraw33.2.4. Pixel-by-Pixel Operations33.2.4.1. GetPixel and SetPixel33.2.4.2. Unsafe Pixel Manipulation33.3. METAFILE OBJECTS33.4. SUMMARY
34. Printing
34.1. HOW NOT TO PRINT34.2. BASIC PRINTING34.3. PRINTING TEXT34.4. CENTERING PRINTOUTS34.5. FITTING PICTURES TO THE PAGE34.6. SIMPLIFYING DRAWING AND PRINTING34.7. SUMMARY
V. Interacting with the Environment
35. Configuration and Resources
35.1. MY35.1.1. Me and My35.1.2. My Sections35.2. ENVIRONMENT35.2.1. Setting Environment Variables35.2.2. Using Environ35.2.3. Using System.Environment35.3. REGISTRY35.3.1. Native Visual Basic Registry Methods35.3.2. My.Computer.Registry35.4. CONFIGURATION FILES35.5. RESOURCE FILES35.5.1. Application Resources35.5.2. Using Application Resources35.5.3. Embedded Resources35.5.4. Satellite Resources35.5.5. Localization Resources35.5.6. ComponentResourceManager35.6. APPLICATION35.6.1. Application Properties35.6.2. Application Methods35.6.3. Application Events35.7. SUMMARY
36. Streams
36.1. STREAM36.2. FILESTREAM36.3. MEMORYSTREAM36.4. BUFFEREDSTREAM36.5. BINARYREADER AND BINARYWRITER36.6. TEXTREADER AND TEXTWRITER36.7. STRINGREADER AND STRINGWRITER36.8. STREAMREADER AND STREAMWRITER36.9. OPENTEXT, CREATETEXT, AND APPENDTEXT36.10. CUSTOM STREAM CLASSES36.11. SUMMARY
37. File-System Objects
37.1. PERMISSIONS37.2. VISUAL BASIC METHODS37.2.1. File Methods37.2.2. File-System Methods37.2.3. Sequential-File Access37.2.4. Random-File Access37.2.5. Binary-File Access37.3. .NET FRAMEWORK CLASSES37.3.1. Directory37.3.2. File37.3.3. DriveInfo37.3.4. DirectoryInfo37.3.5. FileInfo37.3.6. FileSystemInfo37.3.7. FileSystemWatcher37.3.8. Path37.4. MY.COMPUTER.FILESYSTEM37.5. MY.COMPUTER.FILESYSTEM.SPECIALDIRECTORIES37.6. SUMMARY
38. Windows Communication Foundation
38.1. WCF CONCEPTS38.2. WCF EXAMPLE38.3. BUILDING THE INITIAL SERVICE38.4. BUILDING QUOTESERVICE38.5. TESTING QUOTESERVICE38.6. BUILDING QUOTECLIENT38.7. SUMMARY
39. Useful Namespaces
39.1. ROOT NAMESPACES39.1.1. The Microsoft Namespace39.1.2. The System Namespace39.2. ADVANCED EXAMPLES39.2.1. Regular Expressions39.3. XML39.3.1. Cryptography39.3.2. Reflection39.4. TPL39.4.1. Getting Started39.4.2. Parallel.Invoke39.4.3. Parallel.For39.4.4. Parallel.ForEach39.5. SUMMARY
VI. Appendices
A. Useful Control Properties, Methods, and Events
A.1. PROPERTIESA.2. METHODSA.3. EVENTSA.4. EVENT SEQUENCESA.4.1. Mouse EventsA.4.2. Resize EventsA.4.3. Move Events
B. Variable Declarations and Data Types
B.1. VARIABLE DECLARATIONSB.2. INITIALIZATION EXPRESSIONSB.3. WITHB.4. FROMB.5. USINGB.6. ENUMERATED TYPE DECLARATIONSB.7. XML VARIABLESB.8. OPTION EXPLICIT AND OPTION STRICTB.9. OPTION INFERB.10. DATA TYPESB.11. DATA TYPE CHARACTERSB.12. LITERAL TYPE CHARACTERSB.13. DATA TYPE CONVERSION FUNCTIONSB.14. CTYPE AND DIRECTCAST
C. Operators
C.1. ARITHMETIC OPERATORSC.2. CONCATENATION OPERATORSC.3. COMPARISON OPERATORSC.4. LOGICAL OPERATORSC.5. BITWISE OPERATORSC.6. OPERATOR PRECEDENCEC.7. ASSIGNMENT OPERATORSC.8. CHOOSE, IF, AND IIFC.9. DATE AND TIMESPAN OPERATORSC.10. OPERATOR OVERLOADING
D. Subroutine and Function Declarations
D.1. SUBROUTINESD.2. FUNCTIONSD.3. PROPERTY PROCEDURESD.4. LAMBDA FUNCTIONS AND EXPRESSIONSD.5. EXTENSION METHODSD.6. PARTIAL METHODS
E. Control Statements
E.1. DECISION STATEMENTSE.1.1. Single-Line If ThenE.1.2. Multiline If ThenE.1.3. Select CaseE.1.4. If and IIfE.1.5. ChooseE.2. LOOPING STATEMENTSE.2.1. For NextE.2.2. For EachE.2.3. Do LoopE.2.4. While EndE.3. GOTO
F. Error Handling
F.1. STRUCTURED ERROR HANDLINGF.2. THROWING EXCEPTIONSF.3. CLASSIC ERROR HANDLING
G. Windows Forms Controls and Components
G.1. COMPONENTS' PURPOSESG.2. POINTERG.3. BACKGROUNDWORKERG.4. BINDINGNAVIGATORG.5. BINDINGSOURCEG.6. BUTTONG.7. CHECKBOXG.8. CHECKEDLISTBOXG.9. COLORDIALOGG.10. COMBOBOXG.11. CONTEXTMENUSTRIPG.12. DATAGRIDVIEWG.13. DATASETG.14. DATETIMEPICKERG.15. DIRECTORYENTRYG.16. DIRECTORYSEARCHERG.17. DOMAINUPDOWNG.18. ERRORPROVIDERG.19. EVENTLOGG.20. FILESYSTEMWATCHERG.21. FLOWLAYOUTPANELG.22. FOLDERBROWSERDIALOGG.23. FONTDIALOGG.24. GROUPBOXG.25. HELPPROVIDERG.26. HSCROLLBARG.27. IMAGELISTG.28. LABELG.29. LINKLABELG.30. LISTBOXG.31. LISTVIEWG.31.1. ListView Helper CodeG.31.2. Custom ListView SortingG.32. MASKEDTEXTBOXG.33. MENUSTRIPG.34. MESSAGEQUEUEG.35. MONTHCALENDARG.36. NOTIFYICONG.37. NUMERICUPDOWNG.38. OPENFILEDIALOGG.39. PAGESETUPDIALOGG.40. PANELG.41. PERFORMANCECOUNTERG.42. PICTUREBOXG.43. PRINTDIALOGG.44. PRINTDOCUMENTG.45. PRINTPREVIEWCONTROLG.46. PRINTPREVIEWDIALOGG.47. PROCESSG.48. PROGRESSBARG.49. PROPERTYGRIDG.50. RADIOBUTTONG.51. RICHTEXTBOXG.52. SAVEFILEDIALOGG.53. SERIALPORTG.54. SERVICECONTROLLERG.55. SPLITCONTAINERG.56. SPLITTERG.57. STATUSSTRIPG.58. TABCONTROLG.59. TABLELAYOUTPANELG.60. TEXTBOXG.61. TIMERG.62. TOOLSTRIPG.63. TOOLSTRIPCONTAINERG.64. TOOLTIPG.65. TRACKBARG.66. TREEVIEWG.67. VSCROLLBARG.68. WEBBROWSER
H. WPF Controls
I. Visual Basic Power Packs
I.1. MICROSOFT POWER PACKSI.1.1. DataRepeaterI.1.2. Line and Shape ControlsI.1.3. Printer Compatibility LibraryI.1.4. PrintForm ComponentI.2. GOTDOTNET POWER PACKI.3. POWER TOYS PACK INSTALLERI.4. REFACTOR!
J. Form Objects
J.1. PROPERTIESJ.2. METHODSJ.3. EVENTSJ.4. PROPERTY-CHANGED EVENTS
K. Classes and Structures
K.1. CLASSESK.2. STRUCTURESK.3. CONSTRUCTORSK.4. EVENTS
L. LINQ
L.1. BASIC LINQ QUERY SYNTAXL.1.1. FromL.1.2. WhereL.1.3. Order ByL.1.4. SelectL.1.5. DistinctL.1.6. JoinL.1.7. Group ByL.1.8. Limiting ResultsL.2. USING QUERY RESULTSL.3. LINQ FUNCTIONSL.4. LINQ TO XMLL.4.1. LINQ Into XMLL.4.2. LINQ Out Of XMLL.5. LINQ TO DATASETL.5.1. Method-Based QueriesL.6. PLINQ
M. Generics
M.1. GENERIC CLASSESM.2. GENERIC EXTENSIONSM.3. GENERIC METHODSM.4. PROHIBITED GENERICS
N. Graphics
N.1. GRAPHICS NAMESPACESN.1.1. System.DrawingN.1.2. System.Drawing.Drawing2DN.1.3. System.Drawing.ImagingN.1.4. System.Drawing.PrintingN.1.5. System.Drawing.TextN.2. DRAWING CLASSESN.2.1. GraphicsN.2.2. PenN.2.3. BrushesN.2.4. GraphicsPathN.2.5. StringFormatN.2.6. ImageN.2.7. BitmapN.2.8. Metafile
O. Useful Exception Classes
O.1. STANDARD EXCEPTION CLASSESO.2. CUSTOM EXCEPTION CLASSES
P. Date and Time Format Specifiers
P.1. STANDARD FORMAT SPECIFIERSP.2. CUSTOM FORMAT SPECIFIERS
Q. Other Format Specifiers
Q.1. STANDARD NUMERIC FORMAT SPECIFIERSQ.2. CUSTOM NUMERIC FORMAT SPECIFIERSQ.3. NUMERIC FORMATTING SECTIONSQ.4. COMPOSITE FORMATTINGQ.5. ENUMERATED TYPE FORMATTING
R. The Application Class
R.1. PROPERTIESR.2. METHODSR.3. EVENTS
S. The My Namespace
S.1. MY.APPLICATIONS.2. MY.COMPUTERS.2.1. AudioS.2.2. ClipboardS.2.3. ClockS.2.4. FileSystemS.2.5. InfoS.2.6. KeyboardS.2.7. MouseS.2.8. NameS.2.9. NetworkS.2.10. PortsS.2.11. RegistryS.2.12. ScreenS.3. MY.FORMSS.4. MY.RESOURCESS.5. MY.USER
T. Streams
T.1. STREAM CLASS SUMMARYT.2. STREAMT.3. BINARYREADER AND BINARYWRITERT.4. TEXTREADER AND TEXTWRITERT.5. STRINGREADER AND STRINGWRITERT.6. STREAMREADER AND STREAMWRITERT.7. TEXT FILE STREAM METHODS
U. File-System Classes
U.1. VISUAL BASIC METHODSU.2. FRAMEWORK CLASSESU.2.1. FileSystemU.2.2. DirectoryU.2.3. FileU.2.4. DriveInfoU.2.5. DirectoryInfoU.2.6. FileInfoU.2.7. FileSystemWatcherU.2.8. PathU.3. MY.COMPUTER.FILESYSTEMU.4. MY.COMPUTER.FILESYSTEM.SPECIALDIRECTORIES
V. Index of Examples

Content preview from Visual Basic® 2010 Programmer's Reference

Chapter 20. Database Controls and Objects

The Windows Forms controls described in Chapter 8, "Selecting Windows Forms Controls," allow the application and the user to communicate. They let the application display data to the user, and they let the user control the application.

Visual Basic's database controls play roughly the same role between the application and a database. They move data from the database to the application, and they allow the application to send data back to the database.

Database programming is an enormous topic, and many books have been written that focus exclusively on database programming. This is such a huge field that no general Visual Basic book can adequately cover it in any real depth. However, database programming is also a very important topic, and every Visual Basic programmer should know at least something about using databases in applications.

This chapter explains how to build data sources and use drag-and-drop tasks to create simple table- and record-oriented displays. It also explains the most useful controls and objects that Visual Basic provides for working with databases. Although this chapter is far from the end of the story, it will help you get started building basic database applications.

Note

Note that the example programs described in this chapter refer to database locations as they are set up on my test computer. If you download them from the book's web site (www.vb-helper.com/vb_prog_ref.htm), you will have to modify many of them to work ...

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

Visual Basic 2012 Programmer's Reference

Publisher Resources

ISBN: 9780470499832Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Visual Basic® 2010 Programmer's Reference

by Rod Stephens

Chapter 20. Database Controls and Objects

Note

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.