Xml Issue ?In C# console or windows forms

Question

Hi
This is very important assignment i tried tried getting struck dam dam ..
Experts just need to sort this issue plz .
Please check the attachment provided :) XML file attached
What is need is very simple :
In XML file there are
-<ENTITIES>
+<ENTITIES ACTION>
+<ATTRIBUTES>
+<VALUES>
.
.
.
.
+<ENTITIES ACTION>
+<ATTRIBUTES>
+<VALUES>
</ENTITIES>
The thing i need is looks simple but i am feeling a bit complex ..
In the attachment file there is Entity Action Tag right Under that we have many tag key-value pairs .. In that what i need is when i input to text boxes or a method in console like "LONGNAME" & "CATEGEORYNAME" .. I need to get all the details of those inc those values in some manner like CATEGEORYNAME: APPAREL ... All key value pair under the matched Entities ACTION ..
Second Thing is When i dig even deeper like given "LONGNAME" & "CATEGEORYNAME" & also "NAME" which is under attributes I JUST NEED to get the value ...
Hope i made clear so everyone can understand .
Cheers
Have a nice day

Vulpes · Answer

OK I'm clear on the filtering point though I'm not clear on the other point as I don't see anything within the Value node which could tell us whether APPLY VAT is true or false. For now I've hard-coded it to give the output you wanted: using System; using System.Linq; using System.Xml.Linq; class Program { static void Main() { Console.Write(Enter LONGNAME value : ); string lName = Console.ReadLine(); Console.Write(Enter CATEGORYNAME value : ); string cName = Console.ReadLine(); Console.WriteLine(); XElement Data = XElement.Load(xmldata.xml); //lName = Auto_TS8_DELTAMODE_01; //** uncomment for hard-code test //cName = Apparel; // ** uncomment for hard-code test var query = from el in Data.Element(Entities).Elements(Entity) where el.Attribute(LongName).Value == lName && el.Attribute(CategoryName).Value == cName select el; if(query.Count() == 0) { Console.WriteLine(There are no nodes with those values); return; } foreach(XElement el in query) { foreach(XAttribute at in el.Attributes()) { Console.WriteLine({0} : {1} at.Name at.Value); } Console.WriteLine(); foreach(XElement el2 in el.Element(Attributes).Elements(Attribute)) { XAttribute at1 = el2.Attribute(Name); XAttribute at2 = el2.Attribute(LongName); if(at1.Value == status && at2.Value == Status) { Console.WriteLine( APPLY VAT: TRUE .); } else { Console.WriteLine( {0} : {1} at1.Name at1.Value); Console.WriteLine( {0} : {1} at2.Name at2.Value); } } Console.WriteLine(); } Console.ReadKey(); } }

SUNIL GUTTA · Answer

Humm yes :) its working mate .. .. You been so helpful :) Yes you used link right :) Nice one .. .. I just have some xml files with more attributes .. Will test it and any issues will get back to you . Thank you so so much Have a nice day

Vulpes · Answer

OK I think I've finally got it :) using System; using System.Linq; using System.Xml.Linq; class Program { static void Main() { Console.Write(Enter LONGNAME value : ); string lName = Console.ReadLine(); Console.Write(Enter CATEGORYNAME value : ); string cName = Console.ReadLine(); Console.WriteLine(); XElement Data = XElement.Load(xmldata.xml); //lName = Auto_TS8_DELTAMODE_01; //** uncomment for hard-code test //cName = Apparel; // ** uncomment for hard-code test var query = from el in Data.Element(Entities).Elements(Entity) where el.Attribute(LongName).Value == lName && el.Attribute(CategoryName).Value == cName select el; if(query.Count() == 0) { Console.WriteLine(There are no nodes with those values); return; } foreach(XElement el in query) { foreach(XAttribute at in el.Attributes()) { Console.WriteLine({0} : {1} at.Name at.Value); } Console.WriteLine(); foreach(XElement el2 in el.Element(Attributes).Elements(Attribute)) { XAttribute at1 = el2.Attribute(Name); XAttribute at2 = el2.Attribute(LongName); Console.WriteLine( {0} : {1} at1.Name at1.Value); Console.WriteLine( {0} : {1} at2.Name at2.Value); XCData xcd = (XCData)el2.Element(Values).Element(Value).FirstNode; Console.WriteLine( {0} : {1} at2.Value.ToUpper() xcd.Value.ToUpper()); Console.WriteLine(); } Console.WriteLine(); } Console.ReadKey(); } } The output is : Id : 39 ExternalId : Auto_TS8_DELTAMODE_01 LongName : Auto_TS8_DELTAMODE_01 EntityTypeId : 21 EntityTypeName : product ContainerId : 5 ContainerName : product Master OrganizationName : river Works CategoryId : 1 CategoryName : Apparel CategoryLongName : Apparel CategoryPath : Apparel CategoryLongNamePath : ParentEntityId : 1 ParentExternalId : Apparel ParentExtensionEntityId : 0 ParentExtensionEntityExternalId : ParentExtensionEntityContainerId : 0 ParentExtensionEntityContainerName : ParentExtensionEntityCategoryId : 0 ParentExtensionEntityCategoryPath : ParentExtensionEntityCategoryLongNamePath : Locale : en_WW Action : Add Name : apply VAT LongName : Apply VAT APPLY VAT : FALSE Name : status LongName : Status STATUS : NEW

SUNIL GUTTA · Answer

