Hyperlink in gridview

I know Ican create a hyperlink in a gridview but how do I do this for a link that is stored within a database?

I figured out you can set a hyperlink field to be a field in a table, but mine is a relative link, how do I make it go back to the root, the usual ~/ doesnt seem to work

The ~/ should work. Can you show how you are setting this link? Is ~/ stored in the db, or do you add it somewhere in code?

cheers mendhak, i added this to the database and it working now.

Thanks Dave