----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: BusyWizy Message 4 in Discussion Hi, You could simply load the data from all the tables within one dataset. Then call the "writeXML" method of the dataset to generate a xml file which contains the data from all the tables. To read the same xml data, you could call the "readXML" method on the dataset. Regards, Nauzad Kapadia [MVP] > -----Original Message----- > From: raghuwanshi [mailto:[EMAIL PROTECTED] > Sent: Monday, January 12, 2004 1:27 AM > To: MumbaiUserGroup > Subject: problem regarding XML & DATASET > > ----------------------------------------------------------- > > New Message on MumbaiUserGroup > > ----------------------------------------------------------- > From: raghuwanshi > Message 1 in Discussion > > Dear friends I have probelm regarding DATASET , XML. I have some sql > query which select data from many table like: (1) sql1 = SELECT > Applicant.SponserID, Applicant1.ApplicantName AS > SName,Applicant.ApplicantName AS AName , > convert(varchar(10),Applicant.AuthDate,103) as [Authorization Date], > Branch.BranchName FROM "SOME TABLES" (2) sql2 = SELECT > sum(Receipt.ReceiptAmt) as [SaleAmt],Count(Receipt.ReceiptAmt) as > RecCount, DuesDetail.Lavel, ProductCategory.Category_Name FROM "SOME > TABLES" (3) sql3 = SELECT > ProductCategory.Category_Name,round(sum(DuesDetail.DueAmt),2) as > DueAmt,DuesDetail.Lavel ,Count(*) as NewJoin FROM "SOME TABLES" exexute > sql1 exexute sql2 exexute sql3 I execute all queries separately accoring > to my condition .Then I want to store whole data of all queries in a > single XML file . This 'll provde me big help, whenever I want to accees > data of any Applicant i do not go to on DATABASE i can access data from > XML file . Now my problem is that : How can i create XML file with > Schema which cover all data of all queries? Thankx in advance > raghvendra Mumbai 09892687036 > > ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
