title: Asp.net repeater control data duplicated when use multiple times binding
body: <p>I am using asp.net 2008 repeater control. I am trying to refresh the repeater control when a button is clicked, it shows me duplicated values, that means its appending the same values once again. Here is my code</p>
  
  <pre><code> public void LoadRepeater1()
      {
          con = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlServerConnection"].ConnectionString);
          String sql;
          sql = "select * from FeeCollection Where AdminNo='"+lblstano.Text+"'";
          cmd = new SqlCommand(sql, con);
          da = new SqlDataAdapter(sql, con);
          da.Fill(ds, "FeeCollection");
          dt = ds.Tables["FeeCollection"];
  
          Repeater4.DataSource = dt;
          Repeater4.DataBind();
          con.Close();
  
  
      }
  
   protected void btnMedical_Click(object sender, EventArgs e)
      {
          LoadRepeater1();
      }
  </code></pre>
  
  <p>I want to remove the existing data and refresh the data instead of appending.</p>