htm:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>DataSet和XML文件的相互转换</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<table align="center" cellpadding="0" cellspacing="0" border="1" bordercolor="honeydew">
<tr>
<td style="font-size: 9pt;color: #ff0000; background-color: #ff9933;
text-align: center; height: 16px;">
</td>
<td colspan="2" style="font-size: 9pt; color: #ffffff; height: 16px; background-color: #ff9933;
text-align: center">
DataSet和XML文件的相互转换</td>
</tr>
<tr>
<td style="background-color: #ffffcc; text-align: center">
</td>
<td style="background-color: #ffffcc; text-align: center">
<iframe id="leftFrame" scrolling="yes" src="test.xml" style="width: 480px; height: 280px"></iframe>
</td>
<td style="background-color: #ffffcc; text-align: center;">
<asp:GridView ID="GridView1" runat="server" CellPadding="4" Font-Size="9pt" ForeColor="#333333"
GridLines="None">
<FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
<PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
</td>
</tr>
<tr>
<td style=" background-color: #ff9900; text-align: center; height: 23px;">
</td>
<td style="height: 23px; background-color: #ff9900; text-align: center">
<asp:Button ID="Button1" runat="server" Font-Size="9pt" Text="DataSet转换XML" OnClick="Button1_Click" /></td>
<td style="text-align: center; background-color: #ff9900; height: 23px;">
<asp:Button ID="Button2" runat="server" Font-Size="9pt" Text="XML转换DataSet" OnClick="Button2_Click" Enabled="False" /></td>
</tr>
</table>
</div>
</form>
</body>
</html>
text.xml:
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<Table>
<EmployeeID>1</EmployeeID>
<EName>明*日</EName>
<ESex>男</ESex>
<EAge>25</EAge>
<EPlace>吉林省长春市</EPlace>
<EMoney>5000</EMoney>
</Table>
<Table>
<EmployeeID>2</EmployeeID>
<EName>张*三</EName>
<ESex>男</ESex>
<EAge>28</EAge>
<EPlace>吉林省长春市</EPlace>
<EMoney>3000</EMoney>
</Table>
<Table>
<EmployeeID>3</EmployeeID>
<EName>李*四</EName>
<ESex>女</ESex>
<EAge>23</EAge>
<EPlace>山西省长治市</EPlace>
<EMoney>3000</EMoney>
</Table>
<Table>
<EmployeeID>4</EmployeeID>
<EName>王*五</EName>
<ESex>女</ESex>
<EAge>26</EAge>
<EPlace>山西省长治市</EPlace>
<EMoney>2000</EMoney>
</Table>
<Table>
<EmployeeID>5</EmployeeID>
<EName>测试</EName>
<ESex>男</ESex>
<EAge>18</EAge>
<EPlace>山东省日照市</EPlace>
<EMoney>1500</EMoney>
</Table>
</NewDataSet>
.cs:
protected void Button1_Click(object sender, EventArgs e)
{//数据库中读取数据 到datset myds;
myds.WriteXml(Server.MapPath("test.xml"));//写入xml
Button2.Enabled = true;
}
protected void Button2_Click(object sender, EventArgs e)
{
DataSet myds = new DataSet();
myds.ReadXml(Server.MapPath("test.xml"));//ReadXml:读出xml
GridView1.DataSource = myds;
GridView1.DataBind();
}