枚举SQLServer的实例

usingSystem;

usingSystem.Collections.Generic;

usingSystem.ComponentModel;

usingSystem.Data;

usingSystem.Drawing;

usingSystem.Text;

usingSystem.Windows.Forms;

//所引入的命名空间

usingSystem.Data.SQL（SQL Server培训 mySQL培训 ）;

namespaceEnumSqlServer

{

publicpartialclassMainForm:Form

{

publicMainForm()

{

InitializeComponent();

}

privatevoidMainForm_Load(objectsender,EventArgse)

{

//枚举本地网络内所有可用SqlServer实例

SqlDataSourceEnumeratorinstance=SqlDataSourceEnumerator.Instance;

//返回

//----------------------------------------------------------------------------

//ServerName|服务器的名称

//----------------------------------------------------------------------------

//InstanceName|服务器实例的名称。如果服务器作为默认实例运行，则为空白

//----------------------------------------------------------------------------

//IsClustered|指示服务器是否属于群集

//----------------------------------------------------------------------------

//Version|服务器的版本(SQLServer2000为8.00.x,SQLServer2005为9.00.x)

//----------------------------------------------------------------------------

DataTabledt=instance.GetDataSources();

//绑定

cboServerList.DataSource=CreateCboDataSource(dt);

}

///

///

///

privateListCreateCboDataSource(DataTabledt)

{

Listlist=newList();

foreach(DataRowdrindt.Rows)

{

//只取ServerName

list.Add(dr[0].ToString());

}

returnlist;

}

}

}