public partial class KAELCForm1 : Form
    {
        //Connect to SQL Server database
        SqlConnection cs = new SqlConnection(@"Data Source=MEDESKTOP;AttachDbFilename=J:\Users\Gary\Documents\Visual Studio 2010\Projects\KA_Email_League_Cup\KA_Email_League_Cup\KAELC_DB.mdf;Initial Catalog=myKADB;Integrated Security=True");

        public KAELCForm1()
        {
            InitializeComponent();

            //Set up SQL statement
            SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM LEAGUES", cs);

            //Create Dataset
            DataTable dt = new DataTable();

            //Fill Dataset
            da.Fill(dt);

            //Fill ComboBox from Dataset
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                KAELCcomboBox1.Items.Add(dt.Rows[i]["LeagueName"]);
            }

            KAELCcomboBox1.Text = "Select From Options Below ...";
        }