load xsd into dataset
-
I created a xsd file using a xml, and then loaded it into a dataset. It created several tables according to the xsd. I notice that each table has a auto-generated column (name ends with ..._id, it looks like the dataset uses these ids to determine the relations between each table). the problem I am having is that when I fill each table in the dataset with data, then write it out to a xml file, the xml file does not come out in the format defined by xsd, e.g. the child element becomes sibling elment of the parent element defined in xsd output xml file will become When I debug it, I find out that the reason is that in dataset, the auto-generated "parentElement" table's id(key) column is updated automatically(0,1,2...), but the "childElement" table's id column is still empty, therefore cause the two table not to "link" to each other(I found out that by adding child table's id column with 0,1,2.., the xml will come out in the correct format). I use adp.fill(ds, "parentElement") and adp.fill(ds, "firstElement") to fill both table, can't figure out why only the parent table's id column is auto-populated not the child one. Please experts help!!
-
I created a xsd file using a xml, and then loaded it into a dataset. It created several tables according to the xsd. I notice that each table has a auto-generated column (name ends with ..._id, it looks like the dataset uses these ids to determine the relations between each table). the problem I am having is that when I fill each table in the dataset with data, then write it out to a xml file, the xml file does not come out in the format defined by xsd, e.g. the child element becomes sibling elment of the parent element defined in xsd output xml file will become When I debug it, I find out that the reason is that in dataset, the auto-generated "parentElement" table's id(key) column is updated automatically(0,1,2...), but the "childElement" table's id column is still empty, therefore cause the two table not to "link" to each other(I found out that by adding child table's id column with 0,1,2.., the xml will come out in the correct format). I use adp.fill(ds, "parentElement") and adp.fill(ds, "firstElement") to fill both table, can't figure out why only the parent table's id column is auto-populated not the child one. Please experts help!!
