Error:

The Web application at http://site/Forms/AllItems.aspx could not be found. Verify that you have typed the URL correctly. If the URL should be serving existing content, the system administrator may need to add a new request URL mapping to the intended application.

at Microsoft.SharePoint.SPSite..ctor(SPFarm farm, Uri requestUri, Boolean contextSite, SPUserToken userToken)

at Microsoft.SharePoint.SPSite..ctor(String requestUrl)

at MOVE.FormCode.CTRL1_5_Clicked(Object sender, ClickedEventArgs e)

at Microsoft.Office.InfoPath.Internal.ButtonEventHost.OnButtonClick(DocActionEvent pEvent)

at Microsoft.Office.Interop.InfoPath.SemiTrust._ButtonEventSink_SinkHelper.OnClick(DocActionEvent pEvent)

/error

I spent the better part of week working on this error. The problem was related to my trying to use InfoPath Forms when I should have been using Browser enabled forms. Once I published the  form and uploaded into to Central Administration I was able to use Managed Code.

This will help you loop through a Repeating Table in InfoPath.  group2 is the name of my Repeating Table. sFunction is a function I use to check if a value has been updated in a SharePoint Library or List. If the value returned from the function does not match what I have in my drop down list, I update it with the function value.

Dim rootX As XPathNavigator = MainDataSource.CreateNavigator
Dim rowX As XPathNodeIterator = rootX.Select(“/my:myFields/my:group1/my:group2”, NamespaceManager)

While rowX.MoveNext
Dim sStatus As String = rowX.Current.SelectSingleNode(“my:field4”, NamespaceManager).Value
Dim sI As String = rowX.Current.SelectSingleNode(“my:field2”, NamespaceManager).Value
Dim sS As String = sFunction(sI)

If sStatus <> sS Then
rowX.Current.SelectSingleNode(“my:field4”, NamespaceManager).SetValue(sS)
End If
End While

Using a combo of a View and Data Connection we will be able to grab ALL of the fields from a List or Library.

1. Open a Text file so you can paste stuff into it.

2. Open the site you want to gather the data from.

3. Navigate to Site Action > Site Settings

4. Under General Settings click on Audience targeting settings. With this page open look at the URL. Starting with the word List, copy everything to the right.

Example: List={515dc5f2-88b9-4f91-80a3-4e133f25d069}

5. Using your Text file, first paste your new List GUID onto the file, next page this string on a another line _vti_bin/owssvr.dll?Cmd=Display&List={GUID}&XMLDATA=TRUE&noredirect=true

6. Now, going back to your List GUID copy everything between the {} brackets. Then paste it into the {GUID} string got from my site, replacing GUID.

Example: _vti_bin/owssvr.dll?Cmd=Display&List={515dc5f2-88b9-4f91-80a3-4e133f25d069}&XMLDATA=TRUE&noredirect=true

7. Go back to your site and paste the long string you just create into the sites URL (see example below for more detail).

Example: http://SiteName/SubSiteName/_vti_bin/owssvr.dll?Cmd=Display&List={515dc5f2-88b9-4f91-80a3-4e133f25d069}&XMLDATA=TRUE&noredirect=true

8. You should now see a page full of XML pertaining to your List or Library.

To take this to the next level you can create a View to narrow down the columns returned in the XML.

1. Create a new View with the fields you want.

2. Edit your newly created view. With the Edit View page open scroll down to Mobile section. Looking at the URL under “Web address for this mobile view:”, grab all the letters and numbers after View=

3. Open this site (http://meyerweb.com/eric/tools/dencoder/) and paste that string into the URL Decoder/Encoder box and click the Decode button.

4. You should now have a cleaner GUID.

5. Paste that new GUID into your Text file.

6. We will now want to join the new GUID with our existing URL string (see below for example).

Example: http://SiteName/SubSiteName/_vti_bin/owssvr.dll?Cmd=Display&List={515dc5f2-88b9-4f91-80a3-4e133f25d069}&XMLDATA=TRUE&noredirect=true&View={8478D19F-831D-45CB-8F24-A481444C5418}

7. You should now see different results than the first URL string we created.

Now the good stuff! Using the URL you can create XML Data Connections in InfoPath and be able to view columns that were once unavailable.

If you are looking for a way to capture the login user name in InfoPath try this.

Dim sUserName As String = System.Enviroment.UserName

If you want to capture user name from SharePoint try this:

http://blogs.microsoft.co.il/blogs/itaysk/archive/2007/04/05/InfoPath-_2D00_-Get-the-current-user-without-writing-code.aspx