Hi,
I am trying to convert a VB.net code to C#.
it is to bind a treeview from a collection.
but not finding a Collection which stores treenodes as object.
Cant use hashtable since it automatically sorts the data by key.

The code is as follows
can anybody convert this?


Private Sub TreeViewPopulation(ByVal ds As DataSet, Optional ByVal intParent As Integer = 0)
Dim TvwParent As New TreeNode
Dim TvwNode As New TreeNode
Dim CollItems As New Collection

tvw.Nodes.Clear()
For Each dr As DataRow In ds.Tables(0).Rows ''''assigning dataset values to a collection as node
TvwNode = New TreeNode(dr("Employee_Nm").ToString)
TvwNode.Tag = dr("Parent")
CollItems.Add(TvwNode, dr("Employee_Id"))
Next
For Each TvwNode In CollItems
TvwParent = Nothing
'find parent of a node
If Val(TvwNode.Tag) <> intParent Then TvwParent = CType(CollItems.Item(TvwNode.Tag.ToString), TreeNode)
If Not TvwParent Is Nothing Then
'add child node to its parent node
CType(CollItems.Item(TvwNode.Tag.ToString), TreeNode).Nodes.Add(TvwNode.Clone)
Else
tvw.Nodes.Add(TvwNode) 'add node to Treeview
End If
Next

End Sub

plz dont give me the online code converter:)
Thanks in Advance,
Naveen


�You can cut all the flowers but you cannot keep spring from coming.�

What about the TreeNodeCollection class which "Represents a collection of TreeNode objects"?

http://msdn2.microsoft.com/en-us/lib...ollection.aspx

-Peter

Hi,
Thanks for the Reply Peter.
But its not what is needed.
A TreeNodeCollection is just a collection of TreeNodes.
Whats needed is a Collection that stores object in a key value pair format which doesn't sort the objects by key.

An Elaboration on the program.

Here TreeView is being populated without recursive function using
a Single Recursive Query to get the child nodes of corresponding parents (and grandparents for that matter:)) since it is much faster.

The Query is as follows

CREATE PROCEDURE [dbo].[SP_RecursionEmp]
AS

BEGIN
WITH RecEmp AS(SELECT emp_id,emp_name,parent_id,0 as depth
FROM tbl_simple_employees
UNION ALL
SELECT E.emp_id,E.emp_name,E.parent_id,R.depth+1 AS depth FROM
tbl_simple_employees AS E INNER JOIN RecEmp AS R ON R.emp_id=E.parent_id )
SELECT max(emp_id)as emp_id,max(emp_name)as emp_name,max(parent_id)as parent_id,max(depth)as depth FROM RecEmp r group by emp_id order by depth
END

now i took the result in a DataSet and passed it to a
custom created function as follows

    private void TreeViewPopulation(DataSet ds)
    {
         .........
    }

what I need is a C# Code to implement it.
The Code has been implemented in VB.
I would like to have the Conversion in C#.

�You can cut all the flowers but you cannot keep spring from coming.�

Hi Naveen,

What about a generics Dictionary class? E.g.:

Dictionary<string, TreeNode> collItems = new Dictionary<string, TreeNode>();

This allows you to add TreeNode objects by key to the dictionary. You'll need to import the System.Collections.Generic namespace for this.

Alternatively, look at the other generic class in the BCL:

http://msdn2.microsoft.com/en-us/lib...s.generic.aspx
http://msdn2.microsoft.com/en-us/lib...jectmodel.aspx

and see if any of them are usable for you.

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Hi Imar,
This method sounds intriguing.
Sorry for replying late.
No work on weekend, thats why.
Regards
Naveen

You can cut all the flowers but you cannot keep spring from coming -Pablo Neruda