title: How to Enforce Gridview Line Breaks
body: <p>I am trying to use an sqldatasource object to populate a grid view but I wish to combined two of the rows in the database into one row with a line break in the grid view (for aesthetic appeal only). What I have done so far is concatenated the results of the database to look something like this:</p>
  
  <pre><code>SELECT Incidents.Title + '&lt;br /&gt;' + Products.Name AS "Title/Product",
  Technicians.Name + '&lt;br /&gt;' +  Incidents.Description AS "Tech name /&lt;br /&gt;Description",
  Incidents.DateOpened,
  Incidents.DateClosed
  FROM Incidents
  INNER JOIN Technicians ON Incidents.TechID = Technicians.TechID
  INNER JOIN Products ON Incidents.ProductCode = Products.ProductCode
  WHERE Incidents.CustomerID = @CustomerID
  </code></pre>
  
  <p>So as you can see I am inserting HTML linebreaks into the contatination and the column names but sadly this is shown as <code>"Title&lt;br /&gt;Product"</code> in the gridview. In short it does not actually perform the linebreak it just inserts the text.</p>
  
  <p>So my question is, is there anyway to enforce a linebreak, preferably one that is less complex then the method I am working with, if there isn't that's fine I'm just really stuck on exactly what I could do.</p>