Thursday, March 22, 2012

Marquee from database

I am retrieving News headlines and put it inside a marquee as hyperlinks.
When the user clicks on the headline i want to display the news page with th
e
specific news detail. the retrieving is fine but I don't know how can i put
the news id , where to keep it,,,, to request it in the news page. so when
the users clicks on the headline it recognises the id and show the specific
details for that news id.
Dim da As New SqlClient.SqlDataAdapter("select Top 3 * from Announcements
order by posteddate DESC", con)
con.Open()
da.Fill(dt)
con.Close()
For Each dr In dt.Rows
strScroller &= "<a
href='News.aspx?Category=Announcements&ID={0}'> " &
dr.Item("Headline").ToString & "</a>" & "
"
Next
strScroller = "<marquee id=mar1 direction=left>" & strScroller &
"</marquee>"
Literal1.Text &= strScroller
<td colspan="2" style="width: 100%; height: 18px;" bgcolor="#058c6e">
<marquee direction=left scrollamount="10" scrolldelay="700"
style="color:White"><strong><asp:Literal id="Literal1"
runat="server"></asp:Literal></strong></marquee>
</td>Hi Ali,
There are a few places you could place the news id and have it
available on the news page. You could store it in a session variable,
or pass it in the querystring, or even use a hidden form field.
You can find many good examples by googling it..
http://www.google.ca/search?hl=en&q...ion+state&meta=

0 comments:

Post a Comment