private void Form1_Load(object sender, EventArgs e)
{
InitDllList();
} private void InitDllList()
{
SQLDMO.Application SQLServer = new SQLDMO.Application();
SQLDMO.NameList strServerList = SQLServer.ListAvailableSQLServers();
if (strServerList.Count > 0)
{
for (int i = 0; i < strServerList.Count; i++)
{
listBox1.Items.Add(strServerList.Item(i));
}
} }代码应该没有问题,电脑上装了SQLSERVER2005,VS2008,可是一个服务器都获取不了,怎么回事
if (SqlClientFactory.Instance.CanCreateDataSourceEnumerator)
{
SqlDataSourceEnumerator instance = (SqlDataSourceEnumerator)(SqlClientFactory.Instance.CreateDataSourceEnumerator());
DataTable table = instance.GetDataSources();
}
这个datatable有InstanceName和ServerName两列,读出来就可以了