CommandText Property

Gets or sets the SQL statement to execute against a database.

[Visual Basic]
Overrides Public Property CommandText As String

[C#]
public override string CommandText {get; set;}

The SQL statement or stored procedure to execute. The default value is an empty string ("").

Sense of CommandText property depends on value of CommandType property.

When CommandType value is Text, property CommandText should contain text of a query that must be run on the server.

When the value is StoredProcedure, property CommandText must be a name of a procedure to execute.

When the value is set to TableDirect, CommandText must be name of a table you want to get all data from. All rows and columns are retrieved.