transfer xml data into dataset and bind into gridview-优快云博客

本文链接：https://blog.youkuaiyun.com/shixiangzb007/article/details/2079426

本文介绍了一种将XML数据转换为DataSet的方法，并展示了如何在ASP.NET应用程序中使用GridView控件显示这些数据。通过创建一个包含具体列的DataTable并利用DataSet的ReadXml方法，实现了XML数据的有效读取与展示。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

client code:

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <h2>this page is to transfer XML data into Dataset table</h2>
    <div>
    <center>
        <asp:GridView ID="gvXMLAndDataset" runat=server AutoGenerateColumns=true></asp:GridView>
    </center>
    </div>
    </form>
</body>
</html>

//////////////////////////////////////////////////////////////////////////////////////

code behind:

public partial class XMLAndDataset : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            DataBindtoGV();
        }
    }

    public void DataBindtoGV()
    {
        try
        {
            DataSet myDataSet = new DataSet();
            DataTable myTable = new DataTable("table1");
            myTable.Columns.Add("SponsorshipPartNumber", typeof(string));
            myTable.Columns.Add("ManufacturerName", typeof(string));
            myTable.Columns.Add("ManufacturerPartNumber", typeof(string));
            myDataSet.Tables.Add(myTable);

string xmlData = "<XmlDS><table1><SponsorshipPartNumber>852-00608-00A</SponsorshipPartNumber><ManufacturerName>ACP ELECTRONICS CO.,LTD</ManufacturerName><ManufacturerPartNumber>Manu1</ManufacturerPartNumber></table1><table1><SponsorshipPartNumber>852-00608-00B</SponsorshipPartNumber><ManufacturerName>ACP ELECTRONICS CO.,LTD</ManufacturerName><ManufacturerPartNumber>Manu1</ManufacturerPartNumber></table1></XmlDS>";

            System.IO.StringReader xmlSR = new System.IO.StringReader(xmlData);
            myDataSet.ReadXml(xmlSR, XmlReadMode.IgnoreSchema);
            gvXMLAndDataset.DataSource = myDataSet;
            gvXMLAndDataset.DataBind();
        }
        catch(Exception ee)
        {
            string errors = ee.ToString();
        }
    }
}