How can I send submissions to existing SQL database when using asp.net?

  • Profile Image
    dannelle_scuba
    Asked on January 12, 2016 at 01:48 PM

    I see you guys provide a tutorial on how to do this exact thing but with php and mysql database. I am working in an asp.net environment and want to replace outdated and broken polls with the ones I created here in Jotform. There is already a database table set up with pretty much the same names for the columns as what is in the poll. Please help, or guide me in the right direction if possible. Thanks!

  • Profile Image
    jonathan
    Answered on January 12, 2016 at 04:16 PM

    Hi,

    The first thing you need to achieve is to be able to POST the submission data so that your SQL web service will be able to import the data to the database.

    #1 How to Send Post Data.

    #2 I found this discussion in the internet about reading Post data in ASP.net

    Alternatively, you can download first the submission data in flat file format like CSV format and then just import the data to your SQL database using import tool from SQL

    #1 http://www.jotform.com/help/103-How-to-create-a-CSV-Report

    #2 You can use SQL tools or services to import the flat file into the SQL database.

    Hope this help. Let us know how we can assist further.