SqlCeCommand.SqlCeCommand(String) Constructor

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
)

public SqlCeCommand (
    String commandText
)

public function SqlCeCommand (
    commandText : String
)

Not applicable.

Parameters

• commandText
  The text of the query.

Remarks

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

Properties	Initial Value
CommandText	cmdText
CommandType	Text
Connection	a null reference (Nothing in Visual Basic)

Example

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;

Platforms

Windows CE, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows XP Professional x64 Edition, Windows XP SP2

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

Version Information

.NET Framework

Supported in: 3.0

.NET Compact Framework

Supported in: 2.0, 1.0

See Also

Reference

SqlCeCommand Class
SqlCeCommand Members
System.Data.SqlServerCe Namespace