从Grid上的XML导入数据 [英] Import data from XML on Grid

问题描述

如何使用Visual Studio 2005从桌面应用程序的vb.net中的xml文件中的网格文件中导入网格数据?

How can I import data on grid from xml file in vb.net at desktop application using visual studio 2005?

推荐答案

您可以使用DataSet 或DataTable的ReadXML方法将数据从XML文件加载到DataTable 或DataSet ，您可以将其绑定到DataGrid 或DataGridView.

You can use DataSet or DataTable''s ReadXML method to load data from XML file to DataTable or DataSet and you can bind it to DataGrid or DataGridView.

______________________________________________________________________
VB
______________________________________________________________________

______________________________________________________________________
VB
______________________________________________________________________

Dim xDoc As System.Xml.Linq.XDocument = System.Xml.Linq.XDocument.Load("c:\test.xml")
Dim elements = From el In xDoc.Descendants("Master")
                Select Id = el.Element("Id").Value,
                       Name = el.Element("Name").Value
DataGridView1.DataSource = elements.ToList()

______________________________________________________________________
C#
______________________________________________________________________

______________________________________________________________________
C#
______________________________________________________________________

System.Xml.Linq.XDocument xDoc = System.Xml.Linq.XDocument.Load("c:\\test.xml");
var elements = from el in xDoc.Descendants("Master")
               select new
               {
                 Id = el.Element("Id").Value,
                 Name = el.Element("Name").Value
               };
datagridview.DataSource = elements.ToList();

______________________________________________________________________
test.xml
______________________________________________________________________

______________________________________________________________________
test.xml
______________________________________________________________________

<test>
	<master>
		<id>1</id>
		<name>Name1</name>
	</master>
	<transaction>
		<id>1</id>
		<amount>100</amount>
	</transaction>
</test>

你好，亲爱的，

您可以使用以下代码.

< pre lang ="c#">
gridView.dataSource =数据集.ReadXml(< XmlFilename>));
gridView.databind();

</pre>

Hello Dear,

You can use the below code.

<pre lang="c#">
gridView.dataSource= Dataset.ReadXml(<XmlFilename>);
gridView.databind();

</pre>

这篇关于从Grid上的XML导入数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！