Web Services

Re: schema info when submitting to DB with web service

AndersR — Wed, 09 Nov 2005 22:47:17 GMT

I just read up on the subject on both Halsteads book and the thread on usenet that inspired the chapther he wrote on the subject ;-)
http://groups.google.com/group/microsoft.public.infopath/browse_thread/thread/9ebbf91dd9e6ddb/408b9226a914e935?lnk=st&q=infopath+xml+%22web+service%22&rnum=2

Re: schema info when submitting to DB with web service

fredarwin — Tue, 08 Nov 2005 14:13:56 GMT

AndersR,

If u wish have only scheme of your dataset without data, maybe need try using the GetXmlSchema method of dataset and load then in a xmldocument to getback to IP.

xmlDoc.LoadXml(ds.GetXml())
Return xmlDoc

Fred Darwin Villareal

schema info when submitting to DB with web service

AndersR — Tue, 08 Nov 2005 07:55:00 GMT

I am doing a POC on a Data Connection form that submits data to a DB through a web service.

Since i am not retrieving data from the DB there is no way for IP (sp1) to determine the structure of my DB or DataSet.

So my question is:
How do i tell IP how the schema for my deserialized DataSet looks?

An ugly workaround would be to create a retrieving WS also just to get the schema info, but theres gotta be an easier way than that??!

thx
//AndersR

ps: is it possible to subscribe to threads or channels?
the FAQ mentions that this is possible if the moderator turns it on.
It really would be a great time saving feature!