private IFrmMain frmMain = null; //主窗体
#endregion
#region [ 事件: 窗体加载 ]
/// <summary>
/// 窗体加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void FrmSqlList_Load(object sender, EventArgs e)
{
SQLDMO.Application sqlApp = new SQLDMO.ApplicationClass(); //分布式管理对象
try
{
SQLDMO.NameList serverList = sqlApp.ListAvailableSQLServers();//获取服务器名称列表
if (serverList.Count > 0)
{
for (int i = 1; i <= serverList.Count; i++)
{
ltbServer.Items.Add(serverList.Item(i));//绑定到ListBox
}
}
else
{
ltbServer.Items.Add("(local)"); //如果没有活动的服务器，加载本机
}
ltbServer.SelectedIndex = 0;
}
catch (Exception ex)
{
ErrorMessage(3010010, ex.StackTrace, "[FrmDBSet:LoadSqlList]", ex.Message);
//3010010frmMain.ErrorMessage(ee.Message, true, false);
}
finally
{
sqlApp.Quit();
}
}
// 在用户的配置时，我们需要列出当前局域网内所有的数据库服务器，并且要列出指定服务器的所有数据库，实现代码如下：
// 取得数据库服务器列表：
/// <summary>
/// 获取数据库服务器列表
/// </summary>
/// <returns></returns>
public static ArrayList GetServerList(out bool isErr)
{
ArrayList allServers = new ArrayList();
try
{
SQLDMO.Application sqlApp = new SQLDMO.ApplicationClass();
// 将局域网类的所有能够连接SQL的服务器名称列出
SQLDMO.NameList serverList = sqlApp.ListAvailableSQLServers();
allServers.Add("(local)");
for (int i = 1; i <= serverList.Count; i++)
{
// 添加到列表中
allServers.Add(serverList.Item(i));
}
sqlApp.Quit();
isErr = true;
}
catch (Exception e)
{
isErr = SqlErrRepair(e.Message.ToString());
return GetServerList(out isErr);
}
return allServers;
}
private void FillDBServer()
{
if (cbxDBServerList.Items.Count == 0)
{
SQLDMO.NameList names;
SQLDMO.ApplicationClass ac = new SQLDMO.ApplicationClass();
names = ac.ListAvailableSQLServers();
string[] serverList = new string[names.Count];
for (int i = 0; i < serverList.Length; i++)
{
serverList[i] = names.Item(i);
}
foreach (string severName in serverList)
{
if (severName != null)
{
cbxDBServerList.Items.Add(severName);
}
}
}
}
// 在用户的配置时，我们需要列出当前局域网内所有的数据库服务器，并且要列出指定服务器的所有数据库，实现代码如下：
// 取得数据库服务器列表：
/// <summary>
/// 获取数据库服务器列表
/// </summary>
/// <returns></returns>
public static ArrayList GetServerList(out bool isErr)
{
ArrayList allServers = new ArrayList();
try
{
SQLDMO.Application sqlApp = new SQLDMO.ApplicationClass();
// 将局域网类的所有能够连接SQL的服务器名称列出
SQLDMO.NameList serverList = sqlApp.ListAvailableSQLServers();
allServers.Add("(local)");
for (int i = 1; i <= serverList.Count; i++)
{
// 添加到列表中
allServers.Add(serverList.Item(i));
}
sqlApp.Quit();
isErr = true;
}
catch (Exception e)
{
isErr = SqlErrRepair(e.Message.ToString());
return(GetServerList(out isErr));
}
return(allServers);
}
private IFrmMain frmMain = null; //主窗体
#endregion
#region [ 事件: 窗体加载 ]
/// <summary>
/// 窗体加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void FrmSqlList_Load(object sender, EventArgs e)
{
SQLDMO.Application sqlApp = new SQLDMO.ApplicationClass(); //分布式管理对象
try
{
SQLDMO.NameList serverList = sqlApp.ListAvailableSQLServers();//获取服务器名称列表
if (serverList.Count > 0)
{
for (int i = 1; i <= serverList.Count; i++)
{
ltbServer.Items.Add(serverList.Item(i));//绑定到ListBox
}
}
else
{
ltbServer.Items.Add("(local)"); //如果没有活动的服务器，加载本机
}
ltbServer.SelectedIndex = 0;
}
catch (Exception ex)
{
ErrorMessage(3010010, ex.StackTrace, "[FrmDBSet:LoadSqlList]", ex.Message);
//3010010frmMain.ErrorMessage(ee.Message, true, false);
}
finally
{
sqlApp.Quit();
}
}
public ArrayList GetServerList()
{
ArrayList alServers = new ArrayList();
SQLDMO.Application sqlApp = new SQLDMO.ApplicationClass();
try
{
SQLDMO.NameList serverList = sqlApp.ListAvailableSQLServers();
for (int i = 1; i <= serverList.Count; i++)
{
alServers.Add(serverList.Item(i));
//comboBox1.Items.Add(serverList.Item(i));
//listBox1.Items.Add(serverList.Item(i));
}
}
catch (Exception e)
{
throw (new Exception("Take the database server list error：" + e.Message));
}
finally
{
sqlApp.Quit();
}
return(alServers);
}
/// <summary>
/// Handles the DropDown event of the comboBoxSqlServer control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
private void comboBoxSqlServer_DropDown(object sender, EventArgs e)
{
comboBoxSqlServer.Items.Clear();
Application.UseWaitCursor = true;
try
{
SQLDMO.ApplicationClass app = new SQLDMO.ApplicationClass();
SQLDMO.NameList servers = app.ListAvailableSQLServers();
for (int i = 1; i <= servers.Count; i++)
{
comboBoxSqlServer.Items.Add(servers.Item(i));
}
}
catch (Exception ex)
{
Trace.WriteLine(ex, "Mediachase.Ibn.ConfigurationUI.SQLDMO");
}
Application.UseWaitCursor = false;
}
private void FillDBServer()
{
if (cbxDBServerList.Items.Count == 0)
{
SQLDMO.NameList names;
SQLDMO.ApplicationClass ac = new SQLDMO.ApplicationClass();
names = ac.ListAvailableSQLServers();
string[] serverList = new string[names.Count];
for (int i = 0; i < serverList.Length; i++)
{
serverList[i] = names.Item(i);
}
foreach (string severName in serverList)
{
if (severName != null)
{
cbxDBServerList.Items.Add(severName);
}
}
}
}
/// <summary>
/// Handles the DropDown event of the comboBoxSqlServer control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
private void comboBoxSqlServer_DropDown(object sender, EventArgs e)
{
comboBoxSqlServer.Items.Clear();
Application.UseWaitCursor = true;
try
{
SQLDMO.ApplicationClass app = new SQLDMO.ApplicationClass();
SQLDMO.NameList servers = app.ListAvailableSQLServers();
for (int i = 1; i <= servers.Count; i++)
{
comboBoxSqlServer.Items.Add(servers.Item(i));
}
}
catch (Exception ex)
{
Trace.WriteLine(ex, "Mediachase.Ibn.ConfigurationUI.SQLDMO");
}
Application.UseWaitCursor = false;
}
