Organization Chart Logic/Component

[JP SIngh]

Hi All

We urgently needs some help please.

We need to create an org chart from our employee data but struglling. We are
using ASP with SQL Server 2000.

Does anyone know of a commercial component or some sample code to help us
get started? Ideally a component will be great as we need to turn this
around quite quickly and also the chart needs to be interactive so various
nodes can be hidden or expanded by the user.

Many of you have been in development and I am sure would have been asked to
present the employee or similar hierarchical data in tree structure.

Please help.

Employee Table Structure

EmployeeNumber INT (Primary Key)
FirstName
LastName
ManagerId

Many thanks

[Luke Zhang [MSFT]]

Hello,

As I know, there is not such a built-in component in ASP to display a Org
chart. You may consider embed ActiveX control in the page to display such a
chart. Or use Visio:

http://office.microsoft.com/en-us/he...588171033.aspx

And some third party activex control:

http://www.edrawsoft.com/

http://www.programurl.com/edraw-orga...onal-chart.htm

Sincerely,

Luke Zhang

Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

[Luke Zhang [MSFT]]

Hello,

Is there any further questions on this issue? If so , please feel free to
let us know.

Sincerely,

Luke Zhang

Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.