C#

private DataTable GenDT(string strSelect)
{
    if (con.State != ConnectionState.Open)
        con.Open();


    DataTable _dt = new DataTable();
    try
    {
        new OracleDataAdapter(strSelect, con).Fill(_dt);
    }
    catch (Exception) { }
    return _dt;
}

private void pop_tree()
{
    DataTable dt = GenDT("SELECT ID,PARENT,NAME FROM TT ORDER BY ID");

    bool firstIteration = true;
    Node baseLine = null;
    foreach (DataRow row in dt.Rows)
    {
        if (firstIteration)
        {
            baseLine = new Node(int.Parse(row["Id"].ToString()),
                row["Name"].ToString());
            firstIteration = false;
        }
        else
        {
            int parentId = int.Parse(row["Parent"].ToString());
            Node parent = (baseLine.Id == parentId) ? baseLine : baseLine.FindNode(parentId);
            parent.AddChild(new Node(int.Parse(row["Id"].ToString()),
                    row["Name"].ToString()));
        }
        TreeNodeBuilder nodeBuilder = new TreeNodeBuilder(baseLine); // baseline will be root node
        treeView1.Nodes.Add(nodeBuilder.BuildTreeNode());
    }
}

private void Form1_Load(object sender, EventArgs e)
{
    pop_tree();
}

ID    Parent    Name
------------------------
0     0         BaseLine
1     0         A
2     1         A1
3     1         A2
4     0         B
5     4         B1
6     4         B2
7     2         A1.1
8     2         A1.2

parent.AddChild(new Node(int.Parse(row["Id"].ToString()),
        row["Name"].ToString()));

public Node FindNode(int id)
{
    Node result = childNodes.SingleOrDefault(node => node.Id == id);
    if (result == null)
    {
        foreach (Node node in childNodes)
        {
            result = node.FindNode(id);
            if (result != null)
                break;
        }
    }
    return result;
}

private void pop_GTree()
{
    DataTable dt = GenDT("SELECT ID,PARENT,NAME FROM TT ORDER BY ID");

    bool firstIteration = true;
    Node baseLine = null;

    foreach (DataRow row in dt.Rows)
    {
        if (firstIteration)
        {
            baseLine = new Node(int.Parse(row["ID"].ToString()), row["NAME"].ToString());
            treeView1.Nodes.Add(row["ID"].ToString(), row["NAME"].ToString());
            firstIteration = false;
        }
        else
        {
            int parentId = int.Parse(row["PARENT"].ToString());
            Node parent = (baseLine.Id == parentId) ? baseLine : baseLine.FindNode(parentId);

            parent.AddChild(new Node(int.Parse(row["ID"].ToString()),
                    row["NAME"].ToString()));
            treeGridView1.Nodes.Add(parent);

            treeView1.Nodes[baseLine.Id].Nodes.Add(row["ID"].ToString(),
                    row["NAME"].ToString());
        }
    }
    //TreeNodeBuilder nodeBuilder = new TreeNodeBuilder(baseLine); // baseline will be root node
    //treeGridView1.Nodes.Add(nodeBuilder.BuildTreeNode());
}

Muammar© wrote:

treeView1.Nodes.Add

private void pop_GTree()
{
    DataTable dt = GenDT("SELECT ID,PARENT,NAME FROM TT ORDER BY ID");

    bool firstIteration = true;
    Node baseLine = null;

    foreach (DataRow row in dt.Rows)
    {
        if (firstIteration)
        {
            baseLine = new Node(int.Parse(row["ID"].ToString()), row["NAME"].ToString());
            treeView1.Nodes.Add(row["ID"].ToString(), row["NAME"].ToString());
            firstIteration = false;
        }
        else
        {
            int parentId = int.Parse(row["PARENT"].ToString());
            Node parent = (baseLine.Id == parentId) ? baseLine : baseLine.FindNode(parentId);

                parent.AddChild(new Node(int.Parse(row["ID"].ToString()), row["NAME"].ToString()));

                treeView1.Nodes[baseLine.FindNode(parent.Id).Id].Nodes.Add(row["ID"].ToString(), row["NAME"].ToString());

        }
    }
    TreeNodeBuilder nodeBuilder = new TreeNodeBuilder(baseLine); // baseline will be root node

}

