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.

Can anybody tell me a collection which takes objects and doesn't sort it. 

The code is as follows. can anybody convert this?

 plz dont give me the online code converter

Thanks in Advance, Naveen

Hi,

Try to use System.Collections.ArrayList or System.Collections.Generic.List<TreeNode>.

Hi Guys, 

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#.

Regards,

Naveen

Reflector (http://www.aisto.com/roeder/dotnet/)

would be the first thing I would try if I've got working code that I need to convert.

1. Compile into DLL.

2. Open DLL in Reflector.

3. Select the language you want.

4. Copy the code into VS

5. Compile the code in the new language.

HTH,

Jonathan.
 

 TreeNodeCollection tnc = new TreeNodeCollection();

jonathanparker:

Reflector (http://www.aisto.com/roeder/dotnet/)

 Cosign! Reflector is great for this kind of stuff

Hi guys,

Thanks for all your response.

For EveryBody who Suggested TreeNodeCollection and ArrayList.

What is needed is a collection which

1. Stores Data as object (or TreeNode)

2. Stores Data as Key Value Pair

3.Doesn't Automatically Sort with Key

Thanks in Advance
Naveen

naveenj:

The Code has been implemented in VB.
I would like to have the Conversion in C#.

So the VB code works? If so then your only problem is

converting the code to C#. This should be very easy with Reflector (see above).

 
If on the other hand you don't have all the VB code then you'll need to find or write a tree

implementation in C# or VB as there isn't one in the .NET framework.

HTH,

Jonathan.
 

Hi Naveen,

             Try TreeNodeCollection.

 Regards,

Sirisha Peddinti.

Naveen Try this

this.tvEmployees.Nodes.Clear();
Employees employees = new Employees();
using (SqlConnection connection = new SqlConnection(@"Server=.\SQLEXPRESS; User Id=sa;Password=assyst@123;Database=work"))
{
    connection.Open();
    using (SqlCommand command = new SqlCommand("usp_GetEmployees", connection))
    {
        command.CommandType = System.Data.CommandType.StoredProcedure;
        SqlDataReader reader = command.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
        while (reader.Read())
        {
            employees.Add(new Employees.Employee()
            {
                Depth = int.Parse(reader["depth"].ToString()),
                EmployeeId = int.Parse(reader["EmployeeId"].ToString()),
                Parent = int.Parse(reader["Parent"].ToString()),
                EmployeeName = reader["EmployeeName"].ToString(),
            });
        }
    }
}

foreach (Employees.Employee employee in employees)
{
    Employees.Employee parentEmp = employees.Find(o => o.EmployeeId == employee.Parent);
    if (parentEmp != null)
    {
        this.tvEmployees.Nodes.Find(parentEmp.EmployeeId.ToString(), true)[0].Nodes.Add(employee.EmployeeId.ToString(), employee.EmployeeName);
    }
    else
    {
        this.tvEmployees.Nodes.Add(employee.EmployeeId.ToString(),employee.EmployeeName);
    }
}
this.tvEmployees.ExpandAll();

 

And the Employee class

public class Employees : List<Employees.Employee>
{
    public class Employee
    {
        public int EmployeeId
        {
            get;
            set;
        }
        public string EmployeeName
        {
            get;
            set;
        }
        public int Parent
        {
            get;
            set;
        }
        public int Depth
        {
            get;
            set;
        }
    }
}

Hi Anuraj,

Thanks

Saw your blog post earlier: TreeView Population without recursive function