Sharepoint App - How to build a form that writes fields from a web/sharepoint app into a SQL database directly

Posted on 2011-04-22
Last Modified: 2012-05-11
I want to build a form for an application in Sharepoint that takes in simple pieces of data (10 at total, some dropdown selections, and some free entry) and writes them into the SQL database.  

I could easily build the form to take pieces of data and turn it into something to print, but we want to get more sophisticated now and write this data into a database so that we can report on it.  

Can anyone recommend a tool to build this, or an application in Sharepoint that this kind of form can ride on top of?  

Question by:jkeegan123
    LVL 9

    Accepted Solution

    LVL 4

    Expert Comment

    You can also try Sharepoint Designer. Create the form in Designer and then configure a connection to the database under Data Source Library.  Expand  the table fields under Data Source Details, choose the fields you want to add to the form and then click the Insert selected fields as option and you can choose
    Single Item View
    Multiple Item View
    Single Item Form
    Multiple Item Form
    New Item Form


    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
    I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
    Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now