Connect InfoPath master detail to SQL Server Express

Learn how you can connect a master-detail control on an InfoPath 2010 form to two SQL Server 2012 Express database tables that have a one-to-many relationship between them.

You can connect an InfoPath 2010 form to SQL Server, but also to the lightweight version of SQL Server called SQL Server Express. In addition, you can use the Master/Detail control that is available for InfoPath Filler forms to maintain data that is stored in two SQL Server Express database tables that have a one-to-many relationship between them.

The following InfoPath video demonstrates how you can connect InfoPath 2010 to SQL Server 2012 Express and use a master-detail control on an InfoPath form to perform CRUD operations (add, edit, and delete) on data stored in two SQL Server 2012 Express database tables that have a one-to-many relationship between them.

In this InfoPath 2010 tutorial video, you learned...

  • How to add a Master/Detail control to an InfoPath 2010 form template.
  • How to bind a Master/Detail control to two SQL Server Express database tables that have a one-to-many relationship between them.
  • How to configure the repeating tables and repeating sections of a Master/Detail control.
  • How to retrieve data from SQL Server 2012 Express in InfoPath 2010.
  • How to add data to SQL Server 2012 Express from within an InfoPath form.
  • How to edit data in SQL Server 2012 Express from within an InfoPath form.
  • How to delete data from SQL Server 2012 Express from within an InfoPath form.

See more InfoPath 2010 tutorial videos »

 


Related InfoPath Articles:

 

Copyright: This article may not be used on web sites (whether personal or otherwise), copied, disseminated, altered, printed, published, broadcasted, or reproduced in any way without an expressed written consent. The techniques demonstrated in this article may be used within any Microsoft InfoPath project. This article is provided without any warranties. Copyright for this article is non-transferrable and remains with the author.

InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners

InfoPath 2013 Cookbook 2: 121 Codeless Recipes for SharePoint 2013

InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners

InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010

InfoPath 2010 Cookbook 3: 101 Code Recipes for C# Developers

InfoPath 2010 Cookbook 4: 101 Code Recipes for VB Developers

InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services