Creating a SqlCommand Object

Use one of the SqlCommand constructors. Call the CreateCommand() method of a SqlConnection object | Creating a SqlCommand Object There are two ways you can create a SqlCommand object Use one of the SqlCommand constructors. Call the CreateCommand method of a SqlConnection object. You ll see how to use both these ways to create SqlCommand objects next. Note You can use the same ways shown in the following sections to create an OleDbCommand or OdbcCommand object. Creating a SqlCommand Object Using a Constructor The SqlCommand constructors are as follows SqlCommand SqlCommand string commandText SqlCommand string commandText SqlConnection mySqlConnection SqlCommand string commandText SqlConnection mySqlConnection SqlTransaction mySqlTransaction where commandText contains your SQL statement stored procedure call or table to retrieve from. mySqlConnection is your SqlConnection object. mySqlTransaction is your SqlTransaction object. Before you use a SqlCommand object you first need a SqlConnection object which is used to communicate with a SQL Server database server localhost database Northwind uid sa pwd sa Next you can create a new SqlCommand object using the following statement SqlCommand mySqlCommand new SqlCommand You then set the Connection property of mySqlCommand to mySqlConnection mySqlConnection The mySqlCommand object will then use mySqlConnection to communicate with the database. Now the CommandType property of a Connection object determines the type of command to be executed. You can use any of the values in the enumeration to specify the CommandType property. Table shows the CommandType enumeration values. Table CommandType ENUMERATION VALUES VALUE DESCRIPTION Text Indicates the command is a SQL statement. Text is the default. StoredProcedure Indicates the command is a stored procedure call. TableDirect Indicates the name of a table for which all rows and columns are to be retrieved. Note SqlCommand objects don t support TableDirect. You have to use an object of one of