Dear I had static news scroller one liner which works fine and now i want to make it dynamic so that I have that code before
<li class="news-item" runat="server">
<h2>
Welcome to RBME Section!
</h2>
</li>
<li class="news-item">
<h2>
First draft of R&D protocols
</h2>
</li>
<li class="news-item">
<h2>
APPR PROCESS initiated
</h2>
</li>
<li class="news-item">
<h2>
CSP4 Core team constituted
</h2>
</li>
<li class="news-item">
<h2>
FIRST MER Network meeting is begin conducted
</h2>
</li>
<li class="news-item">
<h2>
IT Services You Desire Always waiting for you with Plan Pakistan (ITechsol.org)</h2>
</li>
</ul>
it works fine static content displays one by one now i want to make it dynamic so i placed a datalist inside my li and change the code as below
<ul id="js-news" class="js-hidden">
<li class="news_item" runat="server">
<asp:DataList ID="DataList1" runat="server"
RepeatLayout="Table">
<ItemTemplate>
<asp:Label ID="EventDescriptionLabel" runat="server" Text='<%# Eval("CP_Name") %>' />
<div class="clear">
</div>
</ItemTemplate>
</asp:DataList>
</li>
I also tried using code behind technique which is given below
Private Sub getEventImage()
Dim cnnResource As New SqlConnection(AppSettings("DbSqlPortal"))
' Dim lbl As Label = DirectCast(DataList1.FindControl("EventDescriptionLabel"), Label)
Dim _da As SqlDataAdapter
Dim _ds As DataSet
Dim scom As String = "SELECT CP_Name FROM [CountryPrograms]"
_da = New SqlDataAdapter(scom, cnnResource)
_ds = New DataSet()
_da.Fill(_ds)
If (_ds.Tables(0).Rows.Count > 0) Then
DataList1.DataSource = _ds
DataList1.DataBind()
For Each dr As DataRow In _ds.Tables(0).Rows
lbls.Text += dr("CP_Name").ToString()
Next
End If
End Sub
where i am getting value of lbls in datalist_itembound event using the findcontrol method to find the value of lable but I am seeing the first record again and again and my ul is not iterating on the database records??? any help