C# load data to datagridview from xml

Vuk Stanojevic

6y1.4kWindows Forms

Hi Everyone,

i have a problem with importing data from xml to datagridview.

It load's only first part on xml, but not what i really need from xml.

Here is code:

private void btnSelect_Click_1(object sender, EventArgs e)

{

OpenFileDialog fd = new OpenFileDialog();

fd.Filter = "XML Files |*.xml";

fd.ShowDialog();

string path = fd.FileName;

DataSet ds = new DataSet();

ds.ReadXml(path);

dataGridView1.DataSource = ds.Tables[0];

}

and here is result:

Bellow you can see xtml which i want to load and i select in yellow what i want to show in datagridview,for each item in xml.

Values marked in yellow is what i want to show in datagridview, and first part which is surrounded with yellow is info which i get now in datagridview but which i don't want.

can you help me to solve this issue?

Thank you very much.

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vuk Stanojevic6y ago
Hi again,

i manage to get all values which i need, but it doesn't go through whole xml file, it just read first RETURN, and it display it twice in listview.

Tested xml have more than 1 RETUR.

Maybe i can't see where i make mistake, can you please tell me why code bellow doesn't read information's for all nodes in my xml, it reads information's only for 1st node in xml, but not for rest 230 nodes?

Thank you.

Here is my code:
foreach (XmlNode node in doc)
{
XmlNode node1 = doc.SelectSingleNode("RETURN_POD_EXPORT_INFO/RETURNS/RETURN/BANK/CUSTOMER_BANK_ACCOUNT");
string bank = node1.InnerText;
XmlNode node2 = doc.SelectSingleNode("RETURN_POD_EXPORT_INFO/RETURNS/RETURN/CUSTOMER_NAME");
string name = node2.InnerText;
XmlNode node3 = doc.SelectSingleNode("RETURN_POD_EXPORT_INFO/RETURNS/RETURN/CUSTOMER_SURNAME");
string surname = node3.InnerText;
XmlNode node4 = doc.SelectSingleNode("RETURN_POD_EXPORT_INFO/RETURNS/RETURN/ORDER_ID");
string orderid = node4.InnerText;
XmlNode node5 = doc.SelectSingleNode("RETURN_POD_EXPORT_INFO/RETURNS/RETURN/RETURN_ID");
string returnid = node5.InnerText;
XmlNode node6 = doc.SelectSingleNode("RETURN_POD_EXPORT_INFO/RETURNS/RETURN/RETURN_AMOUNT");
string amount = node6.InnerText;
XmlNode node7 = doc.SelectSingleNode("RETURN_POD_EXPORT_INFO/RETURNS/RETURN/ADDRESS/CITY");
string city = node7.InnerText;
ListViewItem item = new ListViewItem(bank);
item.SubItems.Add(name + " " + surname);
item.SubItems.Add(city);
item.SubItems.Add("ONLINE POVRAT");
item.SubItems.Add(orderid);
item.SubItems.Add(amount);
item.SubItems.Add(returnid);
for (int i = 0; i < item.SubItems.Count; i++)
{
listView1.Items.Clear();
listView1.Items.Add(item);
}
+1
Vuk Stanojevic6y ago
Hi Jignesh, Kumar,
Non of refer links and recommended instruction's didn't solve my problem.
XML which i get have Bank details and Address details in separated attribut inside XML for each return.
So basically, some information's which i need appears in ds.Tables[2] , some in ds.Tables[3] , some in ds.Tables[4].
But goal is to show all of this information's in one datagridview1.

I don't know if it is possible to delete entire line from xml, for example
and , in order to avoid 3 different attributes for each RETURN, to delete them and then to have ADDRESS and BANK under directly, not like childnode of RETURN.

Or if there is any other way which you think that i can try, please advice.

Thank you.
+1
Mageshwaran R6y ago
Hi Stanojevic,
please refer links:
https://www.youtube.com/watch?v=iGlvRTxV3Lc
https://www.youtube.com/watch?v=6WFZv6F9aGc
+1
Jignesh Kumar6y ago
Hi,

Please put debugger and check may be values which you are expecting will be in second table of your dataset.

If it is coming under second table then Please try this,
private void btnSelect_Click_1(object sender, EventArgs e)
{
OpenFileDialog fd = new OpenFileDialog();
fd.Filter = "XML Files |*.xml";
fd.ShowDialog();
string path = fd.FileName;
DataSet ds = new DataSet();
ds.ReadXml(path);
dataGridView1.DataSource = ds.Tables[1];
}
+1
Vuk Stanojevic6y ago
Hello,
i attach xml file.
Information's which i need to import to datagridview for each return node are:
1. Customer name
2. Customer surname
3. Customer bank account
4. Order ID
5.Return ID
6. Return amount
6. Address
7. City
I tried a lot of things, but simple i'm begginer in C# and still don't get it how to manage it.
I appreciate your help
+1
Jefferson S. Motta6y ago
Using linq:
XDocument doc = XDocument.Load("input.xml");
var q = from node in doc.Descendants("Setting")
        let attr = node.Attribute("name")
        where attr != null && attr.Value == "File1"
        select node;
q.ToList().ForEach(x => x.Remove());
doc.Save("output.xml");
https://stackoverflow.com/questions/919645/how-to-delete-node-from-xml-file-using-c-sharp

Please, mark as solved.
Jeff
+1
Vuk Stanojevic6y ago
Thank you Jefferson.
What i realize is if i delete manually from XML "" and "" from all places in xmls, then it works fine.
Is there any way to delete it programatically and then import data from file?
Thank you.
+1
Jefferson S. Motta6y ago
You just can't put all data in columns,
you have BANK and ADDRESS that have their own attribute,
you'll need to read them in another grid separated.
var xmldoc = new XmlDocument();
            xmldoc.Load(@"test.xml");
            var nodeList = xmldoc.SelectNodes("/RETURN_POD_EXPORT_INFO/RETURNS");

            var sbRet = new StringBuilder(@""1.0"" encoding=""UTF-8""?>
                ");
            foreach (XmlNode node in nodeList)
                sbRet.AppendLine(node.InnerXml.ToString());
            sbRet.AppendLine("");

            var tmpXml = (Path.GetTempPath() + Guid.NewGuid() + ".xml");

            using (var tw = new StreamWriter(tmpXml, false, Encoding.UTF8))
            {
                tw.Write(sbRet.ToString());
            }

            var ds = new DataSet();
            ds.ReadXml(tmpXml);
            radGridView1.DataSource = ds.Tables[0];
+1
Vuk Stanojevic6y ago
Here it is xml as test.
This xml can contain more then one return, in this case it's only 2, so we should get 2 rows, but it can be xxxxxx returns/rows.

ds.Tables[0][0] can't be applied.

""
1
brand
123456
XX
XXX
2019-05-19 11:53:12
999.99
2

5060322
49199749
199.99
2019-04-02 07:24:12

111111

+11111111111

123567987907
1111222233444444444

12214

+1111111111

5060322
49199749
199.99
2019-04-02 07:24:12

111111

+11111111111

123567987907
1111222233444444444

12214

+1111111111

""
0
Jefferson S. Motta6y ago
please, can you post this XML as text.

I guess this can be done like this: dataGridView1.DataSource = ds.Tables[0][0], but I'm not sure. So I need your XML test to look for a solution.
0