C#

SqlCommand command = new SqlCommand();
command.Connection = ...//set to your connection 
command.CommandText = "sp_name";
command.Paramaters.Add("@paramName, System.Data.SqlTypes.SqlDecimal).Value = 0m; //use correct type param
using(SqlDataReader reader = command.ExecuteReader()){
    while(reader.Read()){
        //The reader contains the columns of each record
    }
}//end using

class ConvertDictionary
{
    Dictionary<string, int> _dictionary = new Dictionary<string, int>()
    {
        {"salmon", 5},
        {"tuna", 6},
        {"clam", 2},
        {"asparagus", 3}
    };

    public ConvertDictionary()
    {
        // Convert dictionary to string and save
        string s = GetLine(_dictionary);
        File.WriteAllText("dict.txt", s);
        // Get dictionary from that file
        Dictionary<string, int> d = GetDict("dict.txt");
    }

    string GetLine(Dictionary<string, int> d)
    {
        // Build up each line one-by-one and them trim the end
        StringBuilder builder = new StringBuilder();
        foreach (KeyValuePair<string, int> pair in d)
        {
            builder.Append(pair.Key).Append(":").Append(pair.Value).Append(',');
        }
        string result = builder.ToString();
        // Remove the final delimiter
        result = result.TrimEnd(',');
        return result;
    }

    Dictionary<string, int> GetDict(string f)
    {
        Dictionary<string, int> d = new Dictionary<string, int>();
        string s = File.ReadAllText(f);
        // Divide all pairs (remove empty strings)
        string[] tokens = s.Split(new char[] { ':', ',' },
            StringSplitOptions.RemoveEmptyEntries);
        // Walk through each item
        for (int i = 0; i < tokens.Length; i += 2)
        {
            string name = tokens[i];
            string freq = tokens[i + 1];

            // Parse the int (this can throw)
            int count = int.Parse(freq);
            // Fill the value in the sorted dictionary
            if (d.ContainsKey(name))
            {
                d[name] += count;
            }
            else
            {
                d.Add(name, count);
            }
        }
        return d;
    }
}

//Up arrow
if(ListBox1.SelectedIndex!=0)
             {
                 int i = ListBox1.SelectedIndex; 
                 string s = ListBox1.Items[i].Text;
                 string s1 = ListBox1.Items[i - 1].Text;                 
                 ListBox1.Items[i-1].Text = s;
                 ListBox1.Items[i].Text = s1;
             }

//Down Arrow
if(ListBox1.SelectedIndex!=ListBox1.Items.Count)
             {
                 int i = ListBox1.SelectedIndex; 
                 string s = ListBox1.Items[i].Text;
                 string s1 = ListBox1.Items[i + 1].Text;                 
                 ListBox1.Items[i+1].Text = s;
                 ListBox1.Items[i].Text = s1;
             }

myInstance.GetType().GetProperty(whichMember)

<configuration>
 <system.net>
   <defaultProxy useDefaultCredentials="true" />
 </system.net>
</configuration>

f1.Somevariable=this.Returnvalueoftoolstripmenuitem();
f1.Show();

// UpdatableMenuItem.cs

namespace YourMdiApp
{
    public enum UpdatableMenuItem
    {
        File,
        Exit,
        View,
    }
}

// UpdateMenuItemEventArgs.cs
using System;

namespace YourMdiApp
{
    public delegate void UpdateMenuItemEventHandler(object sender, UpdateMenuItemEventArgs e);

    public class UpdateMenuItemEventArgs : EventArgs
    {
        private bool itemChecked;
        private bool enabled;
        private UpdatableMenuItem item;
        private bool visible;

        public UpdateMenuItemEventArgs(UpdatableMenuItem item, bool itemChecked, bool enabled, bool visible)
        {
            this.item = item;
            this.itemChecked = itemChecked;
            this.enabled = enabled;
            this.visible = visible;
        }

        public bool Checked
        {
            get { return itemChecked; }
        }
        public bool Enabled
        {
            get { return enabled; }
        }
        public UpdatableMenuItem Item
        {
            get { return item; }
        }
        public bool Visible
        {
            get { return visible; }
        }
    }
}

// FormChildBase.cs
using System.Windows.Forms;

namespace YourMdiApp
{
    public class FormChildBase : Form
    {
        public event UpdateMenuItemEventHandler UpdateMenuItem;

        protected virtual void OnUpdateMenuItem(UpdateMenuItemEventArgs e)
        {
            UpdateMenuItemEventHandler eh = UpdateMenuItem;
            if (eh != null)
                eh(this, e);
        }
        public void PerformUpdateMenuItem(UpdatableMenuItem item, bool itemChecked, bool enabled, bool visible)
        {
            OnUpdateMenuItem(new UpdateMenuItemEventArgs(item, itemChecked, enabled, visible));
        }
    }
}

// FormChildA.cs
using System;

namespace YourMdiApp
{
    public partial class FormChildA : FormChildBase
    {
        public FormChildA()
        {
            InitializeComponent();
            /* Clicking this form will disable the File menu on the main form */
            Click += new EventHandler(FormChildA_Click);
        }

        void FormChildA_Click(object sender, EventArgs e)
        {
            PerformUpdateMenuItem(UpdatableMenuItem.File, false, false, true);
        }
    }
}

// FormMain.cs
/* Menu and items added in designer and IsMdiContainer property set to true */
using System.Windows.Forms;

namespace YourMdiApp
{
    public partial class FormMain : Form
    {
        public FormMain()
        {
            InitializeComponent();
            FormChildA formChildA = new FormChildA();
            formChildA.UpdateMenuItem += new UpdateMenuItemEventHandler(formChildA_UpdateMenuItem);
            formChildA.MdiParent = this;
            formChildA.Show();
        }

        void formChildA_UpdateMenuItem(object sender, UpdateMenuItemEventArgs e)
        {
            ToolStripMenuItem item = null;
            switch (e.Item)
            {
                case UpdatableMenuItem.File:
                    item = fileToolStripMenuItem;
                    break;
                // ...
            }
            if (item != null)
            {
                item.Checked = e.Checked;
                item.Enabled = e.Enabled;
                item.Visible = e.Visible;
            }
        }
    }
}

// FormMain.cs
/* Menu and items added in designer and IsMdiContainer property set to true */
using System.Collections.Generic;
using System.Windows.Forms;

namespace YourMdiApp
{
    public partial class FormMain : Form
    {
        private Dictionary<UpdatableMenuItem, ToolStripMenuItem> menuItemDictionary;

        public FormMain()
        {
            InitializeComponent();
            menuItemDictionary = new Dictionary<UpdatableMenuItem, ToolStripMenuItem>()
            {
                { UpdatableMenuItem.File, fileToolStripMenuItem }
            };
            FormChildA formChildA = new FormChildA();
            formChildA.UpdateMenuItem += new UpdateMenuItemEventHandler(formChildA_UpdateMenuItem);
            formChildA.MdiParent = this;
            formChildA.Show();
        }

        void formChildA_UpdateMenuItem(object sender, UpdateMenuItemEventArgs e)
        {
            ToolStripMenuItem item;
            if (menuItemDictionary.TryGetValue(e.Item, out item))
            {
                item.Checked = e.Checked;
                item.Enabled = e.Enabled;
                item.Visible = e.Visible;
            }
        }
    }
}

AussieLew wrote:

Thanks

AussieLew wrote:

I have been struggling with fully understanding the concept of delegates, so this will prompt me to get a handle on that first.