Save submission data in MS SQL Server using ASP.NET.

  • Profile Image
    Robert Alvaro 
    Asked on September 07, 2017 at 01:13 AM

    Hello,

    Is it possible to save/copy data from jotform to Microsoft SQL Server hosted on my local Windows server and do so with ASP.NET or C# - Unfortunately, I am not familiar with PHP.

     

    Thank you,

     

    Rob Alvaro

    SR Programmer

    D&L Loans, LLC

     

  • Profile Image
    ashwin_d
    Answered on September 07, 2017 at 04:48 AM

    Unfortunately there is no inbuilt feature to save your form's submission data to your own MS SQL server database but with a little workaround it is possible to achieve your requirement. Here are the options available:

    #1. You can take advantage of our "MS SQL Server Export" app to export the submission data in SQL file which you can use to import it in your own MS SQL database.

    #2. You can take advantage of our Zapier integration app as well. Please take a look at the following zap: https://zapier.com/zapbook/jotform/sql-server/

    #3. Alternatively, you can POST your form's data to your own ASP.Net page where you can read your form's post data and save it in your MS SQL Server data base. The following guide should help you:  https://www.jotform.com/help/213-Send-Submission-Data-via-Post-Method-and-Thank-You-Settings

    You need to just exclude the PHP code and add your C# or VB.net code in your ASP.Net page to read the POST data.

    Hope this helps.

    Do try it out and get back to us if you have any questions.