Hi Trent,
I have the below sql which stores the menu options names. So this way I can populate into the web pages the options names etc... If you look at this web site:
http://www.Intelius.com you will see People Search as the main option and then when you click that you will see all tabs. The name of the tabs are coming from the dbo.SearchCategories.SearchCategory and for the main Search option it is coming from the dbo.SearchOptions.SearchOption. It is generated as an XML file. Based on that XML the menu options and tabs are created on the fly. It is like a small Content Management. All Contents Management forms are created as smart clients app.
1)
How would you link that from the XML file into the Index.ASPX? I am trying to find the most productive way for this process.
2)
Do you handle your web site this way?
SELECT
dbo.ServiceOptions.ServiceOption,
dbo.ServiceOptions.DisplayOptionOrder,
dbo.SearchOptions.SearchOption ,
dbo.SearchOptions.DisplayOptionOrder,
dbo.SearchCategories.SearchCategory,
dbo.SearchCategories.DisplayOptionOrder,
dbo.SearchCategories.SearchCategories_PK,
dbo.SearchCategories.Comment,
dbo.SearchCategories.Tip
FROM
dbo.ServiceOptions
INNER JOIN dbo.SearchOptions
ON dbo.ServiceOptions.ServiceOptions_PK=dbo.SearchOptions.ServiceOptions_FK
INNER JOIN dbo.SearchCategories
ON dbo.SearchOptions.SearchOptions_PK = dbo.SearchCategories.SearchOptions_FK
WHERE dbo.ServiceOptions.DisableOption = 0 AND dbo.SearchOptions.DisableOption = 0 AND dbo.SearchCategories.DisableOption = 0
ORDER BY dbo.ServiceOptions.DisplayOptionOrder,dbo.SearchOptions.DisplayOptionOrder,dbo.SearchCategories.DisplayOptionOrder
FOR XML AUTO , ROOT('Menu_Options')
Thanks,
Doron