C#

Harvey Saayman wrote:

Im trying to use it on a WPF control,

ContextMenu myContextMenu; 

private void Border_MouseRightButtonDown(object sender, MouseButtonEventArgs e)
{
    foreach (CellContent cell in Cells) // foreach the array that contains the cells
    {
        if (((Border)sender).Name == cell.CellBorder.Name) // if the sender was found in the array
        {
            //
            // Some graphical stuff of the cell change here
            //

            myContextMenu = new ContextMenu();

            myContextMenu.Items.Add("Day Off");
            myContextMenu.Items.Add("-");

            ShiftCtxDataContext shiftCtx = new ShiftCtxDataContext(sqlConnString);
            
            // query the shift table
            var queryResult = (from myShifts in shiftCtx.Shifts
                              select myShifts.SHF_Name_VC30);

            // foreach the results of the query and add it to the context menus items
            foreach (var item in queryResult)
            {
                myContextMenu.Items.Add(item.ToString());
            }

            // display context menu
            myContextMenu.IsOpen = true;
        }
    }
}

using System;
using System.Windows;
using System.Windows.Controls;

namespace WpfApplication1
{
    /// <summary>
    /// Interaction logic for Window1.xaml
    /// </summary>
    public partial class Window1 : Window
    {
        public Window1()
        {
            InitializeComponent();
            System.Windows.Controls.ContextMenu cm = new ContextMenu();
            MenuItem item = new MenuItem();
            item.Header = "test";
            item.Click += new RoutedEventHandler(item_Click);
            cm.Items.Add(item);
            this.ContextMenu = cm;
        }

        void item_Click(object sender, RoutedEventArgs e)
        {
            MenuItem item = (MenuItem)sender;
            Console.WriteLine(item.Header);
        }
    }
}

CurrentPerson = (IPerson)comboBox1.selectedItem;

private void GetDatabaseSps(TreeView tree, TreeNode spsNode, string sqlServerInctance)
        {
            // create a list of strings to hold name of sps
            List<string> sps = new List<string>();

            // get database name from parent node (database node is parent node of tablesNode)
            string database = spsNode.Parent.Text;

            // create a server object to interact with sql server inctance
            Microsoft.SqlServer.Management.Smo.Server server = new Microsoft.SqlServer.Management.Smo.Server(sqlServerInctance);

            // iterate through each sp that exist in database object
            foreach (Microsoft.SqlServer.Management.Smo.StoredProcedure sp in server.Databases[database].StoredProcedures)
            {
                if (sp.IsSystemObject)
                {
                }
                else
                {
                    sps.Add(sp.Name);
                }
            }

            // clear current nodes
            spsNode.Nodes.Clear();

            // iterate through list object and add each item (table name) to treeView
            foreach (string str in sps)
            {
                // create a node to hold table name (child node or level 1)
                TreeNode spNode = new TreeNode(str);

                // add tableNode to tablesNode
                spsNode.Nodes.Add(spNode);
            }
        }