SqlCeCommand.SqlCeCommand(String, SqlCeConnection) Constructor

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

Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)

Syntax

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

Dim instance As New SqlCeCommand(commandText, connection)

public SqlCeCommand (
    string commandText,
    SqlCeConnection connection
)

public:
SqlCeCommand (
    String^ commandText, 
    SqlCeConnection^ connection
)

public SqlCeCommand (
    String commandText, 
    SqlCeConnection connection
)

public function SqlCeCommand (
    commandText : String, 
    connection : SqlCeConnection
)

Not applicable.

Parameters

• commandText
  The text of the query.

• connection
  A SqlCeConnection that represents the connection to a data source.

Remarks

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

Properties	Initial Value
CommandText	cmdText
CommandType	Text
Connection	A new SqlCeConnection that is the value for the connection parameter.

You can change the value for any of these parameters by setting the related property.

Example

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

conn.Open()
Dim cmd As New SqlCeCommand("INSERT INTO foo (col1) VALUES (1)", conn)
cmd.ExecuteNonQuery()
conn.Close()

conn.Open();
SqlCeCommand cmd = new SqlCeCommand("INSERT INTO foo (col1) VALUES (1)", conn);
cmd.ExecuteNonQuery();
conn.Close();

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