Writing xml file from dataset
-
hi all, I have a dataset which has four tables. say for eg, Table A, Table B, Table C and Table D. Table A and Table B are related using PK - FK relation.Table B and Table D are related using PK - FK relation. Table A and Table C are related using PK - FK relation. i need to create a xml file based on these relations. i need to have a node which has the related values of all the tables. I tried using a single query to extract values based on inner joins. but that comes as a single table and the nodes are repeated. or can anybody suggest me how to group two tables into a single node in xml. i can do all this by manually creating a xml file from the dataset. but I am using dataset.WriteXml method to create the xml file. Is there any option to do this?
Thanks in advance.:) Regards Anuradha
-
hi all, I have a dataset which has four tables. say for eg, Table A, Table B, Table C and Table D. Table A and Table B are related using PK - FK relation.Table B and Table D are related using PK - FK relation. Table A and Table C are related using PK - FK relation. i need to create a xml file based on these relations. i need to have a node which has the related values of all the tables. I tried using a single query to extract values based on inner joins. but that comes as a single table and the nodes are repeated. or can anybody suggest me how to group two tables into a single node in xml. i can do all this by manually creating a xml file from the dataset. but I am using dataset.WriteXml method to create the xml file. Is there any option to do this?
Thanks in advance.:) Regards Anuradha
I am also having a problem like that. I have have an XML file, and i created a key in the XML Schema. My problem is that if i load my xml file into a dataset and try to "find[primary]", the compiler generates an exception that there is no primary key defined. Can u help?