//xml文档内容
<?xml version = "1.0" encoding="gb2312" standalone="yes"?>
<VFPData>
<company>
<companyno>100</companyno>
<companyname>上海</companyname>
<ceoname>陈四</ceoname>
<ceomail>lsdd@126.com</ceomail>
<ceotel>021-62225813</ceotel>
<ywtel>021-62932763、62984475</ywtel>
<kftel>021-629443215、63274478</kftel>
<gscz>021-62238736</gscz>
<gsaddress>上海浦东</gsaddress>
<postcode>32232</postcode>
<memo>这里是备注的内容。 这里是备注的内容。
</memo>
</company>
<company>
<companyno>200</companyno>
<companyname>南京</companyname>
<ceoname>李国华</ceoname>
<ceomail>lgh_m@126.com</ceomail>
<ceotel>025-86683455</ceotel>
<ywtel>025-86683455</ywtel>
<kftel>025-86683455、88883122</kftel>
<gscz>025-87663455</gscz>
<gsaddress>南京市建邺区</gsaddress>
<postcode>34000</postcode>
<memo/>
</company>
<company>
<companyno>300</companyno>
<companyname>成都</companyname>
<ceoname>小明</ceoname>
<ceomail>xiaoming@126.com</ceomail>
<ceotel>028-89014668</ceotel>
<ywtel>028-86884668、86713998</ywtel>
<kftel>028-86722218、86995538</kftel>
<gscz>028-86717738</gscz>
<gsaddress>成都市人民南路</gsaddress>
<postcode>24000</postcode>
<memo/>
</company>
</VFPData>
//示例源码
using System;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.SqlClient;
using System.Text;
using System.Xml;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
// string str = "<?xml version='1.0' encoding='gb2312' ?><NewDataSet><verify><id>LH</id><name>李宏</name><station>组长</station><level>系统管理员</level><dept>信息组</dept></verify><verify><id>LJS</id><name>刘京生</name><station>网络管理工程师</station><level>普通用户</level><dept>信息组</dept></verify></NewDataSet>";
//ds.ReadXml(new System.IO.MemoryStream(System.Text.Encoding.Default.GetBytes(str)));
DataSet ds = new DataSet();
ds.ReadXml("my.xml");
//返回列数
int nTableCols = ds.Tables[0].Columns.Count;
int nTableRows = ds.Tables[0].Rows.Count;
Response.Write("<table><tr>");
//显示标题部分
for (int y = 0; y < nTableCols; y++)
{
Response.Write("<td>" + ds.Tables[0].Columns[y].Caption); //标题
}
//逐行逐列显示表格内数据
//for(int x = 0;x <nTableRows ; x++) //逐行
//{
// Response.Write("<tr>"); //换行
// for (int y = 0; y < nTableCols; y++) //逐列
// {
// Response.Write("<td>" + ds.Tables[0].Rows[x][y]);
// }
//}
foreach (DataRow curRow in ds.Tables[0].Rows) //逐行
{
Response.Write("<tr>"); //换行
for (int y = 0; y < nTableCols; y++)
{
Response.Write("<td>" + curRow[y]); //逐列
}
}
Response.Write("</table>");
}
}