title: Add the word TOTAL to last row of Gridview
body: <p>I have a dynamically created GridView and I used the sql code <code>WITH ROLLUP</code> to display the totals of the columns. But is it possible to display the word totals in the blank cell?</p>
  
  <p><a href="https://i.stack.imgur.com/hz9TB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hz9TB.png" alt="enter image description here"></a></p>
  
  <p>GridView:</p>
  
  <pre><code>&lt;asp:GridView runat="server" 
                                  id="gvResults" 
                                  CssClass="tblResults" 
                                  onrowcreated= "gvResults_RowCreated"
                                  AllowSorting="true" 
                                  OnSortCommand="gvResults_Sort" 
                                  DataKeyField="ID" 
                                  AutoGenerateColumns="true"
                                  Visible =" true"&gt;
                              &lt;HeaderStyle CssClass="tblResultsHeader" /&gt;
                              &lt;AlternatingRowStyle BackColor="#EEEEEE" /&gt;
  
                          &lt;/asp:GridView&gt;
  </code></pre>
  
  <p>SQL code to display GridView:</p>
  
  <pre><code>select
  
      c.Name,
      COUNT(distinct jn.ID) as Jobs,
      sum(case when (select count(jbs.status) from jobstat jbs where jbs.jobid=jn.id and jbs.Status=''DEL'')&gt;0 then 1 else 0 end) as EPOD,
       sum(case when (select count(jbs.status) from jobstat jbs where jbs.jobid=jn.id and jbs.Status=''POD'')&gt;0 then 1 else 0 end) as POD,
      SUM((select COUNT(ID) from job_debriefs WHERE JobID = jn.ID)) as Debriefs,
      FROM customer c
      LEFT JOIN job_new jn ON jn.JobOwnerID = c.ID
      LEFT JOIN manifestdetails md ON md.JobID = jn.ID and md.ColDelReturn = ''C''
      LEFT JOIN manifest man ON md.ManifestID = man.ID
      WHERE jn.IsActive = 1 AND c.Company_ID = 12
      GROUP BY c.Name WITH ROLLUP
  </code></pre>