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; } }