I have a website, written in ASP .Net & C#, and I am using a Substitution to display the contents of an Excel spreadsheet. The page consists of a DetailsView with paging enabled; I need to coordinate the file shown in the substitution with the record currently displayed in the DetailsView. I have the filename stored in the same table as the contents of the DetailsView, but what I can't figure out is how to get that filename and display it in the Substitution.

Currently, I have it written as

<asp:Substitution runat="server" ID="Substitution1" Visible="False" MethodName="<%Response.WriteFile("C:\\Domains\\nautikakennels.com\\wwwroot\\pedigrees\\SterlingPedigree.htm"); %>" />


I was thinking about writing a SCRIPT tag in the page, but I'm not sure how to do that either...I need to be able to pull the filename from the table, AND if the user uploads a new file, to add it in the database record with the appropriate primary key (to match what is currently displayed in the DetailsView).

Please HELP!

Thanks!