I have a search button that displays results into a gridview from the database.
In my database I have a "Link" colum that has different links to other pages in my project.
For example onetime.aspx, template.aspx etc.

What I want to do is:
When the user searches and the results come up, I want the "Link" colum to become an
actul link that takes the user to that different aspx page.

How do I achieve this? At the moment it is directing me to one page and it is because
I have set it like this..
Here is my code:
<asp:HyperLinkField HeaderText="Link" SortExpression="RestaurantName" DataTextField="RestaurantName"
NavigateUrl="Template.html" />