InternetUrl propriété

Article
01/17/2011

Spécifie l'URL utilisée pour se connecter à l'Agent serveur SQL Server Compact 3.5. L'Agent serveur SQL Server Compact 3.5 est la DLL ISAPI de Microsoft Internet Information Services (IIS) qui connecte le client SQL Server Compact 3.5 à la base de données Microsoft SQL Server. Cette propriété doit être spécifiée.

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

Syntaxe

'Déclaration
Public Property InternetUrl As String
    Get
    Set
'Utilisation
Dim instance As SqlCeRemoteDataAccess
Dim value As String

value = instance.InternetUrl

instance.InternetUrl = value

public string InternetUrl { get; set; }

public:
property String^ InternetUrl {
    String^ get ();
    void set (String^ value);
}

member InternetUrl : string with get, set

function get InternetUrl () : String
function set InternetUrl (value : String)

Valeur de la propriété

Type : System. . :: . .String
Chaîne contenant l'URL de l'Agent serveur SQL Server Compact 3.5 (y compris son nom de fichier, Sqlcesa35.dll).

Exemples

L'exemple suivant illustre la définition de la propriété InternetUrl d'un 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

Espace de noms System.Data.SqlServerCe

Partager via