Marquee loading text from database

Question

0.00/5 (No votes)

See more:

Hello, I have a doubt that he needed to see clarified. I have a marquee that loads text from a database but all I get is a recording and I need all the records, any idea how to make the marquee load all records from the database?
Here is my code:

protected void Page_Load(object sender, EventArgs e)
   {

       SqlDataAdapter nextdays_da = new SqlDataAdapter("SELECT * FROM JANELA_CSD_INFO WHERE [Type]='Next days'", sqlconn);
       DataSet nextdays_ds = new DataSet();
       nextdays_da.Fill(nextdays_ds);
       DataTable nextdays_dt = nextdays_ds.Tables[0];
       NextDays = nextdays_dt.Rows.Count;
       if (NextDays == 0)
       {
           lt1.Text = "Não tem eventos próximos!";
       }
       if (NextDays == 1)
       {
           string assunto;
           sqlconn.Open();
           assunto = "SELECT Subject FROM JANELA_CSD_INFO WHERE Type='Next days' AND Status=1";
           SqlCommand assuntocmd = new SqlCommand(assunto, sqlconn);
           assuntocmd.ExecuteNonQuery();
           string ASSUNTO = ((string)assuntocmd.ExecuteScalar());
           string data;
           data = "SELECT Date FROM JANELA_CSD_INFO WHERE Type='Next days' AND Status=1 AND Subject='" + ASSUNTO + "'";
           SqlCommand datacmd = new SqlCommand(data, sqlconn);
           datacmd.ExecuteNonQuery();
           DateTime Data = Convert.ToDateTime(datacmd.ExecuteScalar());
           lt1.Text = ASSUNTO.ToString() + "*" + Data + "*";
           sqlconn.Close();
       }
       else if (NextDays > 1)
       {
           int Next_Days;
           sqlconn.Open();
           SqlDataAdapter NextDaysDA = new SqlDataAdapter("SELECT * FROM JANELA_CSD_INFO WHERE [Type]='Next days'", sqlconn);
           DataSet NextDaysDS = new DataSet();
           NextDaysDA.Fill(NextDaysDS);
           DataTable NextDaysDT = NextDaysDS.Tables[0];
           Next_Days = NextDaysDT.Rows.Count;
           Next_Days++;
           for (int i = 1; i < Next_Days; i++)
           {
               string assunto;
               assunto = "SELECT Subject FROM JANELA_CSD_INFO WHERE Type='Next days' AND Status=1";
               SqlCommand assuntocmd = new SqlCommand(assunto, sqlconn);
               assuntocmd.ExecuteNonQuery();
               string ASSUNTO = ((string)assuntocmd.ExecuteScalar());
               string data;
               data = "SELECT InitialDate FROM JANELA_CSD_INFO WHERE Type='Next days' AND Status=1 AND Subject='" + ASSUNTO + "'";
               SqlCommand datacmd = new SqlCommand(data, sqlconn);
               datacmd.ExecuteNonQuery();
               DateTime Data = Convert.ToDateTime(datacmd.ExecuteScalar());
               string data2;
               data2 = "SELECT ExpectedEndDate FROM JANELA_CSD_INFO WHERE Type='Next days' AND Status=1 AND Subject='" + ASSUNTO + "'";
               SqlCommand datacmd2 = new SqlCommand(data2, sqlconn);
               datacmd.ExecuteNonQuery();
               DateTime Data2 = Convert.ToDateTime(datacmd.ExecuteScalar());
               lt1.Text = ASSUNTO.ToString() + "*" + Data + "-" + Data2 + "*";
           }
           sqlconn.Close();
       }
       if (!IsPostBack)
           BindGrid();
       else
           BindGrid();
   }

Posted 9-Jul-12 3:05am

Paulo Jorge Arteiro Soares

Add a Solution

Comments

[no name] 9-Jul-12 12:33pm

You have 7 queries going on here. Which one is give you the trouble?

Paulo Jorge Arteiro Soares 10-Jul-12 11:37am

well now it loads the information but only appears the first one repeated :s imagine that i have 3 informations, in that case it shows 3 informations in marquee but all with the same text (the first one)

ZurdoDev 11-Jul-12 15:14pm

What did you find is the issue when you debugged it?

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Amy · Answer 1 · 2012-07-13T21:12:00

Hi,
First of all, can't you execute your all 7 queries together using Stored Procedure[^]?
Where is the error? I am not able to find your error actually.

Not a problem. Try this:
HTML:

ASP.NET

<marquee><asp:label id="lblM" runat="server" xmlns:asp="#unknown" /></marquee>

CODE:

C#

//Take the value from database and store it in this string variable
string strMarque="Test"; //This will come from database. 

//Now set the marquee string to the lable inside marquee tag.
lblM.Text = strMarque;

--Amit

Arjun YK · Answer 2 · 2012-07-13T21:02:00

C#

protected void Page_Load(object sender, EventArgs e)
    {
        string abc = "hello world";
        Response.Write("<marquee>"+abc+"</marquee>");

    }

Now connect your abc string to the database's datareader object and execute. i.e..

sqldatareader dr = commandobject.executereader();
while (dr.read())
{
abc = dr[0].Tostring();
}

So it'll display what exactly is the data, as a marquee tag.

Marquee loading text from database

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Marquee loading text from database

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us