title: Insert Header Between rows If name Is Different in Gridview
body: <p>I Have a gridview and I want to show Header/Space with the column having heading "AccountManager"(Column 1) as name between rows.  If Name Is Different and sum of columns "Mins" , "Amount" , and "Profit" of per accountmanager in the space/Header above every "AccountManager". </p>
  
  <p>This is my GridView(HTML):</p>
  
  <pre><code>&lt;asp:gridview runat="server" id="GridView2" showfooter="true" 
      autogeneratecolumns="false" GridLines="None" CssClass="table" 
      HeaderStyle-CssClass="th" RowStyle-CssClass="td" Width="100%" OnRowDataBound="GridView2_RowDataBound" onrowcreated="GridView2_RowCreated"&gt;
      &lt;columns&gt;
  
          &lt;asp:boundfield datafield="Date" headertext="Date" 
              footerstyle-font-bold="true"  &gt;
  &lt;FooterStyle Font-Bold="True"&gt;&lt;/FooterStyle&gt;
          &lt;/asp:boundfield&gt;
          &lt;asp:boundfield datafield="AccountManager" headertext="AccountManager" 
              footerstyle-font-bold="true"  &gt;
  &lt;FooterStyle Font-Bold="True"&gt;&lt;/FooterStyle&gt;
          &lt;/asp:boundfield&gt;
  
           &lt;asp:boundfield datafield="" headertext="Total" footerstyle-font-bold="true" 
              footertext="Grand Total:" &gt;
  &lt;FooterStyle Font-Bold="True"&gt;&lt;/FooterStyle&gt;
          &lt;/asp:boundfield&gt;
          &lt;asp:boundfield datafield="MIns" headertext="Mins" 
              footerstyle-font-bold="true"   &gt;
  &lt;FooterStyle Font-Bold="True"&gt;&lt;/FooterStyle&gt;
          &lt;/asp:boundfield&gt;
          &lt;asp:boundfield datafield="Amount" headertext="Amount" footerstyle-font-bold="true" 
               &gt;
   &lt;FooterStyle Font-Bold="True"&gt;&lt;/FooterStyle&gt;
          &lt;/asp:boundfield&gt;
  
          &lt;asp:boundfield datafield="Profit" headertext="Profit"  
              footerstyle-font-bold="true"&gt;
  &lt;FooterStyle Font-Bold="True"&gt;&lt;/FooterStyle&gt;
          &lt;/asp:boundfield&gt;
  
     &lt;/columns&gt;
  
   &lt;HeaderStyle BackColor="#CEFF99" ForeColor="Black" BorderColor="#C1FF80" BorderStyle="Solid" 
                BorderWidth="1px"&gt;&lt;/HeaderStyle&gt;
  
  &lt;RowStyle CssClass="td"&gt;&lt;/RowStyle&gt;
  &lt;/asp:gridview&gt;
  </code></pre>
  
  <p>Kindly help...i m in soooooo trouble.</p>