c# - How to create a HyperLink field out of SQL query

Question

In reference to this question of mine,

GridView Table 1 related to Table 2

I got a gridview which looks like this at the moment,

Here is the SQL fiddle

Question:

How Can I create a HyperLinkField with FruitTitle and link to fruit website ?

This is the code I am using for displaying Types_of_Fruits_in_Crate at the moment and works perfectly,

            BoundField theField = new BoundField();
            theField.DataField = "Types_of_Fruits_in_Crate";
            gv.Columns.Add(theField);

what to put in

            HyperLinkField theField = new HyperLinkField();
            theField.DataTextField = 'Types_of_Fruits_in_Crate';
            theField.DataNavigateUrlFields = // not sure ....

Answer 1

Try like below, it will help you...

SQL FIDDLE : http://www.sqlfiddle.com/#!3/96a49/18

SQL :

SELECT CrateTitle,CrateDescription,CrateID,
stuff(
(
    SELECT ',<a href=''' + [FruitWebsite] + ''' target=''_blank''>'+ [FruitTitle] +'</a>' FROM fruits WHERE CrateID = t.CrateID FOR XML path('')
),1,1,' ') Types_of_Fruits_in_Crate
FROM (SELECT DISTINCT CrateTitle,CrateDescription,CrateID FROM fruits )t

Also, Add HTML ENCODE = FALSE in your Code then only the HTML functionality reflect in your Grid View

C# :

    BoundField theField = new BoundField();
    theField.DataField = "Types_of_Fruits_in_Crate";
    theField.HtmlEncode = false;
    gv.Columns.Add(theField);