public SqlStringEditorDialog()
{
InitializeComponent();
this._scsb = new SqlConnectionStringBuilder();
this._sqlapp = new SQLDMO.ApplicationClass();
this._sqlservers = this._sqlapp.ListAvailableSQLServers();
this._server = new SQLDMO.SQLServerClass();
}
//获取SQL服务器列表
public ArrayList GetSqlServerList()
{
ArrayList list = new ArrayList();
SQLDMO.Application sqlApp = new SQLDMO.Application();
SQLDMO.NameList ServerName = sqlApp.ListAvailableSQLServers();
for (int i = 0; i < ServerName.Count; i++)
{
list.Add(ServerName.Item(i + 1));
}
return(list);
}
private void getSQLServer()
{
SQLDMO.Application SQLServer = new SQLDMO.Application();
SQLDMO.NameList strServerList = SQLServer.ListAvailableSQLServers();
if (strServerList.Count > 0)
{
for (int i = 0; i < strServerList.Count; i++)
{
cbbSqlServerName.Items.Add(strServerList.Item(i + 1));
}
}
}
private void Form2_Load(object sender, EventArgs e)
{
listBox1.Items.Clear();
SQLDMO.Application SQLServer = new SQLDMO.Application();
SQLDMO.NameList strServer = SQLServer.ListAvailableSQLServers();
if (strServer.Count > 0)
{
for (int i = 0; i < strServer.Count; i++)
{
listBox1.Items.Add(strServer.Item(i + 1));
}
}
}
private void buildServerMap()
{
sqlServersMap = new Dictionary<string, string>();
//get all available SQL Servers
SQLDMO.Application sqlApp = new SQLDMO.Application();
SQLDMO.NameList sqlServers = sqlApp.ListAvailableSQLServers();
ArrayList servs = new ArrayList();
for (int i = 0; i < sqlServers.Count; i++)
{
object srv = sqlServers.Item(i + 1);
if (srv != null)
{
sqlServersMap.Add(srv.ToString(), srv.ToString());
}
}
}
/// <summary>
/// Get Server List By SQLDMO Com
/// </summary>
private void InitServerList()
{
this.cboxServerList.Items.Clear();
SQLDMO.Application sqlApp = new SQLDMO.Application();
SQLDMO.NameList sqlServers = sqlApp.ListAvailableSQLServers();
for (int i = 0; i < sqlServers.Count; i++)
{
object srv = sqlServers.Item(i + 1);
if (srv != null)
{
this.cboxServerList.Items.Add(srv);
}
}
if (this.cboxServerList.Items.Count > 0)
{
this.cboxServerList.SelectedIndex = 0;
}
else
{
this.cboxServerList.Text = "<No available SQL Servers>";
}
}
