Xml file read in dataset in asp.net

Nitin Bhardwaj

12y3.5k.NET

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

5 Replies

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

Nitin Bhardwaj12y ago
"Nested table 'link' which inherits its namespace cannot have multiple parent tables in different namespaces. "

Please give solution for this error.
sudipta sanyal12y ago
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 Bhardwaj12y ago

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 Misra12y ago
Hi Nitin,

Can you please share the structure of your XML?

Thanks
Nimit Joshi12y ago
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 < table.Columns.Count; ++i)
Console.Write("\t" + 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 < dt.Columns.Count; ++i)
{
Console.Write("\t" + row[i]);
}
Console.WriteLine();
}
}