如何将Xml文件导入DataGridview? [英] how to import a Xml File to DataGridview ??

问题描述

大家好
我想将Xml文件导入datagridview.请帮助我.

Hi all
I want to import a Xml file to datagridview . please help me.

推荐答案

使用DataSet或DataTable''s
读取Xml文件 ReadXml()方法
将DataGridView绑定到DataSet/DataTable

Read the Xml file using DataSet or DataTable''s
ReadXml() method
Bind the DataGridView to the DataSet/DataTable

hi 我有一个完整的解决方案项目，用于将xml文件导入和导出到datagridview，反之亦然.
希望我的项目对您有用.
请按照以下步骤操作:
1-创建新的Windows窗体应用程序项目
2-拖动datagridview并将其重命名为:dgv
3-拖动3个按钮:并将其名称更改为btnRead，btnWrite，btnClear
及其文字为读取XML"，写入XML"，清除"
4-双击form1，然后按Control + A选择所有文本，然后将其替换为以下代码:

hi i have a compelete solution project for importing and exporting xml files to datagridview and vise versa.
i hope my project will be useful for you.
follow these steps:
1- create new windows forms application project
2- drag a datagridview and rename it to: dgv
3- drag 3 buttons: and change their names to btnRead, btnWrite, btnClear
and their text as "Read XML","Write XML","Clear"
4- double click on the form1 and press control+A to select all text and replace it by the codes below:

Public Class Form1

    Dim dt As DataTable
    Dim fs As IO.Stream
    Dim ss As IO.Stream

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    End Sub

    Private Sub btnRead_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRead.Click
        Dim sd As New OpenFileDialog
        sd.Filter = "XML ducuments(*.XML)|*.xml"
        sd.DefaultExt = "xml"
        If sd.ShowDialog = DialogResult.OK Then
            fs = sd.OpenFile
            Change_Datatable()
            If IO.File.Exists(IO.Path.ChangeExtension(sd.FileName, ".sch")) Then
                ss = New IO.StreamReader(IO.Path.ChangeExtension(sd.FileName, ".sch")).BaseStream
                dt.ReadXmlSchema(ss)
                ss.Close()
            Else
                MsgBox("فایل حاوی تنظیمات دیتابیسی(XML-Schema) برای XML انتخاب شده یافت نشد.", MsgBoxStyle.MsgBoxRtlReading Or MsgBoxStyle.MsgBoxRight)
                Return
            End If
            dt.ReadXml(fs)
            fs.Close()
        End If
    End Sub

    Private Sub btnWrite_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnWrite.Click
        Dim sd As New SaveFileDialog
        sd.Filter = "XML ducuments(*.XML)|*.xml"
        sd.DefaultExt = "xml"
        If sd.ShowDialog = DialogResult.OK Then
            fs = sd.OpenFile
            ss = New IO.StreamWriter(IO.Path.ChangeExtension(sd.FileName, ".sch")).BaseStream
            dt.WriteXmlSchema(ss)
            dt.WriteXml(fs)
            fs.Close()
            ss.Close()
        End If
    End Sub

    Private Sub btnClear_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnClear.Click
        dt.Clear()
    End Sub

    Public Sub Change_Datatable()
        dt = New DataTable
        dt.TableName = "Tables(0)"
        dgv.DataSource = dt
    End Sub

End Class

这篇关于如何将Xml文件导入DataGridview?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！