SqlCeDataAdapter Constructor (String, SqlCeConnection)
Initializes a new instance of the SqlCeDataAdapter class with a SelectCommand and a SqlCeConnection object.
Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)
Syntax
'Declaration
Public Sub New ( _
selectCommandText As String, _
selectConnection As SqlCeConnection _
)
'Usage
Dim selectCommandText As String
Dim selectConnection As SqlCeConnection
Dim instance As New SqlCeDataAdapter(selectCommandText, selectConnection)
public SqlCeDataAdapter (
string selectCommandText,
SqlCeConnection selectConnection
)
public:
SqlCeDataAdapter (
String^ selectCommandText,
SqlCeConnection^ selectConnection
)
public SqlCeDataAdapter (
String selectCommandText,
SqlCeConnection selectConnection
)
public function SqlCeDataAdapter (
selectCommandText : String,
selectConnection : SqlCeConnection
)
Parameters
- selectCommandText
A String that is an SQL SELECT statement to be used as the CommandText of the SelectCommand property of the SqlCeDataAdapter.
- selectConnection
A SqlCeConnection that represents the connection.
Remarks
This implementation of the SqlCeDataAdapter opens and closes a SqlCeConnection if it is not already open. This can be useful in an application that must call the Fill method for two or more SqlCeDataAdapter objects. If the SqlCeConnection is already open, you must explicitly call Close or Dispose to close it.
When you create an instance of SqlCeDataAdapter, the following read/write properties are set to the following initial values.
Properties |
Initial Value |
---|---|
MissingMappingAction.Passthrough |
|
MissingSchemaAction.Add |
You can change the value of any of these properties by making a separate call to that property.
Example
The following example creates a SqlCeDataAdapter by passing the command string and a SqlCeConnection object.
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see .
Platforms
Windows CE, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows XP Professional x64 Edition, Windows XP SP2
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.
Version Information
.NET Compact Framework
Supported in: 2.0, 1.0
See Also
Reference
SqlCeDataAdapter Class
SqlCeDataAdapter Members
System.Data.SqlServerCe Namespace
MissingMappingAction Enumeration
MissingSchemaAction Enumeration