XML : Password protected XML using URL to Datase, missing child node

I successfully loaded the password protected XML using Url to Dataset and using Linq to Dataset, I insert it into the database. The difficulty I am facing is one of the child note data is not retrieved from XML to ds/dt. On debug, I find three datatables(column names) - StuDet(Sid, stuExamId,name, StuGradeId, StCount_id); StCount(SId, year, semester, SubjectTypeId, markCount, StCount_id); SubjectTypeCode(SubjectTypeCode_Id, SubjectTypeId, SubjectTypeCode_Id_0,StCount_id)

Code to load XML using URL to Dataset: Code

Below is the xml data: XMLSample

The column StCount_id, SubjectTypeCode_Id, SubjectTypeCode_Id_0 are autogenerated in the datatables.

I couldn't get the SubjectTypeCode (Science, Math, History) into the datatable SubjectTypeCode. Why is that? What am I missing?

Any help or lead would be greatly appreciated. Thanks.

No comments:

Post a Comment