SqlCommand Constructor (String)

 

Initializes a new instance of the SqlCommand class with the text of the query.

Namespace:   System.Data.SqlClient
Assembly:  System.Data (in System.Data.dll)

public SqlCommand(
	string cmdText
)

Parameters

cmdText
Type: System.String

The text of the query.

When an instance of SqlCommand is created, the following read/write properties are set to initial values.

Properties

Initial value

CommandText

cmdText

CommandTimeout

30

CommandType

CommandType.Text

Connection

null

You can change the value for any of these properties through a separate call to the property.

The following example creates a SqlCommand, passing in the connection string and command text.

public void CreateCommand() 
 {
    string queryString = "SELECT * FROM Categories ORDER BY CategoryID";
    SqlCommand command = new SqlCommand(queryString);
    command.CommandTimeout = 15;
    command.CommandType = CommandType.Text;
 }

.NET Framework
Available since 1.1
Return to top
Show: