title: Add Column in Grid view according to SQL query
body: <p>I am using this query:</p>
  
  <pre><code>select EmployeeId, receptionist_name, date_of_sale,
    count(date_of_sale) 
  from FrontOffice 
  group By EmployeeId, receptionist_name, date_of_sale 
  order by date_of_sale
  </code></pre>
  
  <p>for filling the grid view. But I can bound the <code>EmployeeId</code>, <code>receptionist_name</code>, <code>date_of_sale</code>, so can you tell me how can I bound the 4th column in grid view and how to fill the grid view.</p>
  
  <p><strong>UPDATE:</strong> Here is the code I am using:</p>
  
  <pre><code>&lt;Columns&gt; 
      &lt;asp:BoundField HeaderText="Date" DataField="date_of_sale" /&gt; 
      &lt;asp:BoundField HeaderText="Employe Id" DataField="EmployeeId" /&gt; 
      &lt;asp:BoundField HeaderText="Receiptist Name" DataField="receptionist_name" /&gt; 
      &lt;asp:TemplateField HeaderText="No. of Prospectus Sale"&gt; 
      &lt;ItemTemplate&gt; 
          &lt;asp:Label ID="salecount" runat="server" 
            Text='&lt;%# Eval("SaleCount") %&gt;'&gt;&lt;/asp:Label&gt; 
      &lt;/ItemTemplate&gt; 
      &lt;/asp:TemplateField&gt; 
  &lt;/Columns&gt;
  </code></pre>