UNDER 1ST ENTITY ACTION under 1st node : ----It means FALSE . so APPLY VAT: FALSE under 2nd node : ----- output should be NEW . so Status : NEW Like that it goes on for N number of entity action nodes under entity ... Thank you for help .. ..

SUNIL GUTTA · Answer

Humm ty vulpes . Humm actually in your output u displayed the XML contents like key valued-pairs .. Humm yes i need just that but some what different .. I need to provide the input like LONGNAME value  CATEGEORY NAME value .. On combination of both I need to filter which ENTITY ACTION WE ARE DEALING .. ex : If we give LONGNAME : Auto_TS8_DELTAMODE_01 & CategoryName : Apparel The output should be like : Id : 39 ExternalId : Auto_TS8_DELTAMODE_01 LongName : Auto_TS8_DELTAMODE_01 EntityTypeId : 21 EntityTypeName : product ContainerId : 5 ContainerName : product Master OrganizationName : river Works CategoryId : 1 CategoryName : Apparel CategoryLongName : Apparel CategoryPath : Apparel CategoryLongNamePath : ParentEntityId : 1 ParentExternalId : Apparel ParentExtensionEntityId : 0 ParentExtensionEntityExternalId : ParentExtensionEntityContainerId : 0 ParentExtensionEntityContainerName : ParentExtensionEntityCategoryId : 0 ParentExtensionEntityCategoryPath : ParentExtensionEntityCategoryLongNamePath : Locale : en_WW Action : Add Name : apply VAT LongName : Apply VAT Name : status ---------------------> ISSUE IS RIGHT HERE .. LongName : Status ---------------------> IN THIS I NEED VALUE ... - - APPLY VAT: TRUE . So final out pit should look like : The output should be like : Id : 39 ExternalId : Auto_TS8_DELTAMODE_01 LongName : Auto_TS8_DELTAMODE_01 EntityTypeId : 21 EntityTypeName : product ContainerId : 5 ContainerName : product Master OrganizationName : river Works CategoryId : 1 CategoryName : Apparel CategoryLongName : Apparel CategoryPath : Apparel CategoryLongNamePath : ParentEntityId : 1 ParentExternalId : Apparel ParentExtensionEntityId : 0 ParentExtensionEntityExternalId : ParentExtensionEntityContainerId : 0 ParentExtensionEntityContainerName : ParentExtensionEntityCategoryId : 0 ParentExtensionEntityCategoryPath : ParentExtensionEntityCategoryLongNamePath : Locale : en_WW Action : Add Name : apply VAT LongName : Apply VAT APPLY VAT: TRUE . I hope you understand . . . . . Regards

Vulpes · Answer

TBH I'm not 100% clear what's wanted but try this: using System; using System.Xml.Linq; class Program { static void Main() { XElement Data = XElement.Load(xmldata.xml); foreach(XElement el in Data.Element(Entities).Elements(Entity)) { foreach(XAttribute at in el.Attributes()) { Console.WriteLine({0} : {1} at.Name at.Value); } Console.WriteLine(); foreach(XElement el2 in el.Element(Attributes).Elements(Attribute)) { foreach(XAttribute at in el2.Attributes()) { if (at.Name == Name || at.Name == LongName || at.Name == CategoryName) { Console.WriteLine( {0} : {1} at.Name at.Value); } } Console.WriteLine(); } } Console.ReadKey(); } } The output is: Id : 39 ExternalId : Auto_TS8_DELTAMODE_01 LongName : Auto_TS8_DELTAMODE_01 EntityTypeId : 21 EntityTypeName : product ContainerId : 5 ContainerName : product Master OrganizationName : river Works CategoryId : 1 CategoryName : Apparel CategoryLongName : Apparel CategoryPath : Apparel CategoryLongNamePath : ParentEntityId : 1 ParentExternalId : Apparel ParentExtensionEntityId : 0 ParentExtensionEntityExternalId : ParentExtensionEntityContainerId : 0 ParentExtensionEntityContainerName : ParentExtensionEntityCategoryId : 0 ParentExtensionEntityCategoryPath : ParentExtensionEntityCategoryLongNamePath : Locale : en_WW Action : Add Name : apply VAT LongName : Apply VAT Name : status LongName : Status Id : 45 ExternalId : Auto_TS8_DELTAMODE_02 LongName : Auto_TS8_DELTAMODE_02 EntityTypeId : 21 EntityTypeName : product ContainerId : 5 ContainerName : product Master OrganizationName : river Works CategoryId : 1 CategoryName : Apparel CategoryLongName : Apparel CategoryPath : Apparel CategoryLongNamePath : ParentEntityId : 1 ParentExternalId : Apparel ParentExtensionEntityId : 0 ParentExtensionEntityExternalId : ParentExtensionEntityContainerId : 0 ParentExtensionEntityContainerName : ParentExtensionEntityCategoryId : 0 ParentExtensionEntityCategoryPath : ParentExtensionEntityCategoryLongNamePath : Locale : en_WW Action : Add Name : apply VAT LongName : Apply VAT Name : status LongName : Status

SUNIL GUTTA · Answer

First of all let me ty for reply and its been helpful . But thing is need to display information in listbox or what ever in key-value pairs so ..so one ca neatly recognize whats present in which . In the attachment i.e when typing longName i am getting wrong results .. Actually i planned i.e keeping 2 textboxes so i can enter LONGNAME & CATEGORYNAME .. SO IT JUST acts as a composite key in sql server will only fetch data of all Attributes where the given textbox input matches ... Output should be in key valued pairs .. Anyway as you said it definately a start i can hope on .. Ty for help .

Frogleg · Answer

Here's a start