DataSet转换XML转换DataSet

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();
    }

 

 

 

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值