SharePoint User Group UK

Hi All,

I have created a couple of browser enabled InfoPath forms which read data from a SQL database OK and display the relevant information - took a while!

Anyway now I'm getting very excited (sad I know) and would like to be able to send data back into SQL from my form which users will fill in.  I'll then be able to report on this information etc etc.  I presume using web services is the way to go in this case, has anyone got an idot's guide how to do this?  When I say how to this I mean setting up the webservice, I think I've got the hang of InfoPath design.

Thanks!

Hi

You could submit the data back to the SQL server using the data connecitons you have already created to get the data or if you want to use the web service route these may help give you some idea:

http://weblog.vb-tech.com/nick/archive/2007/01/12/2088.aspx

http://weblog.vb-tech.com/nick/archive/2007/01/17/2100.aspx

---

Andrew Carter
.Net & SharePoint

Hi Andrew,

As the forms are rendered in a browser, I can't save the data back into SQL.  I'll take a look at the web service route links.  Thanks very much!

Regards

Have a look here:

http://blogs.technet.com/elenat/archive/2008/05/13/designing-an-infopath-form-that-can-store-data-in-a-database-part1.aspx

Cool!

Thanks for the info.  I will take a look.

Regards

If you're still working on this one of my collegues has posted on this subject...

See the blog here...or let me know if you need any help...

Rgs,

Steve