string storeList = ""; // The string that will contain the stores that the user selected

    protected void Page_Load(object sender, EventArgs e)
    {
        // Only run on initial page load
        if (!IsPostBack)
        {
            // Populate the checked box with data from the store table
            tStoreTableAdapter      storeTableAdapter = new tStoreTableAdapter();
            dsStore.tStoreDataTable storeDataTable    = storeTableAdapter.GetData();
            cbStore.DataTextField  = "StoreWithAddress";
            cbStore.DataValueField = "Store";
            cbStore.DataSource     = storeDataTable;
            cbStore.DataBind();
        }
    }
    /// <summary>
    /// Populate the dropdown and checkboxlist with appropriately formatted data
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            OpenConnection();
            //Populating the Product dropdown.
            tProductTableAdapter          productTypeAdapter = new tProductTableAdapter();
            ds_Products.tProductDataTable products           = productTypeAdapter.GetData();

            /*
             * Ref for below code: http://stackoverflow.com/questions/1143639/binding-multiple-fields-to-listbox-in-asp-net/
             * In all honesty not entirely sure how this works...
             * Is this kinda like a Lambda Function?
             * Specifically looked for this though to keep formatting out of the data layer.
             */
            EnumerableRowCollection productData = from product in products
                                                  select new
            {
                Name = product.Name + " - " + product.Description + " :by " + product.Manufacturer,
                Id   = product.ProductID
            };
            //end code I don't fully understand
            //The rest is just normal data binding.
            ddProducts.DataSource     = productData;
            ddProducts.DataTextField  = "Name";
            ddProducts.DataValueField = "Id";
            ddProducts.DataBind();

            //Use dataset to populate check box list
            tStoreTableAdapter       storeTypeAdapter = new tStoreTableAdapter();
            ds_Store.tStoreDataTable storeDataTable   = storeTypeAdapter.GetData();
            cblStores.DataTextField  = "StoreString";
            cblStores.DataValueField = "StoreID";
            cblStores.DataSource     = storeDataTable;
            cblStores.DataBind();
            cblStores.SelectedIndex = 0;
        }
    }