----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: kai_275 Message 3 in Discussion SQL sored procedure can return XML in one of the three ways. 1) For XML RAW 2) For XML AUTO 3) For XML Explicit No namespace is generated. You need to append it explicitily. Regards, Kailas Nitin Mekhiya <[EMAIL PROTECTED]> wrote: New Message on MumbaiUserGroup SQLserver - XML read/write - for web service layer Reply Reply to Sender Recommend Message 1 in Discussion From: Nitin Mekhiya hello friends I am working on a functionality related to xml and sqlqerver. Project Has web service interface. So far what i was doing.... I had Class objects for each of My Info entity. (for ex: Employee_class,Student_Class ,,etc) I had data Access layer where i use to fetch datareader and then populate these Info objects. for eg: GetEmployeeList() (method inside Data Access layer) This method would fetch datareader and then I would Create array of Employee class. These outputs of DataAcess layers are given to Web service layer,From here they thrown out. Now what i was searching for ... if i can use XML functionality of SQL server...and instead of fetching datareader as per sql query then run a loop and create array of Employee objects. If i can directly get XML string from sql server ,which is accepted by web service layer and used further to throw required soap for client. Can anyone guide me of how nicely you can do this. Also there are certain issues. like 1)xml string generated by sql query/stored procedure should have proper Namespace tags which are accepted by web service layer Can someone please help me with suggestions/guidance/links for further development. Thanks all Nitin Mekhiya View other groups in this category. Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes ----------------------------------------------------------- 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]
