我有以下 XML 數據。我需要以分層表格格式將它們呈現在 ASP.NET 網頁上。XML：<Developers> <Region name="UK"> <Region name="England"> <Region name="London"> <Data Date="01-01-2019"> <Value name="DotNet">100</Value> </Data> <Data Date="01-01-2020"> <Value name="DotNet">200</Value> <Value name="Java">300</Value> </Data> </Region> <Region name="Other"> <Data Date="01-01-2019"> <Value name="DotNet">400</Value> </Data> <Data Date="01-06-2019"> <Value name="DotNet">500</Value> </Data> </Region> </Region> <Region name="Scotland"> <Data Date="01-01-2019"> <Value name="DotNet">600</Value> </Data> </Region> </Region> <Region name="France"> <Data Date="01-06-2020"> <Value name="DotNet">700</Value> </Data> </Region> <Region name="Germany"> <Data Date="01-06-2019"> <Value name="Java">800</Value> </Data> </Region></Developers>預期輸出：其中 (-) 是樹視圖的展開/折疊控件。是否可以使用 ASP.NET 數據網格來實現此目的？任何代碼示例都會非常有用。
1 回答
智慧大石
TA貢獻1946條經驗 獲得超3個贊
在asp.net網格視圖中顯示xml數據。
默認 asp 網頁
<html>
<head>
<title>Datagrid With XML </title>
<link rel="stylesheet" href="css/ASPNetCookbook.css">
</head>
<body leftmargin="0" marginheight="0" marginwidth="0" topmargin="0">
<form id="frmDatagrid" method="post" runat="server">
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td align="center">
<img src="images/ASPNETCookbookHeading_blue.gif">
</td>
</tr>
<tr>
<td class="dividerLine">
<img src="images/spacer.gif" height="6" border="0"></td>
</tr>
</table>
<table width="90%" align="center" border="0">
<tr>
<td><img src="images/spacer.gif" height="10" border="0"></td>
</tr>
<tr>
<td align="center" class="PageHeading">
DataGrid Using Data From XML (VB)</td>
</tr>
<tr>
<td><img src="images/spacer.gif" height="10" border="0"></td>
</tr>
<tr>
<td align="center">
<asp:DataGrid
id="dgRegion"
runat="server"
BorderColor="000080"
BorderWidth="2px"
AutoGenerateColumns="False"
width="100%">
<HeaderStyle
HorizontalAlign="Center"
ForeColor="#FFFFFF"
BackColor="#000080"
Font-Bold=true
CssClass="TableHeader" />
<ItemStyle
BackColor="#FFFFE0"
cssClass="TableCellNormal" />
<AlternatingItemStyle
BackColor="#FFFFFF"
cssClass="TableCellAlternating" />
<Columns>
<asp:BoundColumn HeaderText="Region" DataField="Region" />
<asp:BoundColumn HeaderText="Data " DataField="Data "
ItemStyle-HorizontalAlign="Center" />
<asp:BoundColumn HeaderText="Value " DataField="Value "
ItemStyle-HorizontalAlign="Center" />
</Columns>
</asp:DataGrid>
</td>
</tr>
</table>
</form>
</body>
</html>
下面給出cs代碼。
using System;
using System.Configuration;
using System.Data;
using System.Data.OleDb;
namespace ASPNetCookbook.CSExamples
{
public class CH01DataGridWithXMLCS : System.Web.UI.Page
{
private void Page_Load(object sender, System.EventArgs e)
{
const String Region_TABLE = "Region";
DataSet dSet = null;
String xmlFilename = null;
if (!Page.IsPostBack)
{
try
{
// get fully qualified path to the "Region" xml document located
xmlFilename = Server.MapPath("xml") + "\\Region.xml";
dSet = new DataSet( );
dSet.ReadXml(xmlFilename);
// bind the dataset to the datagrid
dgRegion.DataSource = dSet.Tables[Region_TABLE];
dgRegion.DataBind( );
}
finally
{
// cleanup
if (dSet != null)
{
dSet.Dispose( );
}
} // finally
}
} // Page_Load
}
}
- 1 回答
- 0 關注
- 133 瀏覽
添加回答
舉報
0/150
提交
取消