选取框从数据库加载文本 [英] Marquee loading text from database

问题描述

你好，我怀疑他是否需要澄清.我有一个字幕可以从数据库加载文本，但是我得到的只是一条记录，而且我需要所有记录，是否知道如何使字幕从数据库加载所有记录?
这是我的代码:

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();
   }

推荐答案

首先，您不能使用

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:

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

代码:

CODE:

//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

--Amit

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

    }

现在将您的abc字符串连接到数据库的datareader对象并执行.即

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.

这篇关于选取框从数据库加载文本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！