title: News ticker using a Repeater and Jquery
body: <p>I have a ticker which uses a jquery and a Repeater.But I only get the last updated record of the 10  new_Feed table.This is the Source and the Code behind. </p>
  
  <pre><code>&lt;ul id="js-news" class="js-hidden"&gt;
  &lt;li class="news-item"&gt;
      &lt;asp:Repeater ID="Repeater1" runat="server"&gt;
      &lt;ItemTemplate&gt;
      &lt;asp:Label ID="myLabel" runat="server" Text='&lt;%# Eval("Text") %&gt;' /&gt;
      &lt;/ItemTemplate&gt;
      &lt;/asp:Repeater&gt;
  &lt;/li&gt;
  &lt;/ul&gt;
  
   SqlConnection con = new SqlConnection(Constring);
      con.Open();
      SqlCommand cmd = new SqlCommand("select Text from News_Feed", con);
  
      SqlDataAdapter sqlDa = new SqlDataAdapter(cmd);
      DataTable dt = new DataTable();
      sqlDa.Fill(dt);
      Repeater1.DataSource = dt;
      Repeater1.DataBind();
      SqlDataReader reader = cmd.ExecuteReader();
  
      while (reader.Read())
      {
          foreach (RepeaterItem ri in Repeater1.Items)
          {
  
              Label lbl = ri.FindControl("myLabel") as Label;
  
              string Text= reader["Text"].ToString();
              lbl.Text = Text;
          }
  
  
      }
      reader.Close();
  </code></pre>