transfer xml data into dataset and bind into gridview

最新推荐文章于 2024-08-09 17:59:00 发布

shixiangzb007

最新推荐文章于 2024-08-09 17:59:00 发布

阅读量469

点赞数

分类专栏： c# 文章标签： dataset xml string server exception table

本文链接：https://blog.csdn.net/shixiangzb007/article/details/2079426

版权

c# 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

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

shixiangzb007

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
transfer xml data into dataset and bind into gridview

client code:http://www.w3.org/1999/xhtml" > Untitled Page this page is to transfer XML data into Dataset table ////////////////////////////////////////////////
复制链接

扫一扫

专栏目录