Xml file read in dataset in asp.net

Question

Hi I have a xml file. I wann read this xml file in dataset. but arise this error. Nested table 'link' which inherits its namespace cannot have multiple parent tables in different namespaces.  Please help me

Nitin Bhardwaj · Answer

Nested table 'link' which inherits its namespace cannot have multiple parent tables in different namespaces.  Please give solution for this error.

sudipta sanyal · Answer

you have to change your xml file replace air with  i send you your file MYTRIPANDMORE.COM/BAGGAGEDETAILSME.BAGG 30K BAGGAGE DISCOUNTS MAY APPLY BASED ON FREQUENT FLYER STATUS/ ONLINE CHECKIN/FORM OF PAYMENT/MILITARY/ETC. CHGS MAY APPLY IF BAGS EXCEED TTL WT ALLOWANCE CHGS MAY APPLY IF BAGS EXCEED TTL WT ALLOWANCE MYTRIPANDMORE.COM/BAGGAGEDETAILSME.BAGG 30K BAGGAGE DISCOUNTS MAY APPLY BASED ON FREQUENT FLYER STATUS/ ONLINE CHECKIN/FORM OF PAYMENT/MILITARY/ETC. CHGS MAY APPLY IF BAGS EXCEED TTL WT ALLOWANCE CHGS MAY APPLY IF BAGS EXCEED TTL WT ALLOWANCE MYTRIPANDMORE.COM/BAGGAGEDETAILSME.BAGG MYTRIPANDMORE.COM/BAGGAGEDETAILSME.BAGG CARRY ON ALLOWANCE DATA NOT AVAILABLE MYTRIPANDMORE.COM/BAGGAGEDETAILSME.BAGG MYTRIPANDMORE.COM/BAGGAGEDETAILSME.BAGG CARRY ON ALLOWANCE DATA NOT AVAILABLE MYTRIPANDMORE.COM/BAGGAGEDETAILSME.BAGG MYTRIPANDMORE.COM/BAGGAGEDETAILSME.BAGG CARRY ON ALLOWANCE DATA NOT AVAILABLE MYTRIPANDMORE.COM/BAGGAGEDETAILSME.BAGG MYTRIPANDMORE.COM/BAGGAGEDETAILSME.BAGG CARRY ON ALLOWANCE DATA NOT AVAILABLE and if u want to validated your file go to http://www.xmlvalidation.com/

Nitin Bhardwaj · Answer

MYTRIPANDMORE.COM/BAGGAGEDETAILSME.BAGG 30K BAGGAGE DISCOUNTS MAY APPLY BASED ON FREQUENT FLYER STATUS/ ONLINE CHECKIN/FORM OF PAYMENT/MILITARY/ETC. CHGS MAY APPLY IF BAGS EXCEED TTL WT ALLOWANCE CHGS MAY APPLY IF BAGS EXCEED TTL WT ALLOWANCE MYTRIPANDMORE.COM/BAGGAGEDETAILSME.BAGG 30K BAGGAGE DISCOUNTS MAY APPLY BASED ON FREQUENT FLYER STATUS/ ONLINE CHECKIN/FORM OF PAYMENT/MILITARY/ETC. CHGS MAY APPLY IF BAGS EXCEED TTL WT ALLOWANCE CHGS MAY APPLY IF BAGS EXCEED TTL WT ALLOWANCE MYTRIPANDMORE.COM/BAGGAGEDETAILSME.BAGG MYTRIPANDMORE.COM/BAGGAGEDETAILSME.BAGG CARRY ON ALLOWANCE DATA NOT AVAILABLE MYTRIPANDMORE.COM/BAGGAGEDETAILSME.BAGG MYTRIPANDMORE.COM/BAGGAGEDETAILSME.BAGG CARRY ON ALLOWANCE DATA NOT AVAILABLE MYTRIPANDMORE.COM/BAGGAGEDETAILSME.BAGG MYTRIPANDMORE.COM/BAGGAGEDETAILSME.BAGG CARRY ON ALLOWANCE DATA NOT AVAILABLE MYTRIPANDMORE.COM/BAGGAGEDETAILSME.BAGG MYTRIPANDMORE.COM/BAGGAGEDETAILSME.BAGG CARRY ON ALLOWANCE DATA NOT AVAILABLE

Dhirendra Misra · Answer

Hi Nitin Can you please share the structure of your XML? Thanks

Nimit Joshi · Answer

string MyFile = Data.xml; DataSet ds = new DataSet(); ds.ReadXml(MyFile XmlReadMode.InferSchema); foreach (DataTable dt in ds.Tables) { Console.WriteLine(dt); for (int i = 0; i Console.Write(	 + dt.Columns[i].ColumnName.Substring(0 Math.Min(6 dt.Columns[i].ColumnName.Length))); Console.WriteLine(); foreach (var row in dt.AsEnumerable()) { for (int i = 0; i { Console.Write(	 + row[i]); } Console.WriteLine(); } }