title: Reload data from sql footable
body: <p>i am using a footable and i need to reload it on a button click but without appending html to the table, i need to reload it from sql as it is filled the first time, is that possible</p>
  
  <p>i have tried to realod the div <code>$("#BusList").load(location.href + " #BusList");</code> the data is loaded but the design is totally messed up</p>
  
  <pre><code>  &lt;div class="row" id="BusList"&gt;
    &lt;table id="demo-foo-filtering" class="table table-striped table-bordered toggle-circle m-b-0" data-page-size="7"&gt;
      &lt;thead&gt;
      &lt;tr&gt;
          &lt;th data-toggle="true"&gt;Name&lt;/th&gt;
          &lt;th&gt;Company&lt;/th&gt;
          &lt;th data-hide="phone"&gt;Bus Type&lt;/th&gt;
          &lt;th data-hide="phone"&gt;Bus Model&lt;/th&gt;
          &lt;th data-hide="phone"&gt;Bus Color&lt;/th&gt;
          &lt;th data-hide="phone, tablet"&gt;Driver Status&lt;/th&gt;
          &lt;th data-hide="phone, tablet"&gt;Bus Status&lt;/th&gt;
          &lt;th data-hide="phone, tablet"&gt;&lt;/th&gt;
      &lt;/tr&gt;
      &lt;/thead&gt;
      &lt;tbody&gt;
      &lt;%
          for (int i = 0; i &lt; BusList.Count; i++)
          {  %&gt;
      &lt;tr class="gradeX"&gt;
          &lt;td&gt;&lt;%=BusList[i].Name %&gt;&lt;/td&gt;
          &lt;td&gt;&lt;%=BusList[i].CompanyName %&gt;&lt;/td&gt;
          &lt;td&gt;&lt;%=BusList[i].BusType %&gt;&lt;/td&gt;
          &lt;td&gt;&lt;%=BusList[i].BusModel %&gt;&lt;/td&gt;
          &lt;td&gt;&lt;%=BusList[i].BusColor %&gt;&lt;/td&gt;
          &lt;td&gt;&lt;span class="&lt;%= BusList[i].DriverBusStatus == 1?"label label-table label-success":"label label-table label-inverse"%&gt;"&gt;&lt;%=BusList[i].DriverBusStatusDesc %&gt;&lt;/span&gt;&lt;/td&gt;
          &lt;td&gt;&lt;span class="&lt;%= BusList[i].BusStatus == 1?"label label-table label-success":"label label-table label-inverse"%&gt;"&gt;&lt;%=BusList[i].BusStatusDesc %&gt;&lt;/span&gt;&lt;/td&gt;
          &lt;td&gt;
              &lt;button type="button" class="btn btn-default" onclick="ViewBus(&lt;%=BusList[i].IdBus %&gt;)" /&gt;
              View Details&lt;/td&gt;
      &lt;/tr&gt;
      &lt;%} %&gt;
  &lt;/tbody&gt;
  &lt;tfoot&gt;
      &lt;tr class="active"&gt;
          &lt;td colspan="10"&gt;
              &lt;div class="text-right"&gt;
                  &lt;ul class="pagination pagination-split footable-pagination justify-content-end m-t-10 m-b-0"&gt;&lt;/ul&gt;
              &lt;/div&gt;
          &lt;/td&gt;
      &lt;/tr&gt;
  &lt;/tfoot&gt;
  &lt;/table&gt;
  &lt;/div&gt;
  </code></pre>
  
  <p>this is a screenshot before the load</p>
  
  <p><a href="https://i.stack.imgur.com/ewL55.png" rel="noreferrer"><img src="https://i.stack.imgur.com/ewL55.png" alt="enter image description here"></a></p>
  
  <p>this is a screenshot after the load</p>
  
  <p><a href="https://i.stack.imgur.com/vrLlM.png" rel="noreferrer"><img src="https://i.stack.imgur.com/vrLlM.png" alt="enter image description here"></a></p>