opening a file in a gridview using hyperlink and\or button

Question

Hi,

I want to show the contents of a database table.So I am using "Select * from tablename"
The data from the database gets populated into a gridview which I display in the form.

The database data contains file names in one column and file paths in another.Now I am only showing
the filenames in the gridview not the file paths.

but I want the filenames to be a hyperlink which when clicked will open the file.
Alternatively I could have a button at the end of gridview row on clicking which the file opens.

How can  I achieve  one or both  of the things mentioned above.

Any help will be greatly appreciated.