SQL Server Compact Edition 程序建立步骤

repl.InternetUrl = @"http://<computername>/sqlmobile/sqlcesa30.dll";

repl.Publisher = @"<computername>";

repl.PublisherDatabase = @"SQLMobile";

repl.PublisherSecurityMode = SecurityType.NTAuthentication;

repl.Publication = @"SQLMobile";

repl.Subscriber = @"SQLMobile";

repl.SubscriberConnectionString = @"Data Source='" + filename +

"';Password='';Max Database Size='128';Default Lock Escalation

='100';";

try

{

repl.AddSubscription(AddOption. CreateDatabase);

repl.Synchronize();

}

catch (SqlCeException e)

{

MessageBox.Show(e.ToString());

}

}

最后，在调用最新创建的两个方法的 Form1_Load 事件处理程序的开头添加代码。Form1_Load 事件处理程序应如下所示：

[C#]

复制代码

private void Form1_Load(object sender, EventArgs e)