Zaurb
asked on
Visual Web Developer - Hyperlink table rows to actual files basing on SQL data.
Hi!
I'm using a Visual Web Developer to create a website. I have SQL Server with the table, where one of the columns contains paths to various files on a network share. The table in SQL is like this:
ID
FileName
FileSize
FilePath
I need to build the following aspx page:
ID File Name Open
1 fileA Open
2 fileB Open
3 fileC Open
4 fileD Open
5 fileE Open
So far I have created a page where I can visualize the path to files (i.e. output the content of table) including the FilePath column. But how can I hyperlink the OPEN table column to files?
Please, help me to resolve this issue. Thank you!
I'm using a Visual Web Developer to create a website. I have SQL Server with the table, where one of the columns contains paths to various files on a network share. The table in SQL is like this:
ID
FileName
FileSize
FilePath
I need to build the following aspx page:
ID File Name Open
1 fileA Open
2 fileB Open
3 fileC Open
4 fileD Open
5 fileE Open
So far I have created a page where I can visualize the path to files (i.e. output the content of table) including the FilePath column. But how can I hyperlink the OPEN table column to files?
Please, help me to resolve this issue. Thank you!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, am using a grid view, however, I can't find where I can change the column properties to be a hyperlink. Can you, please, indicate where is this property? Thank you!
On the Grid view tasks, you select edit columns, and hyperlink field is an option
ASKER
I enter the Grid View tasks, select Edit Columns and under the options of the column which I want to be a hyperlink I can't see any possibility to convert it to a hyperlink field...
What I have and what I want to make is as follows:
I have a table in SQL database which contains file names and paths to them on a disk. I want my table in IE for example show file names in one column and the button OPEN in another column so that whenever a user clicks on this button, the file will be launched.
Can you explain in more details, please, how do I achieve this. Am not so experienced in Web Developer Studio and ASP. That's why am trying to use visual tools. Thanks!
What I have and what I want to make is as follows:
I have a table in SQL database which contains file names and paths to them on a disk. I want my table in IE for example show file names in one column and the button OPEN in another column so that whenever a user clicks on this button, the file will be launched.
Can you explain in more details, please, how do I achieve this. Am not so experienced in Web Developer Studio and ASP. That's why am trying to use visual tools. Thanks!
ASKER
OK! I did it! Thanks!
ASKER
One more question in this topic. How do I enable an option to let user choose whether to open or save the file. Now, when I click on the file, let's say PDF file, it opens automatically in internet explorer. How can I enable an option to let user choose whether SAVE file to disk or OPEN it?
I guess you'll need 2 columns - one for open, one for save. The save one would open the filesave dialogue.
Dunno how to do this - just starting myself.
Dunno how to do this - just starting myself.
ASKER