book

Beginning Visual Basic 2012

by Bryan Newsome

September 2012

Beginner

744 pages

19h 30m

English

Wrox

Read now

Unlock full access

Event-Driven ProgrammingInstalling Visual Basic 2012The Visual Studio 2012 IDECreating a Simple ApplicationUsing the Help SystemSummary
Microsoft's Reliance on WindowsWriting Software for WindowsCommon Language RuntimeThe Common Type System and Common Language SpecificationSummary
Information and DataWorking with VariablesComments and WhitespaceData TypesStoring VariablesMethodsSummary
Making DecisionsThe If StatementSelect CaseLoopsSummary
Understanding ArraysUnderstanding EnumerationsUnderstanding ConstantsStructuresWorking with ArrayListsWorking with CollectionsBuilding Lookup Tables with HashtableAdvanced Array ManipulationSummary
What Is XAML?XAML SyntaxWindows Presentation FoundationSummary
Responding to EventsBuilding a Simple ApplicationCounting CharactersCounting WordsCreating More Complex ApplicationsCreating the ToolbarCreating the Status BarCreating an Edit BoxClearing the Edit BoxResponding to Toolbar ButtonsUsing Multiple FormsAbout DialogSummary
The MessageBoxThe OpenFileDialog ControlThe SaveDialog ControlThe FontDialog ControlThe ColorDialog ControlThe PrintDialog ControlThe FolderBrowserDialog ControlSummary
Understanding Menu FeaturesCreating MenusContext MenusSummary

Major Error TypesDebuggingError HandlingSummary
Understanding ObjectsBuilding ClassesReusabilityDesigning an ObjectConstructorsInheritanceObjects and StructuresThe Framework ClassesSummary
Building a Favorites ViewerAn Alternative Favorite ViewerUsing Shared Properties and MethodsUnderstanding Object-Oriented Programming and Memory ManagementSummary
Understanding Class LibrariesUsing Strong NamesRegistering AssembliesDesigning Class LibrariesUsing Third-Party Class LibrariesViewing Classes with the Object BrowserSummary
Windows Forms ControlsCreating and Testing a User ControlExposing Properties from User ControlsDesign Time or RuntimeCreating a Command Link ControlSummary
What You Need to Complete This Chapter's ExercisesWhat Is a Database?Understanding Basic SQL SyntaxExecuting Queries in SQL ServerSummary
ADO.NETADO.NET Data NamespacesThe ADO.NET Classes in ActionData BindingSummary
Creating a Dynamic Data Entities WebsiteCustomizing the Design of a Dynamic Data WebsiteSummary
Thin-Client ArchitectureWeb Forms versus Windows FormsWeb Applications: The Basic PiecesActive Server PagesBuilding WebsitesSummary
What Is Deployment?Creating a Visual Studio 2012 Setup ApplicationCustomize the User InterfaceDeploying Different SolutionsSummary
Windows 8 Application Design PrinciplesApplication LayoutSummary
Chapter 1Chapter 2Chapter 3Chapter 4Chapter 5Chapter 6Chapter 7Chapter 8Chapter 9Chapter 10Chapter 11Chapter 12Chapter 13Chapter 14Chapter 15Chapter 16Chapter 17Chapter 18Chapter 19Chapter 20
Online ResourcesOffline Resources (Books)

Content preview from Beginning Visual Basic 2012

Chapter 15

Accessing Data Using Structured Query Language

What You Will Learn in this Chapter

What you need to know to complete this chapter's exercises
Learning what a database really is
Using the SQL SELECT statement
Examining the SQL JOIN statement
Using the SQL UPDATE statement
Examining the SQL DELETE statement
Using the SQL INSERT statement
Examining the SQL comment
How to execute Queries in SQL Server

Wrox.com Code Downloads for this Chapter

The wrox.com code downloads for this chapter are found at www.wrox.com/remtitle.cgi?isbn=1118311813 on the Download Code tab. The code is in the 311813 C15.zip download and individually named according to the names given throughout the chapter.

Most applications manipulate data in some way. Visual Basic 2012 applications often manipulate data that comes from relational databases. To do this, your application needs to interface with relational database software such as Microsoft Access, Microsoft SQL Server, Oracle, or Sybase.

Visual Studio 2012 provides the data access tools and wizards to connect to these databases and retrieve and update their data. In this chapter, you will look at some of these tools and wizards and use them to retrieve data from a database.

The next chapter concentrates on writing code directly, which gives you more flexibility and control than relying on Visual Studio 2012 to create it for you. With practice, writing code will also take less time than working through a wizard.