asp.net Repeater data binding code

  • 2020-05-09 18:28:18
  • OfStack

Repeater control on ASPX page:

<asp:Repeater ID="IndexTopMain" runat="server"> 
<HeaderTemplate><!-- head --> 
<ul> 
</HeaderTemplate> 
<ItemTemplate><!-- Intermediate circulation --> 
<li> • <a href="AritcleDisplay.aspx?id=<%#Eval("id") %>" title="<%#Eval("title") %>" target="_blank"><%#Eval("title").ToString().Length>30?Eval("title").ToString().Substring(0,30)+"...":Eval("title")%></a></li> 
</ItemTemplate> 
<FooterTemplate><!-- The tail --> 
</ul> 
</FooterTemplate> 
</asp:Repeater> 


Bindings for CS files

string indexTopMainStr = "select top 9 id,title from Table order by ID desc"; 
SqlDataAdapter rst = new SqlDataAdapter(indexTopMainStr,conn); 
conn.Open(); 
DataSet rdt = new DataSet(); 
rst.Fill(rdt); 
IndexTopMain.DataSource = rdt;// Data binding  
IndexTopMain.DataBind(); 
conn.Close(); 

Related articles: