SqlCeRemoteDataAccess constructeur

Article
01/17/2011

Initialise une nouvelle instance de l'objet SqlCeRemoteDataAccess.

Espace de noms : System.Data.SqlServerCe
Assembly : System.Data.SqlServerCe (dans System.Data.SqlServerCe.dll)

Syntaxe

'Déclaration
Public Sub New
'Utilisation

Dim instance As New SqlCeRemoteDataAccess()

public SqlCeRemoteDataAccess()

public:
SqlCeRemoteDataAccess()

new : unit -> SqlCeRemoteDataAccess

public function SqlCeRemoteDataAccess()

Notes

Ce constructeur rétablit les valeurs par défaut de tous les champs. Vous pouvez ensuite modifier la valeur de n'importe quelle propriété.

Exemples

L'exemple suivant montre comment initialiser une nouvelle instance de l'objet SqlCeRemoteDataAccess.

' Connection String to the SQL Server
'
Dim rdaOleDbConnectString As String = "Data Source=MySqlServer;Initial Catalog=AdventureWorks; " & _
    "User Id=username;Password = <password>"

' Initialize RDA Object
'
Dim rda As SqlCeRemoteDataAccess = Nothing

Try
    ' Try the Pull Operation
    '
    rda = New SqlCeRemoteDataAccess( _
        "https://www.adventure-works.com/sqlmobile/sqlcesa35.dll", _
        "MyLogin", _
        "<password>", _
        "Data Source=MyDatabase.sdf")

    rda.Pull("Employees", "SELECT * FROM DimEmployee", rdaOleDbConnectString, _
        RdaTrackOption.TrackingOnWithIndexes, "ErrorTable")

    ' or, try one of these overloads:
    ' rda.Pull("Employees", "SELECT * FROM DimEmployee", rdaOleDbConnectString, _
    '     RdaTrackOption.TrackingOnWithIndexes)
    '
    ' rda.Pull("Employees", "SELECT * FROM DimEmployee", rdaOleDbConnectString)

Catch
    ' Handle errors here
    '
Finally
    ' Dispose of the RDA object
    '
    rda.Dispose()
End Try

// Connection String to the SQL Server
//
string rdaOleDbConnectString = "Data Source=MySqlServer;Initial Catalog=AdventureWorks; " +
    "User Id=username;Password = <password>";

// Initialize RDA Object
//
SqlCeRemoteDataAccess rda = null;

try
{
    // Try the Pull Operation
    //
    rda = new SqlCeRemoteDataAccess(
        "https://www.adventure-works.com/sqlmobile/sqlcesa35.dll",
        "MyLogin",
        "<password>",
        "Data Source=MyDatabase.sdf");

    rda.Pull("Employees", "SELECT * FROM DimEmployee", rdaOleDbConnectString,
        RdaTrackOption.TrackingOnWithIndexes, "ErrorTable");

    // or, try one of these overloads:
    //
    // rda.Pull("Employees", "SELECT * FROM DimEmployee", rdaOleDbConnectString,
    //     RdaTrackOption.TrackingOnWithIndexes);
    //
    // rda.Pull("Employees", "SELECT * FROM DimEmployee", rdaOleDbConnectString);
}
catch (SqlCeException)
{
    // Handle errors here
    //
}
finally
{
    // Dispose of the RDA object
    //
    rda.Dispose();
}

Voir aussi

Référence

SqlCeRemoteDataAccess Classe

Membres SqlCeRemoteDataAccess

Surcharge SqlCeRemoteDataAccess

Espace de noms System.Data.SqlServerCe

Partager via