本文整理汇总了C#中ApplicationClass.ListAvailableSQLServers方法的典型用法代码示例。如果您正苦于以下问题:C# ApplicationClass.ListAvailableSQLServers方法的具体用法?C# ApplicationClass.ListAvailableSQLServers怎么用?C# ApplicationClass.ListAvailableSQLServers使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类ApplicationClass
的用法示例。
在下文中一共展示了ApplicationClass.ListAvailableSQLServers方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: cmbSqlServer_DropDown
private void cmbSqlServer_DropDown(object sender, EventArgs e) {
ApplicationClass app = new ApplicationClass();
this.cmbSqlServer.Items.Clear();
try {
foreach (object item in app.ListAvailableSQLServers()) {
this.cmbSqlServer.Items.Add(item);
}
}
catch (Exception e1) {
MessageBox.Show("Impossível enumerar os servidores da rede. Cheque a versão " +
"do cliente do SQL Server 2000 instalado na sua máquina. Versões anteriores " +
"ao SP2 contêm um bug que impede a enumeração dos servidores por aplicações .NET",
"Erro - " + e1.Source, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
示例2: PopulateServerNameCmb
/// <summary>
/// Uses SQL-DMO to retrieve all servers available on the network
/// </summary>
private void PopulateServerNameCmb()
{
ArrayList serverNames = new ArrayList();
Application dmo = new ApplicationClass();
try
{
NameList instances = dmo.ListAvailableSQLServers();
foreach(string instance in instances)
{
serverNames.Add(instance);
}
}
catch(InvalidCastException)
{
serverNames.Add("localhost");
}
machineName.DataSource=serverNames;
machineName.DataBind();
}