• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 260
  • Last Modified:

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!


0
Zaurb
Asked:
Zaurb
  • 5
  • 4
1 Solution
 
twoboatsCommented:
If you are using a grid view, you can change the column properties to be a hyperlink
0
 
ZaurbAuthor Commented:
Hi! that's exactly what am looking for. How can I do that?
0
 
ZaurbAuthor Commented:
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!
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
twoboatsCommented:
On the Grid view tasks, you select edit columns, and hyperlink field is an option
0
 
ZaurbAuthor Commented:
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!
0
 
ZaurbAuthor Commented:
OK! I did it! Thanks!
0
 
twoboatsCommented:
Excellent.

BTW there are some excellent tutorial videos here

http://asp.net/learn/

0
 
ZaurbAuthor Commented:
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?
0
 
twoboatsCommented:
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.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now