SqlCeCommand Constructor (String)

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

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

Syntax

'Declaration
Public Sub New ( _
    commandText As String _
)
'Usage
Dim commandText As String

Dim instance As New SqlCeCommand(commandText)

public SqlCeCommand(
    string commandText
)

public:
SqlCeCommand(
    String^ commandText
)

new : 
        commandText:string -> SqlCeCommand

public function SqlCeCommand(
    commandText : String
)

Parameters

• commandText
  Type: System. . :: . .String
  The text of the query.

Remarks

The following table shows initial property values for an instance of SqlCeCommand.

Examples

The following example creates a SqlCeCommand and sets some of its properties.

Dim queryText As String = "SELECT * FROM Categories ORDER BY [Category ID]"
Dim cmd As New SqlCeCommand(queryText)

cmd.Connection = conn
cmd.CommandType = CommandType.Text

string queryText = "SELECT * FROM Categories ORDER BY [Category ID]";
SqlCeCommand cmd = new SqlCeCommand(queryText);

cmd.Connection = conn;
cmd.CommandType = CommandType.Text;

See Also

Reference

SqlCeCommand Class

SqlCeCommand Members

SqlCeCommand Overload

System.Data.SqlServerCe Namespace