<div>
You can also try Sharepoint Designer. Create the form in Designer and then configure a connection to the database under Data Source Library. &nbsp;Expand &nbsp;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 <br />
Single Item View<br />
Multiple Item View<br />
Single Item Form<br />
Multiple Item Form<br />
New Item Form<br />
<br />

</div>


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



<div>
<div class="content wysiwyg-content">
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. &nbsp;<br />
<br />
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. &nbsp;<br />
<br />
Can anyone recommend a tool to build this, or an application in Sharepoint that this kind of form can ride on top of? &nbsp;<br />
<br />
Thanks!
</div>
</div>


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?  

Thanks!

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

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.

Programming

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.