Solved

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

Posted on 2006-11-08
7
1,170 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.



0
Comment
Question by:MMadrigal
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 3

Expert Comment

by:rugu_16
ID: 17899281
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.
0
 

Author Comment

by:MMadrigal
ID: 17899479
Not really tree view like outlook but more sitenav look.
0
 
LVL 15

Expert Comment

by:Ralf Klatt
ID: 17900416
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
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:MMadrigal
ID: 17900949
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.
0
 
LVL 3

Expert Comment

by:rugu_16
ID: 17901070
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>
0
 
LVL 15

Accepted Solution

by:
Ralf Klatt earned 500 total points
ID: 17901110
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
0
 

Author Comment

by:MMadrigal
ID: 17906559
Thanks Guys.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question