DataSet ReadXml to skip autoid

Reply

Participant

1041 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

47661 Points

20887 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

Participant

1190 Points

532 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

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

DataSet ReadXml to skip autoidRSS

2 replies

Shortcuts

DataSet ReadXml to skip autoid

Re: DataSet ReadXml to skip autoid

Re: DataSet ReadXml to skip autoid