Import data from XML on Grid

Question

0.00/5 (No votes)

See more:

data

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

Posted 29-Aug-11 0:57am

Rakesh Meel

Updated 30-Nov-11 2:33am

v4

Add a Solution

Comments

DaveAuld 29-Aug-11 7:14am

Which languange? VB, C#, a.n.other? Which type of grid, Windows Forms, ASP, any other type?

3 solutions

Solution 2

Hello Dear,

You can use the below code.

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

</pre>

Posted 29-Aug-11 1:35am

baisak

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sachin10d · Accepted Answer · 2011-08-30T01:31:00

______________________________________________________________________
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
______________________________________________________________________

HTML

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

Suresh Suthar · Accepted Answer · 2011-08-29T01:16:00

Solution 1

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.

Posted 29-Aug-11 1:16am

Suresh Suthar