private void LoadTV(string dChoice)
        {
            try
            {
                string        str   = "";
                SqlConnection cnSQL = new SqlConnection(MyModules.strConnect);
                SqlCommand    cmSQL = new SqlCommand();
                cmSQL.Connection = cnSQL;
                SqlDataReader drSQL;
                switch (dChoice)
                {
                case "State":
                    str = "SELECT DISTINCT [State] AS dText FROM RegisterSchool";
                    break;

                case "Bank":
                    str = "SELECT DISTINCT [BankName] AS dText FROM RegisterSchool";
                    break;

                case "Category":
                    str = "SELECT DISTINCT [Category] AS dText FROM RegisterSchool";
                    break;

                case "Region":
                    str = "SELECT DISTINCT [Region] AS dText FROM RegisterSchool";
                    break;
                }


                TV.Nodes.Clear();
                cmSQL.CommandText = str;
                cmSQL.CommandType = CommandType.Text;
                cnSQL.Open();
                drSQL = cmSQL.ExecuteReader();

                TV.BeginUpdate();
                TV.Nodes.Add("ALL", "ALL").ForeColor = Color.Red;
                while (drSQL.Read())
                {
                    if (Convert.IsDBNull(drSQL[0]) == false)
                    {
                        TV.Nodes.Add(drSQL[0].ToString(), drSQL[0].ToString());
                    }
                    TV.EndUpdate();
                }

                //cmSQL.Connection.Close()
                cmSQL.Dispose();
                drSQL.Close();
                cnSQL.Close();
                cnSQL.Dispose();

                return;
            }
            catch (Exception ex)
            {
                MessageBox.Show("Ooops! ERROR :" + char.ConvertFromUtf32(13) + ex, MyModules.strApptitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }
示例#2
0
        private void LoadXML(object path)
        {
            XmlDocument xDoc = new XmlDocument();
            xDoc.Load((string)path);
            TV.BeginUpdate();
           TV.Nodes.Clear();
            TreeNode tn = new TreeNode(xDoc.DocumentElement.Name);
            AttType at = SaveNodeToTag(xDoc.DocumentElement);
            tn.Tag = at;
            
            TV.Nodes.Add(tn);

            addTreeNode(xDoc.DocumentElement, TV.Nodes[0]);
            TV.EndUpdate();
        }
示例#3
0
        private void FrmSchoolListings_Load(object sender, EventArgs e)
        {
            dGrid.DataSource = BindingSource1;
            MyModules.applyGridTheme(dGrid);
            dGrid.ReadOnly = true;
            SplitContainer2.SplitterDistance = 322;
            cboCriteria.SelectedIndex        = 1;

            TV.BeginUpdate();
            TV.Nodes.Add("ALL", "ALL").ForeColor = Color.Red;

            TV.Nodes.Add("2016", "2016-Lot1");
            TV.Nodes.Add("2017", "2016-Lot2");
            TV.Nodes.Add("2018", "2016-Lot3");

            TV.EndUpdate();

            //  LoadTV();
        }
示例#4
0
        private void LoadTV()
        {
            try
            {
                SqlConnection cnSQL = new SqlConnection(MyModules.strConnect);
                SqlCommand    cmSQL = new SqlCommand("SELECT DISTINCT [State] FROM Register", cnSQL);
                SqlDataReader drSQL;

                TV.Nodes.Clear();

                cmSQL.CommandType = CommandType.Text;
                cnSQL.Open();
                drSQL = cmSQL.ExecuteReader();

                TV.BeginUpdate();
                TV.Nodes.Add("ALL", "ALL").ForeColor = Color.Red;
                while (drSQL.Read())
                {
                    if (Convert.IsDBNull(drSQL[0]) == false)
                    {
                        TV.Nodes.Add(drSQL[0].ToString(), drSQL[0].ToString());
                    }
                    TV.EndUpdate();
                }

                //cmSQL.Connection.Close()
                cmSQL.Dispose();
                drSQL.Close();
                cnSQL.Close();
                cnSQL.Dispose();

                return;
            }
            catch (Exception ex)
            {
                MessageBox.Show("Ooops! ERROR :" + char.ConvertFromUtf32(13) + ex, MyModules.strApptitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }
示例#5
0
        private void LoadTV(string dChoice)
        {
            try
            {
                string        str   = "";
                SqlConnection cnSQL = new SqlConnection(MyModules.strConnect);
                SqlCommand    cmSQL = new SqlCommand();
                cmSQL.Connection = cnSQL;
                SqlDataReader drSQL;
                switch (dChoice)
                {
                case "State of Origin":
                    str = "SELECT DISTINCT [State] AS dText FROM RegisterStudent";
                    break;

                case "Bank":
                    str = "SELECT DISTINCT [BankName] AS dText FROM RegisterStudent";
                    break;

                case "Degree":
                    str = "SELECT DISTINCT [Degree] AS dText FROM RegisterStudent";
                    break;

                case "EndYear":
                    str = "SELECT DISTINCT [EndYear] AS dText FROM RegisterStudent";
                    break;

                case "School":
                    // str = "SELECT DISTINCT Cast([SchoolID] AS nvarchar(50)) + ' - ' + [SchName] AS dText  FROM RegisterStudent LEFT OUTER JOIN RegisterSchool ON RegisterStudent.SchoolID = RegisterSchool.Sn";
                    str = "SELECT DISTINCT Cast([SchoolID] AS nvarchar(50)) + ' - ' + [SchName] AS dText,[SchName]  FROM RegisterStudent ORDER BY SchName";
                    break;

                case "Category":
                    str = "SELECT DISTINCT [Category] AS dText FROM RegisterStudent";
                    break;

                case "Region":
                    str = "SELECT DISTINCT [Region] AS dText FROM RegisterStudent";
                    break;
                }


                TV.Nodes.Clear();
                cmSQL.CommandText = str;
                cmSQL.CommandType = CommandType.Text;
                cnSQL.Open();
                drSQL = cmSQL.ExecuteReader();

                TV.BeginUpdate();
                TV.Nodes.Add("ALL", "ALL").ForeColor = Color.Red;
                while (drSQL.Read())
                {
                    if (Convert.IsDBNull(drSQL[0]) == false)
                    {
                        TV.Nodes.Add(drSQL[0].ToString(), drSQL[0].ToString());
                    }
                    TV.EndUpdate();
                }

                //cmSQL.Connection.Close()
                cmSQL.Dispose();
                drSQL.Close();
                cnSQL.Close();
                cnSQL.Dispose();

                return;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, MyModules.strApptitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }
        private void LoadTV(string dChoice)
        {
            try
            {
                string        str   = "";
                SqlConnection cnSQL = new SqlConnection(MyModules.strConnect);
                SqlCommand    cmSQL = new SqlCommand();
                cmSQL.Connection = cnSQL;
                SqlDataReader drSQL;

                string theCond = "";
                if (Source1 == "STAFF")
                {
                    theCond = " WHERE Source='STAFF'";
                }
                else
                {
                    theCond = " WHERE Source='VENDOR'";
                }
                switch (dChoice)
                {
                case "Bank":
                    str = "SELECT DISTINCT [BankName] AS dText FROM RegisterVendor" + theCond;
                    break;

                case "Category":
                    str = "SELECT DISTINCT [Category] AS dText FROM RegisterVendor" + theCond;
                    break;

                case "Region":
                    str = "SELECT DISTINCT [Region] AS dText FROM RegisterVendor" + theCond;
                    break;
                }


                TV.Nodes.Clear();
                cmSQL.CommandText = str;
                cmSQL.CommandType = CommandType.Text;
                cnSQL.Open();
                drSQL = cmSQL.ExecuteReader();

                TV.BeginUpdate();
                TV.Nodes.Add("ALL", "ALL").ForeColor = Color.Red;
                while (drSQL.Read())
                {
                    if (Convert.IsDBNull(drSQL[0]) == false)
                    {
                        TV.Nodes.Add(drSQL[0].ToString(), drSQL[0].ToString());
                    }
                    TV.EndUpdate();
                }

                //cmSQL.Connection.Close()
                cmSQL.Dispose();
                drSQL.Close();
                cnSQL.Close();
                cnSQL.Dispose();

                return;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, MyModules.strApptitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }