InfoPath Data Connections

Learn how to use InfoPath data connections to databases, XML files, web services, and SharePoint.

Database Connections

Access database connections

Use an Access table as a secondary data source in a browser-compatible InfoPath form

Use Microsoft Access' feature to link a table to a SharePoint list and then use this list as a secondary data source in a browser-compatible InfoPath form.

SQL Server database connections

Connect InfoPath 2010 to a SQL Server 2008 table

Learn how you can create an InfoPath 2010 Filler Form to connect to a SQL Server 2008 database table to view and submit data.

Using a Receive data connection in InfoPath to execute an SQL Server stored procedure

Learn how to temporarily change the Command property of a Receive data connection in InfoPath to execute a SQL Server stored procedure and insert data into a database table.

E-mail Connections

How to send email from an InfoPath browser form in SharePoint

Learn which options are available when you want to send an email through an InfoPath form that is running in InfoPath Forms Services in SharePoint.

Web Service Connections

Web Service connections to a MySQL database

How to get data from a MySQL database into InfoPath using a Web Service

This article shows you how to use a Microsoft .NET Web Service to retrieve data from a MySQL database and display the data in an InfoPath form.

How to submit data from an InfoPath form to a MySQL database using a Web Service

This article shows you how to use a Microsoft .NET Web Service to submit data from an InfoPath form to a MySQL database.

Web Service connections to SharePoint

InfoPath form to upload an image to SharePoint (no code)

Learn how to create an InfoPath form that can upload an image to SharePoint using a web service data connection and rules (no code).

SharePoint List Connections

InfoPath 2007

How to add a data connection to a SharePoint list or library in InfoPath

This step-by-step InfoPath tutorial explains how to add a data connection to a SharePoint list or library and then view the structure of the secondary data source in the Data Source task pane.

Programmatically submit an InfoPath form to a SharePoint library, send an email, and then close the form

This article shows how you can use the FormEvents_Submit event handler to programmatically execute 2 data connections, one to submit to a SharePoint form library and the other to send an email, when submitting an InfoPath browser form, and then close the form afterwards.

InfoPath 2010

InfoPath 2010 SharePoint list data connection

Learn how to add an InfoPath 2010 SharePoint list data connection to a SharePoint list or library.

Display who last modified an InfoPath form in a SharePoint form library

Learn how you can use a reference to the SharePoint form library in which an InfoPath form is stored to find out who was the last person to modify the InfoPath form and display this "last modified by" information on the InfoPath form.

XML File Connections

InfoPath 2007

How to extract the month name from a date picker in InfoPath

Learn how to use a secondary data source, rules, filters, and InfoPath functions to extract the month name from the secondary data source based on the date that is displayed in a date picker control.

InfoPath 2010

Create a data connection to an XML file in InfoPath 2010

Learn how to create a data connection to retrieve data from an XML file that is stored as a resource file in an InfoPath 2010 browser-enabled form template that is to run in InfoPath Forms Services in SharePoint 2010 and filled out through a browser.

Import data from Excel 2010 into InfoPath 2010

Learn how you can convert an Excel 2010 spreadsheet to an XML file so that you can import data from an Excel file into InfoPath 2010.

Video Tutorial: Display Excel 2010 data in InfoPath 2010

 

 Subscribe for updates via RSS or Email
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