We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Help with a Database Driven SiteMap using C#.net 1.1

MMadrigal
MMadrigal asked
on
Medium Priority
1,196 Views
Last Modified: 2008-01-09
I need to build a sitemap using our database.  

It needs to look like this:

Systems <-Header This in the datase has an HeaderID
    yada  <-SubHeader has a Subheaderid in the database
    yada
    yada
Systems Support
    yada
    yada
    yada
Resources
    yada
    yada
    yada

This has to be done in C#.net 1.1  Yes I know I can do it using XML but unfortunately I HAVE to use the existing SQL Server 2K db.  Thanks guys.   This is a ascx  part of a web project.



Comment
Watch Question

Commented:
Not sure if i understand it correctly but you need to build sitemap using database right? so that is like a new aspx or ascx page.

You can try this.
Create  a new table in DB call is sitemap.
store ID | SiteLink

store your main or header link with normal text and store your sub header or internal links startinf with _
so it will be like

ID | SiteLink
=========
1  | Link 1
2  | Link 2
3  | _subLink1

etc


now you the site map page you can retrive all this information and bind it to tree view kind of a control. I belive asp.net 1.1 does not have tree view control so you will have to make one up.

That should not be that hard.  you can find some here http://www.asp.net/ControlGallery/default.aspx?Category=28&tabindex=6

Another approach would be retrive your data from SQL and convert that into XML format. Then bind it your control.

Author

Commented:
Not really tree view like outlook but more sitenav look.
Ralf KlattEmployee in Civil Service
CERTIFIED EXPERT

Commented:
Hi,

Unfortunately I'm occupied in projects and not able to provide a "quick-shot" on your request ... but I'd suggest moving this question to the http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/ area ... I'm convinced you'll get the desired answer there!


With best regards,
Raisor

Author

Commented:
No not really. But thanks for the suggestion.  I am looking for a ASP.NET solution or some guidance using C#.  I have the SQL laid out.

Commented:
Sitemaps are usually all the pages of u r application laid down in normal tabular format.
So if u dont want treeview contorl then you can simplly create a table and bind data to it.
I did not get what u said regarding outlook view.

i.e.

<table>
<tr>
   <td>
   <td>
<tr>
   <td>
   <td>
Employee in Civil Service
CERTIFIED EXPERT
Commented:
Hi,

Thanks for your feedback!

Having had a closer look at it ... this provided source code might lead you to some further thoughts: http://www.codeproject.com/useritems/DNNGoogleSiteMapProvider.asp

... you won't have to get in to "DotNetNuke" ... nor will you be obliged to use "Google-Sitemaps" ... only (and only!) the source code is relevant!


Best regards,
Raisor

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Thanks Guys.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.