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