Friday, October 21, 2011

Infopath Code

Here are some important codes for InfoPath. 

Get Parameters in InfoPath Form:

if (e.InputParameters.ContainsKey("SaveLocation")) // Search for Query string (parameter) if found then set this parameter to a field.
                    SetFormFieldValue ("/my:ChangeOrder/my:SectionHide/my:ListURL", e.InputParameters["SaveLocation"].Substring(0, e.InputParameters["SaveLocation"].LastIndexOf("/")));

Get Value from a field:

private string GetFormFieldValue(string fieldName)
            string fieldValue = string.Empty;
                XPathNavigator myNav = MainDataSource.CreateNavigator().SelectSingleNode(fieldName, NamespaceManager);
                if (myNav != null)
                    fieldValue = myNav.Value; ;

                if (string.IsNullOrEmpty(fieldValue))
                    return string.Empty;
                    return fieldValue;
            catch { return fieldValue; }

Set Value for a field:

private void SetFormFieldValue(string fieldName, string fieldValue)
            XPathNavigator myNav = MainDataSource.CreateNavigator().SelectSingleNode(fieldName, NamespaceManager);
            if (myNav != null)
                myNav.SetValue(fieldValue); ;

Submit form programmatically:

FileSubmitConnection fileSubmit = (FileSubmitConnection)this.DataConnections["SharePoint Library Submit"]; // SharePoint Library Submit is name of my submit connection.
// Relative the SharePoint Submit location to current SharePoint site.
fileSubmit.FolderUrl = GetFormFieldValue("/my:ChangeOrder/my:SectionHide/my:ListURL"); // This is form saving path, Where I want to save my form programmatically.

Execute Query Programmatically:

DataSources["Project Category"].QueryConnection.Execute(); //Project Category is name of my data connection.
                DataSources["Users"].QueryConnection.Execute();//Users is name of my data connection.

Programmatically read rows from reapting table :

//I have added a section called ServicesSection then a reaping table with name of ServiceTask and then provided name to the reapting group-ServiceTaskTable. I have created three fields in this reaping table.
XPathNavigator root = MainDataSource.CreateNavigator();
                XPathNodeIterator rows = root.Select("/my:myFields/my:ServicesSection/my:ServiceTask/my:ServiceTaskTable", NamespaceManager);
while (rows.MoveNext())
                    sHrs = GetFieldValue(rows.Current, "my:Hours");
                    sMinutes = GetFieldValue(rows.Current, "my:Minutes");
                    sActivityDetails = GetFieldValue(rows.Current, "my:ActivityDetails");

Tuesday, October 4, 2011

Download Infopath Form Templates


I have lots of InfoPath forms with me which are downloaded from lots of places. I am uploading this InfoPath form collection for all InfoPath and SharePoint Users. These form are related to Infopath 2003, 2007 & 2010.

Click here to download InfoPath Form Collection