private void gal_WooTable_Format_ButtonClick(object sender, RibbonControlEventArgs e) { try { Microsoft.Office.Tools.Ribbon.RibbonButton _but = (Microsoft.Office.Tools.Ribbon.RibbonButton)sender; Converter(_but.Name); } catch (Exception E) { System.Windows.Forms.MessageBox.Show("Urgh, this was quite an unexpected error, I don't get what you clicked: " + E.Message + ". Sorry for that.", "WooTable .::. Error", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); } }
private void QuickConnectMenu_ItemsLoading( object sender, RibbonControlEventArgs e) { QuickConnectItem = null; XmlDocument dbInfo = new XmlDocument(); ConnectionStatus.xmlPath = Environment.GetFolderPath( Environment.SpecialFolder.Personal) + "\\SEMC_SQL_For_Excel.xml"; if (System.IO.File.Exists(ConnectionStatus.xmlPath)) { dbInfo.Load(ConnectionStatus.xmlPath); XmlNodeList recNode = dbInfo.SelectNodes("//DBInfo/DB"); //This is for each text in every child. That's we can easily find any text. if (QuickConnect.Items.Count != 0) { QuickConnect.Items.Clear(); } foreach (XmlNode node in recNode) { string temp; temp = node.Attributes[0].Value.ToString(); this.QuickConnectItem = this.Factory.CreateRibbonButton(); this.QuickConnectItem.Label = temp; this.QuickConnectItem.Name = temp; this.QuickConnectItem.Click += new RibbonControlEventHandler(QuickConnectItems_Click); this.QuickConnectItem.Visible = true; this.QuickConnectItem.ShowImage = false; QuickConnect.Items.Add(this.QuickConnectItem); this.QuickConnectItem.Dispose(); } dbInfo = null; ConnectionStatus.xmlPath = null; recNode = null; } QuickConnectItem.Dispose(); }
private void QuickConnectMenu_ItemsLoading( object sender, RibbonControlEventArgs e) { QuickConnectItem = null; XmlDocument dbInfo = new XmlDocument(); ConnectionStatus.xmlPath = Environment.GetFolderPath( Environment.SpecialFolder.Personal) + "\\SEMC_SQL_For_Excel.xml"; if (System.IO.File.Exists(ConnectionStatus.xmlPath)) { dbInfo.Load(ConnectionStatus.xmlPath); XmlNodeList recNode = dbInfo.SelectNodes("//DBInfo/DB"); //This is for each text in every child. That's we can easily find any text. if(QuickConnect.Items.Count != 0) { QuickConnect.Items.Clear(); } foreach (XmlNode node in recNode) { string temp; temp = node.Attributes[0].Value.ToString(); this.QuickConnectItem = this.Factory.CreateRibbonButton(); this.QuickConnectItem.Label = temp; this.QuickConnectItem.Name = temp; this.QuickConnectItem.Click += new RibbonControlEventHandler(QuickConnectItems_Click); this.QuickConnectItem.Visible = true; this.QuickConnectItem.ShowImage = false; QuickConnect.Items.Add(this.QuickConnectItem); this.QuickConnectItem.Dispose(); } dbInfo = null; ConnectionStatus.xmlPath = null; recNode = null; } QuickConnectItem.Dispose(); }