private void btnBrowse_Click(object sender, EventArgs e)
{
DBEngineChooserDialog dialog = new DBEngineChooserDialog(Container);
dialog.ShowDialog(this);
if (dialog.DialogResult == DialogResult.OK)
{
if (dialog.SelectedItems != null)
{
ChooserControlItem selectedItem = dialog.SelectedItem as ChooserControlItem;
if ((selectedItem == null) || (selectedItem.Item == null))
{
}
else
{
EnterpriseManagementObject item = selectedItem.Item as EnterpriseManagementObject;
if (!string.IsNullOrEmpty(item.FullName))
{
if (item.DisplayName.ToLower() == "MSSQLServer".ToLower() || item.DisplayName.ToLower() == "SQLEXPRESS".ToLower())
{
txtInstanceName.Text = item.Path;
}
else
{
txtInstanceName.Text = item.Path + "\\" + item.DisplayName;
}
using (ManageQueryOleDBSDKHelper helper = new ManageQueryOleDBSDKHelper(ManagementGroup))
{
switch (item.GetClasses()[0].Name)
{
case "Microsoft.SQLServer.DBEngine":
Databases = helper.GetRelatedObjects(item.Id, "Microsoft.SQLServer.Library", "Microsoft.SQLServer.Database");
break;
case "Microsoft.SQLServer.2014.DBEngine":
Databases = helper.GetRelatedObjects(item.Id, "Microsoft.SQLServer.2014.Discovery", "Microsoft.SQLServer.2014.Database");
break;
case "Microsoft.SQLServer.2016.DBEngine":
Databases = helper.GetRelatedObjects(item.Id, "Microsoft.SQLServer.2016.Discovery", "Microsoft.SQLServer.2016.Database");
break;
default:
break;
}
cmbDatabase.DataSource = new BindingSource(Databases, null);
cmbDatabase.DisplayMember = "DisplayName";
cmbDatabase.ValueMember = "Id";
ManagementPackClass winClass = helper.GetManagementPackClass("Microsoft.Windows.Library", "Microsoft.Windows.Computer");
principalName = helper.GetObjectsByName(item.Path, winClass).FirstOrDefault().DisplayName;
}
}
}
}
}
}
private void PopulateGroups()
{
IManagementGroupSession managementGroupSession = null;
if (base.ParentForm != null && base.ParentForm.Site != null)
{
managementGroupSession = (base.ParentForm.Site.GetService(typeof(IManagementGroupSession)) as IManagementGroupSession);
}
if (managementGroupSession == null || managementGroupSession.ManagementGroup == null)
{
return;
}
using (ManageQueryOleDBSDKHelper helper = new ManageQueryOleDBSDKHelper(managementGroupSession.ManagementGroup))
{
monitoringClass = helper.GetManagementPackClass("QueryOleDbMonitorLibrary", "OleDBQueryMonitoringGroup");
if (GroupsImage == null)
{
GroupsImage = ComponentMethodLibrary.GetImageFromSharedCache(monitoringClass, base.ParentForm);
}
List <EnterpriseManagementObject> list = new List <EnterpriseManagementObject>();
IObjectReader <EnterpriseManagementObject> allGroups = helper.GetEnterpriseManagementObjects(monitoringClass);
if (allGroups != null)
{
foreach (EnterpriseManagementObject current in allGroups)
{
list.Add(current);
}
}
groups = list;
}
}
private void btnTest_Click(object sender, EventArgs e)
{
//
using (ManageQueryOleDBSDKHelper helper = new ManageQueryOleDBSDKHelper(ManagementGroup))
{
MessageBox.Show(helper.RunTestTask(txtConnectionString.Text, txtQuery.Text));
}
}
private void PopulateDBEngines()
{
IManagementGroupSession managementGroupSession = null;
if (base.ParentForm != null && base.ParentForm.Site != null)
{
managementGroupSession = (base.ParentForm.Site.GetService(typeof(IManagementGroupSession)) as IManagementGroupSession);
}
if (managementGroupSession == null || managementGroupSession.ManagementGroup == null)
{
return;
}
using (ManageQueryOleDBSDKHelper helper = new ManageQueryOleDBSDKHelper(managementGroupSession.ManagementGroup))
{
monitoringClass = helper.GetManagementPackClass("Microsoft.SQLServer.Library", "Microsoft.SQLServer.DBEngine");
monitoringClass2014 = helper.GetManagementPackClass("Microsoft.SQLServer.2014.Discovery", "Microsoft.SQLServer.2014.DBEngine");
monitoringClass2016 = helper.GetManagementPackClass("Microsoft.SQLServer.2016.Discovery", "Microsoft.SQLServer.2016.DBEngine");
if (DBEngineImage == null)
{
DBEngineImage = ComponentMethodLibrary.GetImageFromSharedCache(monitoringClass, base.ParentForm);
}
List <EnterpriseManagementObject> list = new List <EnterpriseManagementObject>();
if (monitoringClass != null)
{
IObjectReader <EnterpriseManagementObject> allDBEngines = helper.GetEnterpriseManagementObjects(monitoringClass);
if (allDBEngines != null)
{
foreach (EnterpriseManagementObject current in allDBEngines)
{
list.Add(current);
}
}
}
if (monitoringClass2014 != null)
{
IObjectReader <EnterpriseManagementObject> allDBEngines = helper.GetEnterpriseManagementObjects(monitoringClass2014);
if (allDBEngines != null)
{
foreach (EnterpriseManagementObject current in allDBEngines)
{
list.Add(current);
}
}
}
if (monitoringClass2016 != null)
{
IObjectReader <EnterpriseManagementObject> allDBEngines = helper.GetEnterpriseManagementObjects(monitoringClass2016);
if (allDBEngines != null)
{
foreach (EnterpriseManagementObject current in allDBEngines)
{
list.Add(current);
}
}
}
DBEngines = list;
}
}
