SqlCeRemoteDataAccess constructeur (String, String, String, String)

Article
01/17/2011

Initialise une nouvelle instance de l'objet SqlCeRemoteDataAccess et la configure en fonction d'une authentification de base ou intégrée de Windows pour 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, _
    internetLogin As String, _
    internetPassword As String, _
    localConnectionString As String _
)
'Utilisation
Dim internetUrl As String
Dim internetLogin As String
Dim internetPassword As String
Dim localConnectionString As String

Dim instance As New SqlCeRemoteDataAccess(internetUrl, _
    internetLogin, internetPassword, _
    localConnectionString)

public SqlCeRemoteDataAccess(
    string internetUrl,
    string internetLogin,
    string internetPassword,
    string localConnectionString
)

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

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

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

Paramètres

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

internetLogin
Type : System. . :: . .String
Nom de connexion utilisé pour se connecter à l'Agent serveur SQL Server Compact 3.5.

internetPassword
Type : System. . :: . .String
Mot de passe utilisé 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, InternetLogin, InternetPassword 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