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:
  1. SELECT  DocID

  2.         , DocumentName

  3.         , DocumentPath+DocumentName AS FilePath 

  4. 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:
  1. <Columns>

  2.     <asp:HyperLinkField 

  3.                DataNavigateUrlFields="FilePath" 

  4.                 DataNavigateUrlFormatString="DocID={0}" 

  5.                 Text="Open" 

  6.                 HeaderText="Document" />

  7. </Columns>
What am I doing wrong?