title: How to refresh Repeater and SqlDataSource c# or vb.net
body: <p>In My application i am using Repeater and binding data using SqlDataSource 
  and in that i am performing add operation after that i want Repeater should be refreshed inorder to show newly added record </p>
  
  <p>Code i used:</p>
  
  <pre><code>&lt;asp:Repeater ID="rptOrderReport" EnableViewState="false" runat="server" DataSourceID="OrderReportDataSource"&gt;
              &lt;HeaderTemplate&gt;&lt;tr&gt;&lt;td&gt;        
              &lt;table cellpadding="0" cellspacing="0" border="1" rules="all" class="reports"  align="center"&gt;
                  &lt;tr&gt;
                      &lt;td colspan="5" style="font-size:x-large;font-weight:bold;" &gt;Order Report&lt;/td&gt;
                  &lt;/tr&gt;
  
    &lt;tr class="rptHeadr"&gt;
                          &lt;td&gt;SKU&lt;/td&gt;
                          &lt;td&gt;Color&lt;/td&gt;
                          &lt;td&gt;Size&lt;/td&gt;
                          &lt;td&gt;To Order Total&lt;/td&gt;
                      &lt;/tr&gt;&lt;/HeaderTemplate&gt;
                      &lt;ItemTemplate&gt;
                      &lt;tr &lt;%--class="rptRow"--%&gt;&gt;
                          &lt;td&gt;&lt;%# Eval("ItemSKU")%&gt;&lt;/td&gt;
                          &lt;td&gt;&lt;%# Eval("ColorName")%&gt;&lt;/td&gt;
                          &lt;td&gt;&lt;%# Eval("ItemSize")%&gt;&lt;/td&gt;
                          &lt;td&gt;&lt;%# Eval("TotalCount")%&gt;&lt;/td&gt;
                      &lt;/tr&gt;&lt;/ItemTemplate&gt; 
                     &lt;FooterTemplate&gt;&lt;/table&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/FooterTemplate&gt;
                  &lt;/asp:Repeater&gt;
  </code></pre>
  
  <p>Sql DataSource:</p>
  
  <pre><code>&lt;asp:SqlDataSource  EnableViewState="false" ID="OrderReportDataSource" runat="server"
      ConnectionString="&lt;%$ ConnectionStrings:dbWRConnectionString %&gt;"
      SelectCommand= "Exec [spGetOrderReport] @OrderId"&gt;
      &lt;SelectParameters&gt;
          &lt;asp:QueryStringParameter Name="OrderID" DbType="String" QueryStringField="OID"/&gt;
      &lt;/SelectParameters&gt;
      &lt;/asp:SqlDataSource&gt; 
  </code></pre>
  
  <p>and i made a button to open a popup to add new values and in popup close i wrote page Refresh inorder to show repeater with new data.</p>
  
  <p>Code: on popup close</p>
  
  <pre><code>$('.popCloseAddcolor').click(function () {         
                  location.reload(); 
              $('.popHolderAddColor').hide();
              $('.popHolderSkuEdit').css("display", "none");
              $('.popCloseSkuEdit').hide();
          }); 
  </code></pre>
  
  <p>But its not good thing to refresh page, is there any other way to Refresh only repeater through Jquery/Back end event fire.. </p>