How to update data source or data connection?

Elena — Wed, 27 Aug 2008 09:43:03 GMT

Hi,

I have an issue.

In an InfoPath 2007 browser enabled form there is a Textbox and ListBox.

In a Textbox you write emails (comma separated), then verification is made programmatically, that there are such emails in database on server (.NET, c#).

Then these emails must be written to the SharePoint list.

Till this moment - no problems, everything works good.

ListBox should be populated from this SP list. I have added the list as a secondary datasourse to the form.

The sequence of actions is the following:

- SP list is created in SP with no code;

- this list is added as a secondary datasource to populate ListBox;

(The first two steps are supposed to be done once).

- you write emails in Textbox;

- press a search button to verify emails and to write them in ListBox;

- verification is made;

- procedure of SP list cleaning is performed to delete all items from list;

- new emails are witten to SPlist;

- this code is performed to execute ListBox population from a secondary data source:

this.DataSources["myDataSource"].QueryConnection.Execute();

The issue is that everything goes as it should be only first time (when a new list created and so on). When trying to do it one more time with the old, but empty SP list, in ListBox another (old) emails are written.

How to solve this problem?

I think that something is not refreshed (data sourse or data connection?), but there are no such methods in DataSource Class or DataConnection Class of Microsoft.Office.InfoPath namespace.

After working with SP list updating is made: myList.Update().

Code

How to update data source or data connection?