How to update data source or data connection? - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

How to update data source or data connection?

Last post 08-27-2008 02:43 AM by Elena. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 08-27-2008 02:43 AM

    • Elena
    • Not Ranked
      Female
    • Joined on 05-15-2008
    • Russia
    • Posts 14

    How to update data source or data connection?

    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().

     

Page 1 of 1 (1 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.