Web Forms :: Display Marquee (News Ticker) From Database?
Oct 21, 2013
in my asp.net+vb web with access database i iam willing to show a marquee with live data from database.
.aspx code
<marquee behavior="scroll" direction="left">
<div ><asp:Label ID="Label1" runat="server" Text="Label1"></asp:Label></div></marquee>
.vb code
Dim ConString As String = ConfigurationManager.ConnectionStrings("baijuep").ConnectionString
Dim con As New SqlConnection(ConString)
Dim CmdString As String = "SELECT KNo, companyto FROM (InOut) where PosnASOn >= now()-2"
Dim Adpt As New SqlDataAdapter(CmdString, ConString)
Dim KNo As New DataSet()
Adpt.Fill(KNo)
For Each dr As DataRow In KNo.Tables(0).Rows
Label1.Text &= dr("KNo").ToString() + "<br />"
Next
End Sub
when i use the query (SELECT KNo, companyto FROM (InOut) where PosnASOn >= now()-2)
in query analyser it works fine and the data is displayed but when i use the complete code .vb is not dispying data in to label.
I looked for examples for a news ticker and modified one I found to fit my needs. I created a web user control and everything works fine, even with a timer that ticks and refreshes the whole page, but not when I wrap just the user control in an update panel that is controlled by the timer. It works on page load, but then the data disappears on a timer tick. The code behind seems to be running fine and the variables have data etc., so I think it's the javascript, but I'm not sure where to go from here. C# code behind
and the ticker data should be move right to left or from left to right into a textbox or in any other control that is more suitable for this work.i have the little idea about this that this will be imlimented with the help of ajax or java script.but the whole process is not so clear so that i start my work.
I'm barely new to asp. I need to display a marquee from right to left of the footer on my web page. Data has to come from my db in mssql. My friends tell me it can be done in jquery but other forums don't show how to do it.
I have developed a news blog in asp.net 4. When I display news using literal control, the news displays without paragraph. However when i use textbox in administrative site to input the news into db--The Textbox takes the paragraph style and displays it. However i don;t want to use Textbox to display my news. Is there any solution to display the news with the paragraph style and so on? The containing component is Datalist and this is my below code.
i'm new to this forum so please don't punish me if i do somethin wrong :).Okay what i need is a Marquee in ASP.NET C# which consits of something like buttons, hyperlinks or something like that.The arquee as it self is no problem at all. It Shows Data as a String from the SQL Database seperated by a "-"The problem is that i need for each "entry" of this marquee an onClick functionality and that each entry should hold a guid as property.So that if i click on one entry the onClick function fires and get's the guid property to get data from the database relating on that guid.
I am working on How to display the News Updates on page inside Marquee as hyperlink and on click on the link i have to display the details of the selected News .
which approach i can display the particular section of the page ?
I have a website where people can send an email to a group of people and then choose to have that letter posted on our website.
The problem has now become that I get so many of them, I can't keep up with doing it manually. What I'd like to do is have it go to a database and then have it automatically update the site. So, one page will have "teasers" with the Author's name, etc and a few lines of the letter and then it links to another page that has the entire letter.
we have been able to return information from the database and then select the relevant link and return that row of information from the SQL table. The next part I am working on is adding information to the database.
So far all the coding in done in a class file, we are using stored procedures and have used user controls to return the information from the database and then also to select the row of information for each news item from the database. The sql database connection information and executing the stored procedure information is all done in the class file. how to add the news items to the SQL table. Below is the code that is used to return each news item from the SQL Table, how i need to amend this to rather than display the information, save it to the database. Also having used stored procedures, would I need to create another stored procedure to to the INSERT INTO statement
i want to make a add news page that when my user write his news(in up.aspx) then his news shown in news.aspx. what am i going to do ? what is the best way for writing this page ?
I have a feedback form in my website. After submitting the feedback (using Submit button), form's Reference number should generate and showed to the user (with successful message) in a "Pop up" as below:
i.e, your feedback is submitted successfully. Your refrence number is 'xyz10'
This refrence number should be unique for every user who fills the feedback form.
I have a .swf file, which I have to display as a ticker, but the issue is this that I don't want to display it on the webpage, I want it to be floating.
I am trying to use a marquee tied to a datalist. here is my code: The marquee does not scroll it only displays. If there are multiple items in the datalist, each shows with the label. How can I make the text scroll and only show the label once?
