Propriedade InternetUrl

Artigo
01/17/2011

Especifica a URL usada para conectar o Agente de Servidor do SQL Server Compact 3.5. O Agente de Servidor do SQL Server Compact 3.5 é a DLL ISAPI dos Serviços de Informações da Internet (IIS) da Microsoft que conecta o cliente SQL Server Compact 3.5 ao Banco de dados do Microsoft SQL Server. Esta propriedade deve ser especificada.

Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (em System.Data.SqlServerCe.dll)

Sintaxe

'Declaração
Public Property InternetUrl As String
    Get
    Set
'Uso
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)

Valor da propriedade

Tipo: System. . :: . .String
A cadeia de caracteres que contém a URL do Agente de Servidor do SQL Server Compact 3.5 (incluindo seu nome de arquivo, Sqlcesa35.dll).

Exemplos

O exemplo a seguir mostra como definir a propriedade InternetUrl de um objeto 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();
}

Consulte também

Referência

SqlCeRemoteDataAccess Classe

Membros SqlCeRemoteDataAccess

Namespace System.Data.SqlServerCe

Partilhar via