Форум программистов [Powered by Invision Power Board]

Код

protected void LoadGNTTreeRekursija(int lvl, string SubID)
    {
        //try
        {
            
            string SQLString = @"...";

            if (lvl == 1)
            {
                SQLString = @"....";
                ListBoxGNTTree.Items.Clear();
                ListBoxGNTTree.Items.Add("root");
                conn.Open();
            }

            string Name = "";
            string Level = "";
            for (int z = 0; z < lvl; z++) Level += "-";

            SqlCommand myCommand = new SqlCommand(SQLString, conn);
            SqlDataReader myReader = myCommand.ExecuteReader();
            while (myReader.Read())
            {
                 string Name = ....;

                ListBoxGNTTree.Items.Add(Level + "> " + Name);
                ListBoxGNTTree.Items[ListBoxGNTTree.Items.Count - 1].Value = myReader["IDT"].ToString;

                LoadGNTTreeRekursija(lvl + 1, myReader["IDT"].ToString());
            }
            myReader.Close();
            if (lvl == 1)  conn.Close();
        }
        //catch { }
    }