Data Connections

Re: Refresh Secondary Data Source Connection via code...

colecg — Mon, 11 Oct 2010 07:08:48 GMT

If you are talking about checking the box "Automatically retrieve data when form is opened" while creating data connection, I have that checked from the begining.

Thank you for your help

Regards,

Amira

Re: Refresh Secondary Data Source Connection via code...

Potemkine — Sun, 10 Oct 2010 14:32:43 GMT

Hi, for the load event, you can just check "automatically retrieve information".

Re: Refresh Secondary Data Source Connection via code...

colecg — Thu, 07 Oct 2010 07:22:57 GMT

I have tried referencing this method from

FormEvents_Loading and from InternalStartup

because I need it to check for new rows on next opening of the form

public void refreshDataSources()

{

for (int i = 0; i < this.DataConnections.Count; ++i)

{

this.DataConnections[i].Execute();

}

Use of button is not an option because I need to bring rows prior to displaying the form to user.

For my own testing purpose I have tried using the button but no luck.

Thank you for your time

Regards

Amira

Re: Refresh Secondary Data Source Connection via code...

Potemkine — Tue, 05 Oct 2010 17:31:13 GMT

Hi, can you check if the items limits in your sharepoint default view is reach ? if yes increase it.

Re: Refresh Secondary Data Source Connection via code...

Hilary Stoupa — Tue, 05 Oct 2010 15:34:16 GMT

You'll need to post your code for people to be able to help you -- what are you currently doing? What is going wrong?

Re: Refresh Secondary Data Source Connection via code...

colecg — Tue, 05 Oct 2010 06:48:39 GMT

Hi.

I am also using InfoPath 2007 and SharePoint 2007 and C# for code behind of InfoPath.

I have tried this but it still does not collect new rows from repeating tables from secodnary sources.

Any help?

Re: Refresh Secondary Data Source Connection via code...

Omar Formacio — Thu, 13 Mar 2008 18:12:11 GMT

Thanks a lot, this was exactly what I was looking for, although I was trying to do this as a possible workaround to a weird error problem I had with InfoPath Forms Services. I had a custom list in SharePoint which name was "Acción"... aparently you can't use a Data Connection to get this list because of the "ó" character :S. I heard there is a hotfix for this, but what I did was to recreate the list without any weird character on its name, and all worked fine.. thanks again for your help.

Omar

Re: Refresh Secondary Data Source Connection via code...

davidair — Wed, 12 Mar 2008 00:37:09 GMT

Assuming you are using InfoPath 2007-style OM (InfoPath 2007 allows you to use both 2003 and 2007 object models, 2007 is preferred) you can (re)query the dataconnection by calling the Execute() method on it. For example, if your connection is called MySharePointListConnection, you can refresh it by calling the following line from your code:

this.DataConnections["MySharePointListConnection"].Execute();

I hope this answers your question.

Re: Refresh Secondary Data Source Connection via code...

Omar Formacio — Wed, 12 Mar 2008 00:16:11 GMT

Thank you for answering so quickly...

I am using InfoPath 2007 and C#.

Omar

Re: Refresh Secondary Data Source Connection via code...

davidair — Wed, 12 Mar 2008 00:11:49 GMT

Hello Omar and welcome to the forums!

It's pretty easy to achieve what you to do, all you need is to get the data connection object in code and call a query method on it. However this will differ between versions of InfoPath.

What version of InfoPath are you using? What language are you writing your custom code in?

Refresh Secondary Data Source Connection via code...

Omar Formacio — Tue, 11 Mar 2008 23:08:47 GMT

Hello,

I have a data connection that recieves data from a sharepoint list. I would like to refresh this secondary data source using custom code :S. I know that I can achieve this by using a refresh button or a query action, but that wont help to what I am trying to do... so, Is there any way to refresh a data connection via code?.

Thanks in advance,

Omar