1. XML檔案是否可以像ACCESS一樣作為資料來源直接寫入DataGridView ?
這問題只要透過DataSet.ReadXml方法即可達成

WinForm C# Code

            System.Data.DataSet AuthorsDataSet = new System.Data.DataSet();
            AuthorsDataSet.ReadXml("XMLFile.xml");
            DataGridView1.DataSource = AuthorsDataSet;
            DataGridView1.DataMember = "authors";

ASP.NET (VB) Code

        Dim AuthorsDataSet As New System.Data.DataSet()
        AuthorsDataSet.ReadXml(Server.MapPath("XMLFIle.xml"))
        GridView1.DataSource = AuthorsDataSet
        GridView1.DataBind()

 

執行結果

  

2. 假如使用XML字串是否也可以作為 DataGridView 的資料來源 ?

透過StringReader的方式讀入 XML 字串，之後再透過DataSet.ReadXml方式即可達成。

WinForm C# Code 

            string xmlString =
                "<?xml version=\"1.0\" encoding=\"utf-8\" ?>" +
                "<employees xmlns=\"http://schemas.microsoft.com/vsto/samples\">" +
                    "<employee>" +
                        "<name>Karina Leal</name>" +
                        "<hireDate>1999-04-01</hireDate>" +
                        "<title>Manager</title>" +
                    "</employee>" +
                "</employees>";


            System.IO.StringReader reader = new System.IO.StringReader(xmlString);
            System.Data.DataSet AuthorsDataSet = new System.Data.DataSet();
            AuthorsDataSet.ReadXml(reader);
            DataGridView1.DataSource = AuthorsDataSet;
            DataGridView1.DataMember = "employee"; 

 

ASP.NET (VB) Code

        Dim xmlString As String = _
            "<?xml version=""1.0"" encoding=""utf-8"" ?>" & _
                "<employees xmlns=""http://schemas.microsoft.com/vsto/samples"">" & _
                    "<employee>" & _
                        "<name>Karina Leal</name>" & _
                        "<hireDate>1999-04-01</hireDate>" & _
                        "<title>Manager</title>" & _
                    "</employee>" & _
                "</employees>"

        Dim reader As System.IO.StringReader = New System.IO.StringReader(xmlString)
        Dim AuthorsDataSet As New System.Data.DataSet()
        AuthorsDataSet.ReadXml(reader)
        GridView1.DataSource = AuthorsDataSet
        GridView1.DataBind()

 

執行結果

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 alen1985 的頭像
    alen1985

    1與0的世界

    alen1985 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