在表asp.net mvc中显示数据
本文关键字:显示 数据 mvc asp net 在表 | 更新日期: 2023-09-27 18:05:46
我想在表中显示数据事件在此之前,我可以在不使用桌子的情况下展示它们但现在我想在桌子上表演到目前为止,我可以做这个
但我想把"Faliure"放在"Name"下,第一次发生,第二次恢复
这是我获取事件的控制器代码
SqlDataReader reader_events = event_command.ExecuteReader();
while (reader_events.Read())
{
events.Add(Convert.ToString(reader_events["Event_Name"]));
events.Add(Convert.ToString(reader_events["Occurrence_Time"]));
events.Add(Convert.ToString(reader_events["Recovery_Time"]).Replace("'n", Environment.NewLine));
//events.Add(string.Concat(Convert.ToString(reader_events["Event_Name"]) + " - " +" Occur " + Convert.ToString(reader_events["Occurrence_Time"]) + " - " + " Recover " + Convert.ToString(reader_events["Recovery_Time"]).Replace("'n", Environment.NewLine)));
//events.Add(string.Concat(" Power Failure " + " Event ID # " + Convert.ToString(reader_events["Event_ID"]) + " Device ID # " + Convert.ToString(reader_events["Device_ID"]) + " Occur at " + Convert.ToString(reader_events["Occurrence_Time"]) + " Recover at " + Convert.ToString(reader_events["Recovery_Time"]).Replace("'n", Environment.NewLine)));
//events.Add(string.Concat(" Power Failure " + " Event ID # " + Convert.ToString(reader_events["Event_ID"]) + ", Device ID # " + Convert.ToString(reader_events["Device_ID"]) + ", Occured " + Convert.ToString(reader_events["Occurrence_Time"]) + ", Recover " + Convert.ToString(reader_events["Recovery_Time"]).ToList().ToPagedList(page ?? 1, 5)));
}
我已将视图数据中的事件作为传递
ViewData["events"] = events;
在我的布局(视图(中,我已经完成了这个
<table class="table table-bordered table-responsive table-hover">
<tr>
<th>
Name
</th>
<th>
Occur
</th>
<th>
Recover
</th>
</tr>
<tbody>
@foreach (var item in ViewData["events"] as List<string>)
{
<tr>
<td style="border:1px solid black">
@Html.DisplayTextFor()
<fieldset>
<b style="text-align:center; width:22%; font-family:'Agency FB'; font-size:small; background-color:#C8E6C9; color:red">
</b>
</fieldset>
</td>
</tr>
}
</tbody>
</table>
我缺少什么?如有任何帮助,将不胜感激
更新:
这是我得到的
错误1
名称来自一个表,同时发生并从另一个表恢复
<table class="table table-bordered table-responsive table-hover">
<tr>
<th>
Name
</th>
<th>
Occur
</th>
<th>
Recover
</th>
</tr>
<tbody>@{
if (ViewData["Data"] != null)
{
if (ViewData.Values != null && ViewData.Values.Count() > 0)
{
foreach (var item in ViewData["Data"] as List<string>)
{
<tr>
<td style="border:1px solid black">
@Html.DisplayTextFor(model => item.Name);
<fieldset>
<b style="text-align:center; width:22%; font-family:'Agency FB'; font-size:small; background-color:#C8E6C9; color:red">
</b>
</fieldset>
</td>
<td style="border:1px solid black">
@Html.DisplayTextFor(model => item.Occur);
<fieldset>
<b style="text-align:center; width:22%; font-family:'Agency FB'; font-size:small; background-color:#C8E6C9; color:red">
</b>
</fieldset>
</td>
<td style="border:1px solid black">
@Html.DisplayTextFor(model => item.Recover);
<fieldset>
<b style="text-align:center; width:22%; font-family:'Agency FB'; font-size:small; background-color:#C8E6C9; color:red">
</b>
</fieldset>
</td>
</tr>
}
}
}
}</tbody>
希望这对你有帮助。