C# Treeview child nodes

[arggg]

I am trying to add child nodes based on database query in which the users in the database are a part of the parent node. Here is my code.

private void GetUsersByGroup()
        {
            //Setup query
            MySqlCommand cmdDatabase = new MySqlCommand("SELECT group_name FROM prov_groups WHERE group_name!='--None--';", conDatabase);
 
            cmdDatabase.ExecuteNonQuery();
            MySqlDataReader myReader;
            // Get data from query and send to tree view
            myReader = cmdDatabase.ExecuteReader();
            while (myReader.Read())
            {
 
                treeUsers.Nodes.Add(myReader.GetString(0));
            }
            myReader.Close();
            int groupNodeCount = treeUsers.GetNodeCount();
            for (int i = 0; i <= groupNodeCount; i++)
            {
                cmdDatabase = "SELECT Name FROM tsms LEFT JOIN prov_groups ON (tsms.Group = prov_groups.gid AND prov_groups.name='"+treeUsers.Nodes[i].Text.ToString()+"');";
                cmdDatabase.ExecuteNonQuery();
                myReader = cmdDatabase.ExecuteReader();
                while (myReader.Read())
                {
                    // ADD CHILD NODES HERE
                }
                myReader.Close();
            }

I'm having trouble adding the child nodes to the parent nodes that are already in the treeview. Can someone lend a helping hand on this?

Thanks in advance.

[Plater]

Add them as a new treenode to the current treenode?

treeUsers.Nodes[i].Nodes.Add("Some Value or something")
 

[arggg]

Add them as a new treenode to the current treenode?

treeUsers.Nodes[i].Nodes.Add("Some Value or something")
 

AHHHH i was forgetting the .Nodes after Nodes[i]. Let me try that. Thanks for the reply