using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;

//所引入的命名空間using System.Data.Sql;

namespace EnumSqlServer{ public partial class MainForm : Form { public MainForm() { InitializeComponent(); }

private void MainForm_Load(object sender, EventArgs e) { //枚舉本地網(wǎng)絡(luò)內(nèi)所有可用SqlServer實(shí)例 SqlDataSourceEnumerator instance = SqlDataSourceEnumerator.Instance; //返回 //---------------------------------------------------------------------------- // ServerName;;;;;|服務(wù)器的名稱 //---------------------------------------------------------------------------- // InstanceName;|服務(wù)器實(shí)例的名稱。如果服務(wù)器作為默認(rèn)實(shí)例運(yùn)行，則為空白 //---------------------------------------------------------------------------- // IsClustered |指示服務(wù)器是否屬于群集 //---------------------------------------------------------------------------- // Version;;;;|服務(wù)器的版本(SQLServer2000為8.00.x,SQLServer2005為9.00.x) //---------------------------------------------------------------------------- DataTable dt = instance.GetDataSources(); //綁定 cboServerList.DataSource = CreateCboDataSource(dt); }

/// <summary> /// 取得ComBox的數(shù)據(jù)源 /// </summary> /// <param name='dt'></param> /// <returns></returns> private List<string> CreateCboDataSource(DataTable dt) { List<string> list = new List<string>();

foreach (DataRow dr in dt.Rows) { //只取ServerName list.Add(dr[0].ToString()); }

return list; } }}