Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
LearnEveryDay
Starting Member
37 Posts |
 Posted - 2005-08-08 : 08:22:32
|
| Hi Guys,I am doing some work with parent and child as tree viewso I have a table which has got ParentID, Name, and ChildID. I have data as1 parentA 12 ParentB 23 childA 14 childC 2I want to view these data asparentA ChildAParentB ChildB ChildC ( ChildC is a child of ChildB)Can I have relationship in same table with ParentID and ChildID. Or do I need to have two tables. I will be grateful if someone explains me this .............Thanks,LearnEveryDay |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
LearnEveryDay
Starting Member
37 Posts |
Posted - 2005-08-08 : 11:10:38
|
| Thanks Madivanan,I understand the table structure now.....I am going to ask another question which is realated to this. That is .net handles these structure very well in the front end...But I dont know much about it. Is it good to use DataSet.Relation or DataView....I know it is off the sql-question. I appreciate if someone answer me.Thanks,Pauline |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-08-09 : 00:50:31
|
| It is better to post this question at .NET forumsMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Relationship in tables and table itself