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 |
|
Newbie2005
Starting Member
29 Posts |
 Posted - 2005-12-06 : 19:02:39
|
| Hi,I am not an expert with SQL2000 and need to create table(s) to match this xml format(if possible):<?xml version="1.0" encoding="UTF-8" ?><MenuData xmlns="http://tempuri.org/MenuDataDataSet.xsd"><Menu Id="RootMenu"><Item1 Caption="About TTF FIS" Url="" Target="" Id="AboutItem"><ChildMenu1 Id="AboutMenu"><ChildItem Caption="FAQs" Url="Faqs.aspx" Target="_self" Id="FaqsItem" /></ChildMenu1></Item1><Item2 Caption="Resource Solutions" Url="" Target="" Id="BizSolItem"><ChildMenu2 Id="ResourceMenu"><ChildItemMenu2 Caption="Resource Tracking" Url="" Target="" Id="AccItem"><ChildMenuChild2 Id="AccMenu"><ChildItemChild2 Caption="Resource_A" Url="Resource_A.aspx" Target="_self" Id="AItem" /><ChildItemChild2 Caption="Resource_B" Url="Resource_B.aspx" Target="_self" Id="BItem" /><ChildItemChild2 Caption="Resource_C" Url="Resource_C.aspx" Target="_self" Id="CItem" /><ChildItemChild2 Caption="Resource_D" Url="Resource_D.aspx" Target="_self" Id="DItem" /></ChildMenuChild2></ChildItemMenu2><ChildItemMenu2 Caption="Engineering" Url="Engineering.aspx" Target="_self" Id="EngItem" /><ChildItemMenu2 Caption="Design" Url="Design.aspx" Target="_self" Id="MarItem" /><ChildItemMenu2 Caption="Deployment" Url="Fire.aspx" Target="_self" Id="FireItem" /></ChildMenu2></Item2><Item3 Caption="MES Solutions" Url="" Target="" Id="PerSolItem"><ChildMenu3 Id="PerSolMenu"><ChildItemMenu3 Caption="MES First Solution" Url="Education.aspx" Target="_self" Id="EduItem" /><ChildItemMenu3 Caption="MES Second Solution" Url="Household.aspx" Target="_self" Id="HousItem" /><ChildItemMenu3 Caption="MES Third Solution" Url="PersonalAccidents.aspx" Target="_self" Id="PerAcItem" /><ChildItemMenu3 Caption="MES Fourth Solution" Url="Protection.aspx" Target="_self" Id="ProtItem" /><ChildItemMenu3 Caption="MES Fifth Solution" Url="Retirement.aspx" Target="_self" Id="RetItem" /><ChildItemMenu3 Caption="MES Sixth Solution" Url="Small Commercial Business.aspx" Target="_self"Id="SmallBizItem" /><ChildItemMenu3 Caption="MES Seventh Solution" Url="Term Life.aspx" Target="_self" Id="TermItem" /><ChildItemMenu3 Caption="Others" Url="Yachts.aspx" Target="_self" Id="YacItem" /></ChildMenu3></Item3><Item4 Caption="Our Company" Target="" Url="" Id="ComItem"><ChildMenu4 Id="ComMenu"><ChildItemMenu4 Caption="Identity" Url="Identity.aspx" Target="_self" Id="IdItem" /><ChildItemMenu4 Caption="Promise" Url="Promise.aspx" Target="_self" Id="PromItem" /></ChildMenu4></Item4></Menu></MenuData>any help appriciated |
|
|
Newbie2005
Starting Member
29 Posts |
Posted - 2005-12-06 : 19:03:23
|
| or any table(s) design help to use for nested menu |
 |
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2005-12-07 : 04:08:03
|
quote:
I am not an expert with SQL2000 and need to create table(s) to match this xml format(if possible)
You have elements in this xml document called:MenuItem1ChildMenu1ChildItemItem2ChildMenu2ChildItemMenu2ChildMenuChild2Item3ChildMenu3ChildItemMenu3Item4ChildMenu4ChildItemMenu4 Why?!  |
|
|
|
|
|
|
need to create table(s) to match this xml