Retrieve Uploaded file from web directory

fullyii

Member
Joined
Aug 19, 2005
Messages
22
Location
Chicago
Programming Experience
1-3
I successfully created a webpage that inserts a file path into my SQL server database and stores the file in a web folder named "Data". I have the directory path stored in my database table. Now I need to know how to retrieve that file from a data grid.

I currently have a datagrid that lists all the rows in the database.

faqID
Title
Description
faqAttach - This filed is a hyperlink column

When I run the application and select the hyperlink the URL path shows the entire path ending with the ID. As follows

http://172.17.7.79/id=60

All I need to do is get the file name associated with the ID field which is stored in "faqAttach" the correct path would be something like

http://172.17.7.79/data/someexcelfile.xls?id=60



<asp:HyperLinkColumn Target="_blank" DataNavigateUrlField="faqID" DataNavigateUrlFormatString="id={0}"
DataTextField="faqAttach" HeaderText="Attachment"></asp:HyperLinkColumn>


I am not sure how to proceed from here. Other than the fact that I need to get the value stored in the database into the url string.

Any help or suggestions would be greatly appreciated. I am new to .net and still trying to understand so please be as detailed a spossible.

Thank You:)
 
Back
Top