SqlCeReplication 建構 (String, String, String, String, String, String, String, String)

初始化 SqlCeReplication 物件的新執行個體，並設定必要屬性，以連接至發行集。

命名空間：  System.Data.SqlServerCe
組件：  System.Data.SqlServerCe (在 System.Data.SqlServerCe.dll 中)

語法

'宣告
Public Sub New ( _
    internetUrl As String, _
    internetLogin As String, _
    internetPassword As String, _
    publisher As String, _
    publisherDatabase As String, _
    publication As String, _
    subscriber As String, _
    subscriberConnectionString As String _
)
'用途
Dim internetUrl As String
Dim internetLogin As String
Dim internetPassword As String
Dim publisher As String
Dim publisherDatabase As String
Dim publication As String
Dim subscriber As String
Dim subscriberConnectionString As String

Dim instance As New SqlCeReplication(internetUrl, _
    internetLogin, internetPassword, _
    publisher, publisherDatabase, publication, _
    subscriber, subscriberConnectionString)

public SqlCeReplication(
    string internetUrl,
    string internetLogin,
    string internetPassword,
    string publisher,
    string publisherDatabase,
    string publication,
    string subscriber,
    string subscriberConnectionString
)

public:
SqlCeReplication(
    String^ internetUrl, 
    String^ internetLogin, 
    String^ internetPassword, 
    String^ publisher, 
    String^ publisherDatabase, 
    String^ publication, 
    String^ subscriber, 
    String^ subscriberConnectionString
)

new : 
        internetUrl:string * 
        internetLogin:string * 
        internetPassword:string * 
        publisher:string * 
        publisherDatabase:string * 
        publication:string * 
        subscriber:string * 
        subscriberConnectionString:string -> SqlCeReplication

public function SqlCeReplication(
    internetUrl : String, 
    internetLogin : String, 
    internetPassword : String, 
    publisher : String, 
    publisherDatabase : String, 
    publication : String, 
    subscriber : String, 
    subscriberConnectionString : String
)

參數

• internetUrl
  型別：System. . :: . .String
  用於連接到 SQL Server Compact 3.5 伺服器代理程式的 URL。

• internetLogin
  型別：System. . :: . .String
  連接到 SQL Server Compact 3.5 伺服器代理程式時使用的登入名稱。

• internetPassword
  型別：System. . :: . .String
  連接到 SQL Server Compact 3.5 伺服器代理程式時使用的密碼。

• publisher
  型別：System. . :: . .String
  「發行者」的名稱。

• publisherDatabase
  型別：System. . :: . .String
  發行集資料庫的名稱。

• publication
  型別：System. . :: . .String
  已經針對匿名合併訂閱啟用的發行集名稱。

• subscriber
  型別：System. . :: . .String
  「訂閱者」的名稱。

• subscriberConnectionString
  型別：System. . :: . .String
  SQL Server Compact 3.5 資料庫在 Windows Mobile 裝置上的 OLE DB 連接字串。

範例

此範例會使用 AddSubscription 和 Synchronize 方法來建立新的訂閱資料庫。

Dim repl As SqlCeReplication = Nothing

Try
    ' Instantiate and configure SqlCeReplication object
    '
    'NOTE: when possible, prompt users to enter security 
    'credentials at runtime. If you store credentials in a file, 
    'you must secure the file to prevent unauthorized access.
    '
    repl = New SqlCeReplication()
    repl.InternetUrl = "https://www.adventure-works.com/sqlce/sqlcesa35.dll"
    repl.InternetLogin = "MyInternetLogin"
    repl.InternetPassword = "<enterStrongPassword>"
    repl.Publisher = "MyPublisher"
    repl.PublisherDatabase = "MyPublisherDatabase"
    repl.PublisherLogin = "MyPublisherLogin"
    repl.PublisherPassword = "<enterStrongPassword>"
    repl.Publication = "MyPublication"
    repl.Subscriber = "MySubscriber"
    repl.SubscriberConnectionString = "Data Source=MyDatabase.sdf"

    ' Create the local SQL Mobile Database subscription
    '
    repl.AddSubscription(AddOption.CreateDatabase)

    ' Synchronize to the SQL Server to populate the Subscription 
    '
    repl.Synchronize()
Catch
    ' Handle errors here
    '
Finally
    ' Dispose the repl object
    '
    repl.Dispose()
End Try

SqlCeReplication repl = null;

try
{
    // Instantiate and configure SqlCeReplication object
    //
    //NOTE: when possible, prompt users to enter security 
    //credentials at runtime. If you store credentials in a file, 
    //you must secure the file to prevent unauthorized access.
    //
    repl = new SqlCeReplication();
    repl.InternetUrl = "https://www.adventure-works.com/sqlce/sqlcesa35.dll";
    repl.InternetLogin = "MyInternetLogin";
    repl.InternetPassword = "<enterStrongPassword>";
    repl.Publisher = "MyPublisher";
    repl.PublisherDatabase = "MyPublisherDatabase";
    repl.PublisherLogin = "MyPublisherLogin";
    repl.PublisherPassword = "<enterStrongPassword>";
    repl.Publication = "MyPublication";
    repl.Subscriber = "MySubscriber";
    repl.SubscriberConnectionString = "Data Source=MyDatabase.sdf";

    // Create a local SQL Mobile Database subscription
    //
    repl.AddSubscription(AddOption.CreateDatabase);

    // Synchronize to the SQL Server database
    //
    repl.Synchronize();
}
catch (SqlCeException)
{
    // Handle errors here
    //
}
finally
{
    // Dispose the repl object
    //
    repl.Dispose();
}

請參閱

參考

SqlCeReplication類別

SqlCeReplication 成員

SqlCeReplication 多載

System.Data.SqlServerCe 命名空間