SqlCeRemoteDataAccess constructeur (String, String)

Article
01/17/2011

Initialise une nouvelle instance de l'objet SqlCeRemoteDataAccess et la configure pour un accès anonyme à Microsoft Internet Information Services (IIS).

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

Syntaxe

'Déclaration
Public Sub New ( _
    internetUrl As String, _
    localConnectionString As String _
)
'Utilisation
Dim internetUrl As String
Dim localConnectionString As String

Dim instance As New SqlCeRemoteDataAccess(internetUrl, _
    localConnectionString)

public SqlCeRemoteDataAccess(
    string internetUrl,
    string localConnectionString
)

public:
SqlCeRemoteDataAccess(
    String^ internetUrl, 
    String^ localConnectionString
)

new : 
        internetUrl:string * 
        localConnectionString:string -> SqlCeRemoteDataAccess

public function SqlCeRemoteDataAccess(
    internetUrl : String, 
    localConnectionString : String
)

Paramètres

internetUrl
Type : System. . :: . .String
URL utilisée pour se connecter à l'agent serveur SQL Server Compact 3.5.

localConnectionString
Type : System. . :: . .String
Chaîne de connexion OLE DB de la base de données SQL Server Compact 3.5.

Notes

Ce constructeur initialise les propriétés InternetUrl et LocalConnectionString. Les autres propriétés reçoivent leurs valeurs par défaut. Vous pouvez ensuite modifier la valeur de n'importe quelle propriété.

Exemples

' Connection String to the SQL Server.
Dim rdaOleDbConnectString As String = _
    "Provider=sqloledb; Data Source=MySqlServer;Initial Catalog=Northwind; " + _
    "User Id=username;Password = <password>"

' Initialize RDA Object.
Dim rda As SqlCeRemoteDataAccess = Nothing

Try
    'Try the Pull Operation.
    rda = New SqlCeRemoteDataAccess()

    rda.InternetLogin         = "MyLogin"
    rda.InternetPassword      = "<password>"
    rda.InternetUrl           = "<http://www.northwindtraders.com/sqlce/sscesa35.dll>"
    rda.LocalConnectionString = "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data Source=\ssce.sdf"

    rda.Pull("Employees", "Select * from Employees", _
       rdaOleDbConnectString, _
       RdaTrackOption.TrackingOnWithIndexes, _
       "ErrorTable")

Catch e As SqlCeException
'Use you own Error Handling Routine.
'ShowErrors(e);
Finally
   'Dispose of the RDA Object.
   rda.Dispose()
End Try

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

// Initialize RDA Object.
SqlCeRemoteDataAccess rda = null;

try {
    //Try the Pull Operation.
    rda = new SqlCeRemoteDataAccess();

    rda.InternetLogin          = "MyLogin";
    rda.InternetPassword       = "<password>";
    rda.InternetUrl            = "<http://www.northwindtraders.com/sqlce/sscesa35.dll>";
    rda.LocalConnectionString  = @"Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data Source=\ssce.sdf";

    rda.Pull(
        "Employees", 
        "Select * from Employees", 
        rdaOleDbConnectString, 
        RdaTrackOption.TrackingOnWithIndexes , 
        "ErrorTable");
}
catch(SqlCeException) {
    //Use you own Error Handling Routine.
}
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