Open Word Document File from link on Datagridview

I have a database that hold some files, which can be Word, Excel or PDF files. I use a Datagridview to show these files and now I want to put a link on my gridview so that when the user clicks on the Hyperlink(?) button the file will open. So far I am not having any luck wiring it all up.

My select query looks like this

VB Code:

SELECT  DocID
        , DocumentName
        , DocumentPath+DocumentName AS FilePath 
FROM Documents

This gives me results like this
DocID: 1
DocumentName: Scanning range.doc
FilePath: C:\Docs\Scanning range.doc

My datagridview is showing all the fields correctly and all I need to do is to add the Hyperlink field to do the download but no matter how I try it I am not able to get it to work.

VB Code:

<Columns>
    <asp:HyperLinkField 
               DataNavigateUrlFields="FilePath" 
                DataNavigateUrlFormatString="DocID={0}" 
                Text="Open" 
                HeaderText="Document" />
</Columns>

What am I doing wrong?

what is happening when you click the link?

Well I never make it to the link. The designer fails with this error Error Creating Control - dgvDocumentsDatabinding expressions are only supported on objects that have a DataBinding event. System.Web.UI.WebControls.HyperLinkField does not have a DataBinding event.

I have tried the link a couple of different ways and got variations on the error but they all say basically the same thing.

Ok I finally got past the error and the page opens now with this.

vb Code:

<asp:HyperLinkField 
        DataTextField="FilePath" 
        DataNavigateUrlFields="DocID" 
        DataNavigateUrlFormatString="{0}" />

When I hover over the link I am getting the DocID now. So I think I am on the right track but I just can't get it to work all the way.

I am close now

vb Code:

<asp:HyperLinkField
        HeaderText="Action" 
        DataTextField="DocID" 
        DataNavigateUrlFields="DocumentName" 
        DataNavigateUrlFormatString="{0}" />

This is looking for the file at the root level and I need to go one directory down to a sub directory. Can I use a Server Map Path with this?

A ha! DataNavigateUrlFormatString="/documents/{0}" />

if it is asp.net
directly u can use window.open(//Word file path)

Assuming the DOC files are on the server, in C:\docs\etc then the user won't be able to see it at all. You'll need to link them to a handler page which in turn does a Response.WriteFile() from the local server location so that the user gets the save/open/cancel dialog prompt.