//Loop again
foreach (DataRow row in dt.Rows)
{
    int parentId = int.Parse(row["PARENT"].ToString());
    treeView1.Nodes[baseLine.FindNode(parentId).Id].Nodes.Add(row["ID"].ToString(), row["NAME"].ToString());
}

private DataTable GenDT(string strSelect)
{
    if (con.State != ConnectionState.Open)
        con.Open();


    DataTable _dt = new DataTable();
    try
    {
        new OracleDataAdapter(strSelect, con).Fill(_dt);
    }
    catch (Exception) { }
    return _dt;
}

private void LoadChilds(string _Parent, TreeNode _Node)
{
    DataTable dt = GenDT("SELECT ID,PARENT,NAME FROM TT WHERE PARENT ="+_Parent+" ORDER BY ID");

    for (int x = 0; x < dt.Rows.Count;x++ )
    {
        _Node.Nodes.Add(dt.Rows[x]["ID"].ToString(), dt.Rows[x]["NAME"].ToString());
        LoadChilds(dt.Rows[x]["ID"].ToString(), _Node.Nodes[x]);
    }
}

private void pop_GTree()
{
    DataTable dt;
    //Loading root nodes
    dt = GenDT("SELECT ID,PARENT,NAME FROM TT WHERE PARENT = 0 ORDER BY ID");
    foreach (DataRow row in dt.Rows)
        treeView1.Nodes.Add(row["ID"].ToString(), row["NAME"].ToString());

    foreach(TreeNode tn in treeView1.Nodes)
    LoadChilds(tn.Name, tn);
}

Muammar© wrote:

and what about the co-article thing??

N a v a n e e t h wrote:

DataTable has a Select() method

N a v a n e e t h wrote:

I am traveling to US

steve_rm wrote:

But the ProgressChanged event doesn't show progress until after the data has been downloaded.

Documentation says[^]:

If the server does not send the size of the downloaded file (such as in the case of a passive FTP connection), ProgressPercentage may always be zero.

I are Troll

static void UpdateAvailable()
{
    WebClient wbCheckUpdates = new WebClient();
    wbCheckUpdates.DownloadProgressChanged += new DownloadProgressChangedEventHandler(wbCheckUpdates_DownloadProgressChanged);
    wbCheckUpdates.DownloadDataCompleted += new DownloadDataCompletedEventHandler(wbCheckUpdates_DownloadDataCompleted);
    string webServerURL =
        @"http://download.wikimedia.org/simplewiktionary/20090801/simplewiktionary-20090801-pages-articles.xml.bz2";

    wbCheckUpdates.DownloadDataAsync(new Uri(webServerURL));
}

static void wbCheckUpdates_DownloadProgressChanged(object sender, DownloadProgressChangedEventArgs e)
{
    Console.WriteLine("Download progres: " + e.ProgressPercentage);
}

static void wbCheckUpdates_DownloadDataCompleted(object sender, DownloadDataCompletedEventArgs e)
{
    // byte[] result = e.Result;
    Console.WriteLine("Completed");
}

static void Main(string[] args)
{
    UpdateAvailable();
    Console.ReadKey();
}

Steve1_rm wrote:

The DownloadDataAysnc does show progress.

private void DownloadDataCallback (Object sender, DownloadDataCompletedEventArgs e)
{
   // If the request was not canceled and did not throw
   // an exception, get the result.
   if (e.Error == null && !e.Cancelled)
   {
     byte[] data = e.Result;
   } 
   else
   {
     //error or cancelled
   }
}