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.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 format Xml output

Author  Topic 

chou73
Starting Member

1 Post

Posted - 2010-11-01 : 05:24:49
Hi all,

I need help,

I have un xml file like this:

<?xml version="1.0" encoding="utf-8" ?>
<rootMenu>
<topMenu text="Button1">
<menuItem href="template.aspx" text="B1I1" />
<menuItem href="template.aspx" text="B1I2" />
<menuItem text="B1I3">
<menuItem href="template.aspx" text="B1I3I1" />
<menuItem href="template.aspx" text="B1I3I2" />
</menuItem>
</topMenu>
<topMenu text="Button2">
<menuItem href="template.aspx" text="B2I1" />
<menuItem href="template.aspx" text="B2I2" />
<menuItem href="template.aspx" text="B2I3" />
<menuItem text="B2I4">
<menuItem text="B2I4I1">
<menuItem href="template.aspx" text="B2I4I1I1I1" />
</menuItem>
</menuItem>
</topMenu>
</rootMenu>

It's a multilevel menu, i want to get it from my database. i don't know How?

If i need one table or many?

Please help

Thanks

sql-programmers
Posting Yak Master

190 Posts

Posted - 2010-12-06 : 22:37:28
You may get better insight through the link,

http://www.sql-programmers.com/Blog/tabid/153/EntryId/10/XML-Data-Type-in-SQL-Server-2005.aspx

SQL Server Programmers and Consultants
http://www.sql-programmers.com/
Go to Top of Page
   

- Advertisement -