title: How to create a HyperLink field out of SQL query
body: <p>In reference to this question of mine,</p>
  
  <p><a href="https://stackoverflow.com/questions/16217674/gridview-table-1-related-to-table-2/16218281?noredirect=1#comment23195878_16218281">GridView Table 1 related to Table 2</a></p>
  
  <p>I got a gridview which looks like this at the moment,</p>
  
  <p><img src="https://i.stack.imgur.com/Fn1vi.png" alt="enter image description here"></p>
  
  <p>Here is the SQL <a href="http://www.sqlfiddle.com/#!3/96a49/3" rel="nofollow noreferrer">fiddle</a></p>
  
  <p><strong>Question:</strong></p>
  
  <p>How Can I create a HyperLinkField with FruitTitle and link to fruit website ?</p>
  
  <p>This is the code I am using for displaying <code>Types_of_Fruits_in_Crate</code> at the moment and works perfectly,</p>
  
  <pre><code>            BoundField theField = new BoundField();
              theField.DataField = "Types_of_Fruits_in_Crate";
              gv.Columns.Add(theField);
  </code></pre>
  
  <p>what to put in </p>
  
  <pre><code>            HyperLinkField theField = new HyperLinkField();
              theField.DataTextField = 'Types_of_Fruits_in_Crate';
              theField.DataNavigateUrlFields = // not sure ....
  </code></pre>