用程序控制输出表格行和列数(用asp.net的中Lable举个例子)-优快云博客

本文链接：https://blog.youkuaiyun.com/wslyy99/article/details/3225969

本文介绍了一个使用ASP.NET从数据库中获取数据并将其显示在网页上的示例。通过一个循环过程，实现了每次显示固定数量的数据行，并在数据量超过预设行数时继续加载剩余的数据。该方法适用于大型数据集的分页展示。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

前台是一个Lable:

下面是后台程序:

if (!Page.IsPostBack)
        {
            DataSet ds;
            string _sqlStr = "";
           
            _sqlStr += "select a,b,c from table_";
            using (DBManage _db = new DBManage())
            {
                ds = _db.GetDataSet(_sqlStr);
                int Cnt_Row = 5;
                int index_Begin = 0;
                int index_End = Cnt_Row;
              
                while (index_Begin < ds.Tables[0].Rows.Count && index_End < ds.Tables
[0].Rows.Count)
                {
                    Lab_Table.Text += "<tr>";
                    for (int i = index_Begin; i < index_End; i++)
                    {
                        Lab_Table.Text += "<td align=/"center/" fontsize=/"15pt/"><b>";
                        Lab_Table.Text += ds.Tables[0].Rows[i][0].ToString();
                        Lab_Table.Text += "</td>";
                    }
                    Lab_Table.Text += "</tr>";
                    Lab_Table.Text += "<tr>";
                    for (int i = index_Begin; i < index_End; i++)
                    {
                        Lab_Table.Text += "<td align=/"center/" fontsize=/"15pt/"><b>";
                        Lab_Table.Text += ds.Tables[0].Rows[i][1].ToString();
                        Lab_Table.Text += "</td>";
                    }
                    Lab_Table.Text += "</tr>";
                    Lab_Table.Text += "<tr>";
                    for (int i = index_Begin; i < index_End; i++)
                    {
                        Lab_Table.Text += "<td align=/"center/" fontsize=/"15pt/"><b>";
                        Lab_Table.Text += ds.Tables[0].Rows[i][2].ToString();
                        Lab_Table.Text += "</td>";
                    }
                    Lab_Table.Text += "</tr>";
                    if (index_Begin + Cnt_Row < ds.Tables[0].Rows.Count)
                    {
                        index_Begin = index_Begin + Cnt_Row;
                        index_End = index_End + Cnt_Row;
                    }
                    else
                    {
                        //m_bBeginIndexOverFlow = true; 
                        break;
                    }
                }
                Lab_Table.Text += "<tr>";
                for (int i = index_Begin; i < ds.Tables[0].Rows.Count; i++)
                {
                    Lab_Table.Text += "<td align=/"center/" fontsize=/"15pt/"><b>";
                    Lab_Table.Text += ds.Tables[0].Rows[i][0].ToString();
                    Lab_Table.Text += "</td>";
                }
                Lab_Table.Text += "</tr>";
                Lab_Table.Text += "<tr>";
                for (int i = index_Begin; i < ds.Tables[0].Rows.Count; i++)
                {
                    Lab_Table.Text += "<td align=/"center/" fontsize=/"15pt/"><b>";
                    Lab_Table.Text += ds.Tables[0].Rows[i][1].ToString();
                    Lab_Table.Text += "</td>";
                }
                Lab_Table.Text += "</tr>";
                Lab_Table.Text += "<tr>";
                for (int i = index_Begin; i < ds.Tables[0].Rows.Count; i++)
                {
                    Lab_Table.Text += "<td align=/"center/" fontsize=/"15pt/"><b>";
                    Lab_Table.Text += ds.Tables[0].Rows[i][2].ToString();
                    Lab_Table.Text += "</td>";
                }
                Lab_Table.Text += "</tr>";
                Lab_Table.Text += "</table>";
                Lab_Table.Text = "<table border=/"1/" align=/"center/" cellpadding=/"0/" 
cellspacing=/"0/" style=/"width: 75%;font-size: 10pt; font-family: Arial/" 
id=/"Table_Input/" runat=/"server/">" + Lab_Table.Text;
            }
        }