title: Displaying multiple data Fields in Bound field of grid view
body: <p>I have the following sql query that I want to display in a gridview, basically to fields joined.</p>
  
  <p>How can I do this?</p>
  
  <pre><code>SELECT 
  --RTRIM(C.CustomerFirstName) + ' ' + LTRIM(C.CustomerLastName) as CustomerFullName,
  C.CustomerCompany,
  C.CustomerPosition, 
  C.CustomerCountry, 
  C.CustomerProvince, 
  C.CustomerContact,
  CP.ActionDate, 
  CP.ProductCode,
  CP.CustomerEmail
       FROM tblCustomers C
      INNER JOIN 
      tblCustomerProducts CP ON 
  C.CustomerEmail = CP.CustomerEmail
       ORDER BY ActionDate DESC
  </code></pre>
  
  <p>this is the html for the grid view. Basically I want CustomerFirstName and CustomerLastName in one field</p>
  
  <pre><code>&lt;asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333" 
          GridLines="None" Width="231px" AutoGenerateColumns="False"&gt;
          &lt;RowStyle BackColor="#EFF3FB" /&gt;
          &lt;Columns&gt;
              **&lt;asp:BoundField DataField="CustomerFirstName" HeaderText="Name" /&gt;
              &lt;asp:BoundField DataField="CustomerLastName" HeaderText="Last Name" /&gt;**
              &lt;asp:BoundField DataField="CustomerCompany" HeaderText="Company/Organisation" /&gt;
              &lt;asp:BoundField DataField="CustomerPosition" HeaderText="Position" /&gt;
              &lt;asp:BoundField DataField="CustomerCountry" HeaderText="Country" /&gt;
              &lt;asp:BoundField DataField="CustomerProvince" HeaderText="Province" /&gt;
              &lt;asp:BoundField DataField="CustomerContact" HeaderText="Contact" /&gt;
              &lt;asp:BoundField DataField="CustomerEmail" HeaderText="Email Address" /&gt;
              &lt;asp:BoundField DataField="ActionDate" HeaderText="Action Date" /&gt;
              &lt;asp:BoundField DataField="ProductCode" HeaderText="Product code" /&gt;
          &lt;/Columns&gt;
          &lt;FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" /&gt;
          &lt;PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" /&gt;
          &lt;SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" /&gt;
          &lt;HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" /&gt;
          &lt;EditRowStyle BackColor="#2461BF" /&gt;
          &lt;AlternatingRowStyle BackColor="White" /&gt;
      &lt;/asp:GridView&gt;
  </code></pre>