Sort Order for SQL Site Map

Hello,

Has anyone figured out a way to change the sort order of the
SiteMap
stored in SQL Server?

Currently it sorts by the ID but if say Home is 20 and About
Us is 5,
About us display first. I tried adding sort order to the
table and the
query works corretly but the Provider chokes on an invalid
key because
the parents get switched around.


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "DotNetDevelopment, VB.NET, C# .NET,
ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting"
group.
To post to this group, send email to DotNetDevelopmentgooglegroups.com
To unsubscribe from this group, send email to
DotNetDevelopment-unsubscribegooglegroups.com
For more options, visit this group at http
://groups.google.com/group/DotNetDevelopment
-~----------~----~----~----~------~----~------~--~---