Dear Experts !!
Am working on Asp.net , C#, Sqlserver 2005.
On my webpage I used Literal Controls to Scroll the data from Database.
DATABASE Marquee scrolls from RIGHT To LEFT. SO after 2 minutes its stops Scrolling.
Please can u show me , how to make marquee Continously Scroll.
this is my code:
=================
string textDep = "<marquee style='position: relative;' width='100%' height='50' behavior='slide' direction='left' loop='-1'>" + strdep + "<br />" + "</marquee>";
string textArr = "<marquee style='position: relative;' width='100%' height='50' behavior='slide' direction='left' loop='-1'>" + strarr + "<br />" + "</marquee>";
Literal1.Text = textDep;
Literal2.Text = textArr;
and this is my database Procedure
====================================
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER procedure [dbo].[scroll_arrival]
as
begin
declare @fltno nvarchar(50)
declare @sta nvarchar(50)
declare @cities1 nvarchar(50)
declare @pubr nvarchar(50)
declare @car nvarchar(50)
declare @getdetails nvarchar(4000)
set @getdetails = ''
declare c1_cursor cursor for
select fltno, sta, cities1, pubr,car from arrivals
open c1_cursor
fetch next from c1_cursor into @fltno, @sta, @cities1, @pubr, @car
while @@fetch_status = 0
begin
set @getdetails = (select @getdetails) + ' <img src="images/'+(select @car)+'.jpg" width="150" height="41" align="absmiddle" /> ' + (select cast(@fltno as nvarchar(50))) + ' ' +
(select cast(@sta as nvarchar(50))) + ' ' + (select cast(@cities1 as nvarchar(50))) + ' '
+ '<span class="style3" style="background-color:#00FF00">' + (select cast(@pubr as nvarchar(50)))+ '</span>'
fetch next from c1_cursor into @fltno, @sta, @cities1, @pubr,@car
end
close c1_cursor
deallocate c1_cursor
select @getdetails as arrivals
end
Please can u show me , how to make marquee Continously Scroll.
THANKS IN ADVANCE.