CODEWITHSUNDEEP
c#databasetreeview
Josef
Josef

Reputation: 2720

Populating TreeView from database C#

I have two tables in database in relation 1:N and I want to populate treeview with data. The problem is how to add childs to each parent. This is my code:

 private void PopulateTreeView()
    {
        try
        {
        DataTable dtProjekti = objDB.dbGetTable("SELECT * FROM tblProjekti");
        DataTable dtAktivnosti = objDB.dbGetTable("SELECT * FROM tblprojektakt");
        DataSet ds = new DataSet();
        ds.Tables.Add(dtProjekti);
        ds.Tables.Add(dtAktivnosti);
        ds.Relations.Add("childrens", dtProjekti.Columns["OznakaProjekta"], dtAktivnosti.Columns["OznakaProjekta"]);

        if (ds.Tables[0].Rows.Count > 0)
        {
            treeView1.Nodes.Clear();

             foreach (DataRow masterRow in ds.Tables[0].Rows)
            {
                //TreeNode masterNode = new TreeNode((string)masterRow["ParentName"], Convert.ToString(masterRow["ParentId"]));
                TreeNode masterNode = new TreeNode(masterRow["OznakaProjekta"].ToString());
                treeView1.Nodes.Add(masterNode);

                foreach (DataRow childRow in masterRow.GetChildRows("Children"))
                {
                       // missing code for adding childs to each parent     
                }
            }
        }
    }
    catch (Exception ex)
    {
        throw new Exception("Unable to populate treeview" + ex.Message);
    }

    }

    }

The childs are values from field Description.

I know how to manually add child to each parent but i stucked whan it should be dynamically.

Upvotes: 0

Views: 334

Answers (1)

Yurii
Yurii

Reputation: 4911

The childs are values from field Description.

If you mean column Description. It should be something like this: 

foreach (DataRow childRow in masterRow.GetChildRows("Children"))
{
    masterNode.Nodes.Add(new TreeNode(childRow["Description"].ToString()));
}

Upvotes: 1

Related Questions