Please bare with me and my noobness.
Platform: Visual Web Developer 2008 Express
Page type: aspx (not using code behind)

I am building a site that displays data from a mssql datasource. As the user drills down to the detail levels they have the option to click a link to view an xml based report.

I am able to staticly point the xml control to an xml file, but what I really need to do is use a path supplied by the sql database and add the virtual directory to create the complete link.

I know how to pass the querystring data once the user clicks the datagrid link on the previous page. Is there a way to utilize this to build the path I need to display the correct xml?

I have been looking for a fix for over a week. It seems that I should be able to use the passed data in the XML control's DocumentSource= area.

This works right now. It is a static DocumentSource path.

<asp:Xml ID="Xml1" runat="server"
DocumentSource="xmldata/admin.net/11.0.0/PostionsTabFilterTest/372008131541721610155/Utility_OpenAdmin.0/Report/results.xml"
TransformSource="~/PDetails.xsl"></asp:Xml>

^^portion of the link in bold can be passed from the previous page.

What do I put in DocumentSource= to make it use the "ResultsLink" field from the prior page?

update:

I can now pass the entire xml file path as a string from the previous page. I just need to get the ASP:XML DocumentSource= to use the string. But, the control doesn't accept <% %> fields.

Can I build this programicly?

found the fix. i knew it was easy. special thanks to sachin_07 on asp.net forum.

http://forums.asp.net/p/1193939/2057996.aspx#2057996


===========

My code looks like this...

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Me.Xml1.DocumentSource = Server.MapPath(Request.Item("link"))
    End Sub