Visual Basic® .NET by Example

Chapter 31. SQL Commands

This chapter focuses on SQL commands used to communicate directly with a database. In the previous two chapters, we presented an overview of ADO.NET, Data Providers, and the DataSet. In presenting these topics, SQL commands were briefly discussed and intentionally not explained in detail. Now that you have a good understanding of ADO.NET, this chapter explains SQL commands so that it is clear how direct access to a database works in .NET.

There are two goals to this chapter. The first goal is to briefly explain the syntax of the four most common commands in the SQL language. These commands are SELECT, INSERT, UPDATE, and DELETE The second goal is to show how you would invoke these databases commands using the .NET Framework ...