Geeks With Blogs

News Locations of visitors to this page
The Out Campaign: Scarlet Letter of Atheism

The content of this site are my own personal opinions and do not represent my employer's/Microsoft view in anyway. In addition, my thoughts and opinions often change, and as a weblog is intended to provide a semi-permanent point in time snapshot you should not consider out of date posts to reflect my current thoughts and opinions

Suresh Veeragoni, working as a Principal Consultant at Sogeti USA LLC (A subsidiary of Capgemini SA Group), developing SOA & BPM solutions for Businesses using Microsoft CSD products (BizTalk, WF, WCF etc)

My Company


QR-Code for my Blog


Suresh Veeragoni's Blog A BizTalker's Blog

If you have created InfoPath forms for simple CRUD operations with SQL Server, have you ever wondered how to refresh the secondary data source which refresh on Submit? InfoPath form provides an action called “Refresh”, but for that you need to use an extra button in the form. The user has to click the Refresh button every time whenever they submit the form, which is not that intuitive, right?!

So, what is the alternative? How do you refresh the secondary data source, which loads the latest values which you just inserted using “Submit”? Here is a simple trick for that.

Instead of using the Database directly, go with the Rules. Here is the screenshot of submit button properties and submit options.


Now, your 1st rule is to submit the data using the main data source.

The second rule should be “Query using a data connection” action, and select the secondary data source for that action.


That’s it! you are done refreshing the secondary data source.

I just gave the numbering for the order of setting windows. yes, you need to go that deep to find that refresh guy!


Posted on Thursday, April 30, 2009 1:39 PM | Back to top

Comments on this post: Refresh Secondary Data Source in InfoPath 2007

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © microsoftian | Powered by: