C# load data to datagridview from xml

Question

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.

Vuk Stanojevic · Answer

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 { listView1.Items.Clear(); listView1.Items.Add(item); }

Vuk Stanojevic · Answer

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.

Mageshwaran R · Answer

Hi Stanojevic, please refer links: https://www.youtube.com/watch?v=iGlvRTxV3Lc https://www.youtube.com/watch?v=6WFZv6F9aGc

Jignesh Kumar · Answer

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]; }

Vuk Stanojevic · Answer

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

Jefferson S. Motta · Answer

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

Vuk Stanojevic · Answer

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.

Jefferson S. Motta · Answer

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];

Vuk Stanojevic · Answer

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

Jefferson S. Motta · Answer

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.