Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The Infopath document is just a regular XML file, the structure of which matches the data sources you defined in the Infopath form. </p> <p>You just need to access the file via the SharePoint object model, modify it using standard methods (<a href="http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.aspx" rel="nofollow noreferrer">XmlDocument API</a>) and then write it back to the SharePoint list. You must be careful to preserve the structure and insert valid data or you won't be able to open the form using Infopath.</p> <p>You should really check out a book on SharePoint if you plan to do any serious development. Infopath is also a minefield.</p> <p>Object model usage examples: <a href="http://svengillis.blogspot.com/2007/11/coding-against-sharepoint-object-model.html" rel="nofollow noreferrer">here</a>, <a href="http://www.bizsupportonline.net/blog/2009/03/2-ways-loop-through-infopath-forms-sharepoint-form-library/" rel="nofollow noreferrer">here</a> and <a href="http://www.obacentral.com/en/Learn/Recommended%20Reading/Understanding%20the%20SharePoint%20Object%20Model.pdf" rel="nofollow noreferrer">here</a>. The ridiculously incomplete MSDN reference documentation is <a href="http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.aspx" rel="nofollow noreferrer">here</a>.</p> <p><strong>EDIT</strong>: here is some example code. I haven't done SharePoint for a while so I'm not sure this is 100% correct, but it should give you enough to get started:</p> <pre><code>// Open SharePoint site using (SPSite site = new SPSite("http://&lt;SharePoint_Site_URL&gt;")) { using (SPWeb web = site.OpenWeb()) { // Get handle for forms library SPList formsLib = web.Lists["FormsLib"]; if (formsLib != null) { SPListItem itm = formsLib.Items["myform.xml"]; // Open xml and load it into XML document using (Stream s = itm.File.OpenBinary ()) { MemoryStream ms; byte[] xmlData; XmlDocument xml = new XmlDocument (); xml.Load (s); s.Close (); // Do your stuff with xml here ... // Get binary data for new XML xmlData = System.Text.Encoding.UTF8.GetBytes (xml.DocumentElement.OuterXml); ms = new MemoryStream (xmlData); // Write data to sharepoint item itm.File.SaveBinary (ms); ms.Close (); itm.Update (); } } web.Close(); } site.Close(); } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POProgramatically Edit Infopath Form Fields?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USaxel_c
    1. USaxel_c
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COcan u please explain me with some code. I am unable implement that. How can i get xml data from infopath file.
      singulars
      1. PO
      1. USSusanthi
    2. COitem.update() is giving me error saying that the file has been modified by SHAREPOINT\system on 28 Dec 2009 ect.. Then that infopath file is not opening because of these changes
      singulars
      1. PO
      1. USSusanthi
    3. COTry removing the update() call and see if it works. We did something similar to this for a project and it worked, but I don't have the code at hand to look it up.
      singulars
      1. PO
      1. USaxel_c
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload