Multiple Child Nodes with For XML Path

I'm trying to build a sqlsitemapprovider. I gets the error "Multiple nodes with the same URL" I can't figure out what I'm doing wrong, I hoipe anyone can help me. There is no duplicate url in the db.

public override SiteMapNode BuildSiteMap()
    {
        lock (this)
        {
            // Don't rebuild the map unless needed.
            // If your site map changes often, consider using caching.
            if (rootNode == null)
            {
                // Start with a clean slate.
                Clear();
            }
            // Get all the data (using provider-agnostic code).
            DbProviderFactory provider = DbProviderFactories.GetFactory(providerName);
            // Use this factory to create a connection.
            DbConnection con = provider.CreateConnection();
            con.ConnectionString = connectionString;
            // Create the command.
            DbCommand cmd = provider.CreateCommand();
            cmd.CommandText = storedProcedure;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Connection = con;
            // Create the DataAdapter.
            DbDataAdapter adapter = provider.CreateDataAdapter();
            adapter.SelectCommand = cmd;
            // Get the results in a DataS

I have a treeview control that is working great, except that I would like the behavior of some nodes to display the + even though no child nodes exist yet. Meaning, I want my treeview control to look like this:

- RootNode
    + Node1
    + Node2
    + Node3

However, Nodes 1, 2, and 3 do not have any child nodes. From what I can see the + or - does not display if there are no child nodes, but I would like to see the + appear even though there are no child nodes. I want to do this because I want to create the child nodes upon expanding the parent node (Node1 for example).

Is this possible?

Thanks...

Not and xml expert, so please be kind to me.  I'm trying to consume a google base fomatted feed (for these purposes just bulding a long string).  I'm having a problem with stuff on my main/first node level with the same name e.g. "g:feature".  Any xml I've dealt with before would have these as child nodes to, say, "g:features" and I would just loop through them as such.  Can anyone help?

Dim doc As New XmlDocument()

        ' Load data  
        doc.Load("http://localhost/various/Xml/google.xml")

        ' Get nodes with XPath  
        nodeList = doc.SelectNodes("/rss/channel/item")

        
            'loop through XML nodes and display them
            For Each node As XmlNode In nodeList

                texter += node.Item("title").InnerXml.ToString
                texter += "<br />"
                texter += node.Item("g:feature").InnerXml.ToString
                texter += "<br />"
            Next

Hello
I have an application where the users can define up to 5 extra fields for a particular table (e.g. tblMaster). The custom data is all held in one table (e.g. tblCustom) so there could be up to 5 records in tblCustom for each tblMaster record. In my application I build a select statement based on the number of custom fields so that I can get a single row of data for each tblMaster record (sample below). I am now adding new features to the application and I want to expose an SQL View to the users for a report writer that will achieve the same result but still cater for the variable number of custom fields. I realise this needs to use probably a RIGHT OUTER JOIN so that NULL is returned if there is no matching field but I can't work it out. If I had five separate files it would be easy as each one would be a RIGHT OUTER JOIN for each. I could build 6 views (e.g. with no custom fields, with one custom field, with two custom fields etc) but that is not very efficient. I don't particulaly want to restructure the database as there would be a lot of work and retesting.
Any help would be very welcome!

SELECT tblProcess.ProcessNumber, tblProcess.Process, tblProcess.Risk, tblProcess.MRR, tblProcess.Version, tblProcess.LastChange, tblProcess.SecurityLevel, 
  tblPr