Public Overrides Property CommandText As String

public override string CommandText {get;set;}

For parameterized statements, use a question mark (?) placeholder to pass parameters.

A string specifying the text of the SQL statement or the name of the table. The default is an empty string (invalid command).

SELECT statements are marked as read-only by default for performance reasons. If the query is going to be used to make updates, the statement must end with " FOR UPDATE".

• ExecuteNonQuery method
• ExecuteReader method
• ExecuteResultSet method
• ExecuteScalar method
• ExecuteTable method
• CommandType property
•  System.Data.CommandType

The following example demonstrates the use of the parameterized placeholder:

' Visual Basic
myCmd.CommandText = "SELECT * FROM Customers WHERE CustomerID = ?"

The following code is the C# language equivalent:

// C#
myCmd.CommandText = "SELECT * FROM Customers WHERE CustomerID = ?";