DataSet ReadXml to skip autoid

Reply

Participant

1042 Points

DataSet ReadXml to skip autoid

Mar 31, 2020 03:39 PM|krisrajz|LINK

I have an xml file like the below one, read the file using DataSet.ReadXML method, and returns dataset with tables with additional column Criteria_Id which is breaking the application. How can I determine a column has been automatically added? or How can I stop autogenerating such columns??

Regards,
Raj

Remember to click Mark as Answer on the post that helps to others.

Reply

mgebhard

All-Star

53041 Points

23619 Posts

Re: DataSet ReadXml to skip autoid

Mar 31, 2020 03:57 PM|mgebhard|LINK

There is no Criteria_Id in the XML shown. Can you share the error message or enough code to reproduce this issue?

Reply

yij sun

Contributor

3730 Points

1420 Posts

Re: DataSet ReadXml to skip autoid

Apr 01, 2020 08:14 AM|yij sun|LINK

Hi krisrajz,

Accroding to your description and codes,as far as I think,when you use dataset readxml method to read the file,it will create another tabel because of the repeat node base on the dependencies of dataset.So ,I suggest you could preloaded dataset to datatable and set XmlReadMode to be auto or IgnoreSchema.

Besides,I suggest you best to use linq to xml.Duplicate nodes are not allowed in dataset.

More details,you could refer to below codes:

DataSet ds = new DataSet();
            DataTable dt = new DataTable();
            dt.Columns.Add("ProfRegion", typeof(string));
            dt.Columns.Add("ProfDGOffice", typeof(string));
            dt.Columns.Add("ProfDGOrgUnit", typeof(string));
            dt.Columns.Add("Approver_txt", typeof(string));
            dt.Columns.Add("PA", typeof(string));
            dt.Columns.Add("TimeStatus", typeof(string));
            dt.Columns.Add("ProfCategory", typeof(string));
            dt.Columns.Add("ProfType", typeof(string));
            dt.Columns.Add("Exemptstatus", typeof(string));
            dt.Columns.Add("NationalPractice", typeof(string));
            dt.Columns.Add("TimePrd", typeof(string));
            dt.Columns.Add("StartDate", typeof(string));
            dt.Columns.Add("EndDate", typeof(string));
            dt.Columns.Add("WebServerReportPath", typeof(string));
            dt.Columns.Add("Prof_txt", typeof(string));
            dt.Columns.Add("RequireFollowup", typeof(string));
            dt.Columns.Add("ShowMissingTime", typeof(string));
            dt.Columns.Add("ProfStatus", typeof(string));

            ds.Tables.Add(dt);
            ds.ReadXml(Server.MapPath("XMLFile4.xml"),XmlReadMode.IgnoreSchema);

            DataTable dt = ds.Tables[0];

More details,you could refer to below article:

https://docs.microsoft.com/en-us/dotnet/csharp/programming-guide/concepts/linq/linq-to-xml-overview

Best regards,

Yijing Sun

.NET forums are moving to a new home on Microsoft Q&A, we encourage you to go to Microsoft Q&A for .NET for posting new questions and get involved today.

DataSet ReadXml to skip autoid RSS

2 replies

Shortcuts

DataSet ReadXml to skip autoid

Re: DataSet ReadXml to skip autoid

Re: DataSet ReadXml to skip autoid