コード例 #1
0
        private void LoadSectionsList()
        {
            try
            {
                Bunifu.Framework.UI.BunifuDropdown VirtualDropdown;
                VirtualDropdown = new Bunifu.Framework.UI.BunifuDropdown();

                string RetrieveQuery = "SELECT TOP 10 [SECTION NAME] FROM [Tbl.Sections] WHERE [SCHOOL YEAR] = '" + CurrentSchoolYear + "'";
                sqlcommand = new SqlCommand(RetrieveQuery, sqlconnection);
                SqlDataReader sqldatareader = sqlcommand.ExecuteReader();

                Init_FirstIndex_Dropdowns();
                Select_Dropdown_Index();

                while (sqldatareader.Read())
                {
                    VirtualDropdown.AddItem(sqldatareader.GetString(0));
                }
                sqldatareader.Close();

                VirtualDropdown.selectedIndex = 0;
                Handled_Sec1_Dropdown.AddItem(VirtualDropdown.selectedValue.ToString());

                VirtualDropdown.selectedIndex = 1;
                Handled_Sec2_Dropdown.AddItem(VirtualDropdown.selectedValue.ToString());

                VirtualDropdown.selectedIndex = 2;
                Handled_Sec3_Dropdown.AddItem(VirtualDropdown.selectedValue.ToString());

                VirtualDropdown.selectedIndex = 3;
                Handled_Sec4_Dropdown.AddItem(VirtualDropdown.selectedValue.ToString());

                VirtualDropdown.selectedIndex = 4;
                Handled_Sec5_Dropdown.AddItem(VirtualDropdown.selectedValue.ToString());

                VirtualDropdown.selectedIndex = 5;
                Handled_Sec6_Dropdown.AddItem(VirtualDropdown.selectedValue.ToString());

                VirtualDropdown.selectedIndex = 6;
                Handled_Sec7_Dropdown.AddItem(VirtualDropdown.selectedValue.ToString());

                VirtualDropdown.selectedIndex = 7;
                Handled_Sec8_Dropdown.AddItem(VirtualDropdown.selectedValue.ToString());

                VirtualDropdown.selectedIndex = 8;
                Handled_Sec9_Dropdown.AddItem(VirtualDropdown.selectedValue.ToString());

                VirtualDropdown.selectedIndex = 9;
                Handled_Sec10_Dropdown.AddItem(VirtualDropdown.selectedValue.ToString());
            }

            catch (Exception)
            {
                //DONT DISPLAY ANYTHING SHIT !
            }
        }
コード例 #2
0
        private void Init_FirstIndex_Dropdowns()
        {
            Handled_Sec1_Dropdown.AddItem("NOT SET");
            Handled_Sec2_Dropdown.AddItem("NOT SET");
            Handled_Sec3_Dropdown.AddItem("NOT SET");

            Handled_Sec4_Dropdown.AddItem("NOT SET");
            Handled_Sec5_Dropdown.AddItem("NOT SET");
            Handled_Sec6_Dropdown.AddItem("NOT SET");
            Handled_Sec7_Dropdown.AddItem("NOT SET");

            Handled_Sec8_Dropdown.AddItem("NOT SET");
            Handled_Sec9_Dropdown.AddItem("NOT SET");
            Handled_Sec10_Dropdown.AddItem("NOT SET");
        }