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

  • Robert Alvaro
    Asked on September 7, 2017 at 1: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

     

  • Ashwin JotForm Support
    Replied on September 7, 2017 at 4: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.