Paul Williams

Paul Williams

  • 2.1k
  • 1
  • 504

form to submit, retrieve, resubmit into SQL DB

Oct 25 2016 11:20 PM
&nbsp;Hello,<p>First&nbsp;time poster, new to C# so looking for a bit guidance&nbsp;from&nbsp;those that know more than I do!&nbsp;</p><div>This involves SharePoint 2013, SQL Server 2012, and a Web Service, so had a bit trouble choosing a category.</div><div>&nbsp;</div><div>I have created a form with InfoPath 2010, it was a blank form, with various drop down&nbsp;boxes etc..&nbsp;What I would like to do it is publish it into SharePoint 2013, and users will fill in the form and hit submit, the data (not the&nbsp;form) will then go into a SQL Database table. </div><div>The users also need to be able to retrieve the form, and if necessary, make changes and resubmit. Now in InfoPath its easy to have a form retrieve or submit, but to be able to do both and resubmit,&nbsp;I need to specify a&nbsp;Web Service.&nbsp;Until yesterday, I&nbsp;knew nothing about Web Services, so from what I&nbsp;understand I need&nbsp;to create one in Visual Studio using C#.</div><div>&nbsp;</div><div>I have Visual Studio Community downloaded (other versions of VS are available&nbsp;to me), I need some guidance on creating a web service to submit and retrieve data to and from the database via the form, but also how it all fits together, and whether I am missing something. </div><div>&nbsp;</div><div>For example once the database is in place&nbsp;and I have published the form, how does the web service bridge the gap? </div><div>If I add the web service to the form, does it follow the form up into SharePoint when I publish it?&nbsp;</div><div>&nbsp;</div><div>If you need any more details to help me out, then I am more than happy to supply them.</div><div>&nbsp;</div><div>Thank you in advance for any help given.</div><div>&nbsp;</div><div>Kind regards,</div><div>P.&nbsp;</div>