Skip to main content

Differences between Main Vs.Secondary Data Sources in Infopath

This article explains the difference between the Main and secondary data sources and shows you how to programmatically retrieve a reference to the Main data source or to a secondary data source.

Introduction to data sources

InfoPath offers two types of data sources: Main and secondary. An InfoPath form template always contains one Main data source and can contain zero or more secondary data sources.

The difference between the Main and secondary data sources

The Main data source of a form contains the data that you want to permanently store when you save the form. A secondary data source on the other hand, is a temporary storage location for data that is external to the form. Such data typically lives outside the form in databases, XML files, SharePoint lists or libraries, or can be retrieved from web services.
When you save a form, the data in the secondary data sources of the form is never saved in the form. This is an important fact to remember when you design InfoPath form templates. Therefore, if you want data to be present in a form after you save, close, and re-open the form, you have to store this data in the Main data source of the form. How to create data sources

You automatically create a Main data source when you create an InfoPath form template. You can create a secondary data source by adding a Receive or Submit data connection to a form template. You can add a data connection to a form template by going to the Tools menu and selecting Data Connections.

How to view data sources

You can use the Data Source task pane to view Main and secondary data sources in a form template. If the Data Source task pane is not visible, click Data Source on the View menu to bring it up. The Data Source drop-down list box will contain the text Main for the Main data source and a data connection name followed by the text (Secondary) for a secondary data source (see Figure 1).


Figure 1. Data source task pane in InfoPath

Programmatically get a reference to the Main data source

If you are writing code and want to programmatically get a reference to the Main data source of your form template, you can use the following C# code
XPathNavigator mainDS = MainDataSource.CreateNavigator();
Or the following Visual Basic code:

Dim mainDS As XPathNavigator = MainDataSource.CreateNavigator() You can then use the XPathNavigator object to get or set values of fields (= nodes in the XML) on the form.
Programmatically get a reference to a secondary data source
If you are writing code and want to programmatically get a reference to a secondary data source that receives data in your form template, you can use the following C# code:

XPathNavigator secDS = DataSources["your_receive_data_connection_name"].CreateNavigator();

Or the following Visual Basic code:

Dim secDS As XPathNavigator = DataSources
You can then use the XPathNavigator object to get or set values of fields (= nodes in the XML) of the secondary data source

Comments

  1. AnonymousJune 1, 2011 at 11:29 PM

    How can you do this in JS??

    ReplyDelete
  2. AnonymousMarch 4, 2013 at 4:20 PM

    I don't even know how I stopped up right here, however I believed this put up was once good. I do not realize who you're however certainly you
    are going to a well-known blogger if you happen to aren't already. Cheers!

    Here is my web blog - ketone diet

    ReplyDelete
  3. MaryNovember 11, 2025 at 10:32 PM

    This is a helpful guide for understanding and working with data sources in InfoPath.

    ReplyDelete

Post a Comment

Popular posts from this blog

Tab Control in Asp.Net

Scenerio: I need your help in designing tab control in   asp.net .My requirement is I need a tab control in   asp.net (C#) like  for example goto my computer ,right click c drive and select properties.we get tabs like general,security etc....... like that i need to design one tab control(no need of any rightclick) in my web page and the database table columns should come as tabs and inseide the tab data of that particular column should come.   Example:Employee master tab1:Employee name.........his name in the tab tab2:Age.............his age tab3:Address........his address   Solution:   You can do this using a simple div <style type="text/css"> .tabs         {             position: relative;             height: 20px;             margin: 0;   ...
Post a Comment
Read more

AI and Microsoft: Revolutionizing Efficiency in Nonprofit Organizations

  How AI and Microsoft Enhance Efficiency in Nonprofit Organizations In today’s fast-paced world, nonprofit organizations face unique challenges—limited resources, increasing demands, and the constant need to do more with less. But what if technology could be the game-changer they need? In my latest research paper,  "How AI and Microsoft Enhance Efficiency in Nonprofit Organizations" , I explore how cutting-edge technologies like Artificial Intelligence (AI) and Microsoft’s innovative tools are revolutionizing the way nonprofits operate. From streamlining administrative tasks to enhancing donor engagement and optimizing resource allocation, AI and Microsoft’s solutions are empowering nonprofits to focus on what truly matters—their mission. This paper dives deep into real-world examples, practical applications, and the transformative potential of these technologies. Whether you’re a nonprofit professional, a tech enthusiast, or simply curious about the intersection of technolo...
Post a Comment
Read more

Social tagging overview in Sharepoint 2010

A tag is a word or phrase that identifies an individual piece of information according to a set of attributes or criteria. Tags make it easy to find and share information about a specific subject or task. Social tagging helps users categorize information in ways that are meaningful to them. Social tagging can improve the quality of search results by filtering against specific tags, and it can also connect individuals who want to share information with other users who have like interests. This article describes the social tagging features in Microsoft SharePoint Server 2010. This article does not describe how to configure social tagging features. It also does not discuss how to implement social tagging features as part of an overall social media strategy for an enterprise. About using social tagging features Social tagging features help users to share information and to retrieve relevant, high-quality content more efficiently. Such sharing encourages collaboration and b...
295 comments
Read more