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
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