我在處理如何在 HTML 數(shù)據(jù)表中顯示表的行時(shí)遇到了問題。我想在asp.net中使用c#在HTML數(shù)據(jù)表中顯示存儲在Mysql表中的信息。問題是，代碼可以工作，但是 HTML 表格中只顯示最后一行。請幫忙。代碼如下，C＃protected void ListOfEmployee(){ List<EmployeeAccounts> empList = new List<EmployeeAccounts>(); using (MySqlConnection conn = new MySqlConnection(connectDB())) { conn.Open(); MySqlCommand cmd = new MySqlCommand("SELECT * FROM user", conn); cmd.CommandType = CommandType.Text; cmd.CommandTimeout = 0; MySqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { empList.Add(new EmployeeAccounts { idNumber = dr["user_id"].ToString(), uName = dr["username"].ToString(), fName = dr["fullname"].ToString(), uType = dr["usertype"].ToString(), email = dr["email"].ToString(), status = dr["status"].ToString() }); } dr.Close(); conn.Close(); }}public class EmployeeAccounts { public string idNumber; public string uName; public string fName; public string uType; public string email; public string status;}ASPX<asp:Table ID="tblUserList" CssClass="table table-hover table-vcenter" runat="server"><asp:TableHeaderRow TableSection="TableHeader"> <asp:TableHeaderCell >#</asp:TableHeaderCell><asp:TableHeaderCell >Full Name</asp:TableHeaderCell><asp:TableHeaderCell >Email</asp:TableHeaderCell><asp:TableHeaderCell >Status</asp:TableHeaderCell><asp:TableHeaderCell >User Type</asp:TableHeaderCell></asp:TableHeaderRow><asp:TableRow><asp:TableCell ID="cellID"></asp:TableCell><asp:TableCell ID="cellName"></asp:TableCell><asp:TableCell ID="cellEmail"></asp:TableCell><asp:TableCell CssClass="label label-table label-info" ID="cellStatus"></asp:TableCell><asp:TableCell ID="celluType"></asp:TableCell></asp:TableRow></asp:Table>
1 回答
蕪湖不蕪
TA貢獻(xiàn)1796條經(jīng)驗(yàn) 獲得超7個(gè)贊
List<EmployeeAccounts> lst = GetEmployeeAccounts();
var sb = new System.Text.StringBuilder();
sb.Append(@"
<table class='table table-hover table-vcenter'>
<tr>
<th>ID</th>
<th>Full Name</th>
<th>Type</th>
<th>Email</th>
<th>Status</th>
</tr>
");
if(lst.Count==0)
{
sb.Append("<tr><td colspan='5'>No record</td></tr>");
}
else
{
foreach(var acc in lst)
{
sb.Append("<tr>");
sb.AppendFormat("<td>{0}</td>", acc.idNumber);
sb.AppendFormat("<td>{0}</td>", acc.fName);
sb.AppendFormat("<td>{0}</td>", acc.uType);
sb.AppendFormat("<td>{0}</td>", acc.email);
sb.AppendFormat("<td class='label label-table label-info'>{0}</td>", acc.status);
sb.Append("</tr>");
}
}
sb.Append("</table>");
string htmlTable = sb.ToString();
在 ASP.NET 頁面添加一個(gè)占位符：
<asp:PlaceHolder ID="ph1" runat="server"></asp:PlaceHolder>
然后在后面的代碼處，繼續(xù)編碼：
ph1.Controls.Add(new LiteralControl(htmlTable));
==================================
更新：版本 2（2019 年 10 月 25 日）
List<EmployeeAccounts> lst = GetEmployeeAccounts();
var sb = new System.Text.StringBuilder();
sb.Append(@"
<table class='table table-hover table-vcenter'>
<tr>
<th>ID</th>
<th>Full Name</th>
<th>Type</th>
<th>Email</th>
<th>Status</th>
</tr>
");
if (lst.Count == 0)
{
sb.Append("<tr><td colspan='5'>No record</td></tr>");
}
else
{
foreach (var acc in lst)
{
sb.Append($@"
<tr>
<td>{acc.idNumber}</td>
<td>{acc.fName}</td>
<td>{acc.uType}</td>
<td>{acc.email}</td>
<td class='label label-table label-info'>{acc.status}</td>
</tr>
");
}
}
sb.Append("</table>");
string htmlTable = sb.ToString();
- 1 回答
- 0 關(guān)注
- 160 瀏覽
添加回答
舉報(bào)
0/150
提交
取消