How to Load Data in the DataGridView Using XML File and C#.

Submitted by: 
Language: 
Visitors have accessed this post 121 times.

In this tutorial, I will teach you how to Load Data in the DataGridView Using XML File and C#. By doing this program, you will see that the output will be inside the DataGridView displaying the contents of an XML File. For you to have an idea of how this works, simply follow the procedure below.

Creating XML FIle

Go to solution explorer and right click the file name. After that select “Add” and hit “New Item”.
ps4
Choose the “XML File” and named it “person” then click “Add”.
ps5
Add data to the XML File.

  1. <NewDataSet>
  2. <person>
  3. <Name>Janno Palacios</Name>
  4. <Address>Kabankalan City</Address>
  5. </person>
  6. <person>
  7. <Name>Jeanniebe Palacios</Name>
  8. <Address>Kabankalan City</Address>
  9. </person>
  10. <person>
  11. <Name>Craig Palacios</Name>
  12. <Address>Kabankalan City</Address>
  13. </person>
  14. <person>
  15. <Name>Kenjie Palacios</Name>
  16. <Address>Kabankalan City</Address>
  17. </person>
  18. </NewDataSet>

Creating Application

Step 1

Open Microsoft Visual Studio 2015 and create a new windows form application for c#.
ps1

Step 2

Add a DataGridView and Button inside the Form just like shown below.
ps2

Step 3

Put the XML File in the resources folder by dragging it.
ps3

Step 4

Press F7 to open the code editor. In the code editor, create a method to get the data in the XML File and display it into the DataGridView.

  1.  
  2. private void LoadPerson(DataGridView dtg)
  3. {
  4. DataSet dsCountries = new DataSet();
  5. dsCountries.ReadXml(new System.IO.StringReader(Properties.Resources.person));
  6.  
  7. dtg.DataSource = dsCountries.Tables[0];
  8. }

Step 5

Write the following code to execute the method that you have created when the button is clicked.

  1.  
  2. private void button1_Click(object sender, EventArgs e)
  3. {
  4. LoadPerson(dataGridView1);
  5. }

The complete source code is included. You can download it and run it on your computer.
For any questions about this article. You can contact me @
Email – [email protected]
Mobile No. – 09305235027 – TNT
Or feel free to comment below.


Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • You may insert videos with [video:URL]
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th> <img> <h1> <h2> <h3> <iframe> [video]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.