Visual Basic 2008 Recipes: A Problem-Solution Approach

8.5. Execute a SQL Command or Stored Procedure

Problem

You need to execute a SQL command or stored procedure on a database.

Solution

Create a command object appropriate to the type of database you intend to use. Configure the command object by setting its CommandType and CommandText properties. Execute the command using the ExecuteNonQuery, ExecuteReader, or ExecuteScalar method, depending on the type of command and its expected results.

How It Works

All command objects inherit the MustInherit System.Data.Common.DbCommand class, which implements the System.Data.IDbCommand interface. The DbCommand class represents a database command, and each data provider includes a unique implementation. Here is the list of the implementations for the five ...