Tích hợp InfoPath với SharePoint
Tháng Tư 13, 2009 Để lại bình luận
Các bài hướng dẫn về việc tích hợp InfoPath với SharePoint
Integrate InfoPath with SharePoint
Learn how to use rules and filters to automatically fill a repeating table row in InfoPath with data from a SharePoint list when the row is inserted.
Use an XPath expression to count the amount of documents that were submitted today to a SharePoint library.
Check whether the Microsoft.Office.InfoPath.Server.dll and FormServer.aspx files are installed on the server.
Learn how to use a technique that enables users to convert and download Microsoft Office InfoPath 2007 forms directly from Microsoft Office SharePoint Server 2007 form libraries as files in a format that is not XML.
This step-by-step InfoPath tutorial explains how to add a data connection to a SharePoint list or library and then view the structure of the secondary data source in the Data Source task pane.
How to create an InfoPath initiation or association form for a SharePoint workflow created in Visual Studio
Learn which steps are required to create an InfoPath form that can be used as an initiation or association form in a SharePoint workflow that is created using Visual Studio.
This article provides the steps required to publish an InfoPath form template as a new content type on a SharePoint site.
Learn how you can write code in a custom Visual Studio workflow for SharePoint to set the value of a field that is stored within an InfoPath form.
How to simulate Excel’s VLOOKUP function in InfoPath to look up data in a secondary data source using rules and filters
Learn how to use rules and filters to look up data in a secondary data source (here: a SharePoint list) when an item is selected from a drop-down list box and create functionality similar to Excel’s VLOOKUP function, but then in InfoPath.
Programmatically add items from a repeating table in InfoPath to a SharePoint list by submitting a CAML update batch to the UpdateListItems method of the Lists web service that comes with Windows SharePoint Services (WSS).
How to use a SharePoint ItemAdded event handler and the object model to submit data from an InfoPath form to a SharePoint list
This article explains how you can use an ItemAdded event handler on a Form Library to extract data from an InfoPath form that was submitted to the form library and use this data to add a new item to a custom SharePoint list.
This article explains how you can use a custom Visual Studio sequential workflow on a Form Library to extract data from an InfoPath form that was submitted to the form library and use this data to add a new item to a custom SharePoint list.
Use the UpdateListItems method of the Lists web service that comes with Windows SharePoint Services (WSS) to add an item to a SharePoint calendar from within an InfoPath 2007 form.
Programmatically add an item to a SharePoint list by submitting a CAML update batch to the UpdateListItems method of the Lists web service that comes with Windows SharePoint Services (WSS).
Programmatically check whether a value exists in a drop-down list box bound to a SharePoint list using an XPath filter
Learn how to use an XPath filter expression on a SharePoint list to look up a value in a secondary data source to which a drop-down list box in InfoPath is bound.
Programmatically copy rows from a SharePoint list to a repeating node in the Main data source in InfoPath
Learn how to use C# or Visual Basic code to copy the rows from a SharePoint list to a repeating node in the Main data source of an InfoPath form.
Use the System.Net.WebClient class or Copy web service to retrieve an InfoPath form from a SharePoint library.
Use a custom SharePoint workflow to extract a file attachment from an InfoPath form and upload it to a SharePoint document library
This article explains how you can use a custom Visual Studio sequential workflow on a Form Library to extract data from a File Attachment control on an InfoPath form that was submitted to the Form Library and use this data to add a file to a SharePoint Document Library.
Use Rules and Formulas in InfoPath
Calculate the difference between two date picker controls in InfoPath using rules and formulas – no code!
Use rules, conditions, and the number(), floor(), and substring() functions in formulas to calculate the difference between two date picker controls in InfoPath.
Use an Excel workbook published to Excel Services on a Microsoft Office SharePoint Server 2007 to calculate the difference between two dates in InfoPath without writing a single line of code.
Use a rule to display a message box when an item entered into a combo box cannot be found in a list of valid entries.
Forcing users to select a particular day of the week from a date picker in InfoPath using rules and formulas
Use data validation, rules, and the number(), floor(), and substring() functions to derive and check the day of the week when a date is selected from a date picker control in InfoPath.
This article shows you how to use data validation rules in InfoPath to compare two dates and check whether one date falls before another.
This article shows you how to use Data Validation rules or Conditions on Rules in InfoPath to check whether all of the fields in a repeating table on an InfoPath form contain a value.
This article shows how you can create a toggle button in InfoPath using only rules and conditions; no code.
earn how to use a secondary data source, rules, filters, and InfoPath functions to extract the month name from the secondary data source based on the date that is displayed in a date picker control.
This article explains how to use list controls such as drop-down list boxes, combo boxes, list boxes, and multi-select list boxes in InfoPath.
This article explains what Rules are in InfoPath and how you can use them.
Integrate InfoPath with Microsoft Access
Use Microsoft Access’ feature to link a table to a SharePoint list and then use this list as a secondary data source in a browser-compatible InfoPath form.
Integrate InfoPath with SQL Server
Learn how to solve the InfoPath error: InfoPath does not support the specified database. The database must be a Microsoft SQL Server.
Retrieve the XML value of the database field containing the InfoPath form, save it locally as a temporary file, and open it using this.Application.XmlForms.Open().
Use code to retrieve the XML of an InfoPath form from SQL Server 2005, convert the InfoPath form into a MemoryStream object, and load this object into an InfoPath FormControl on a Windows Forms application.
Learn how to temporarily change the Command property of a Receive data connection in InfoPath to execute a SQL Server stored procedure and insert data into a database table.
Write Code for InfoPath
Learn how to take advantage of the 4 overloads of the AppendChild method to programmatically add rows to repeating tables in InfoPath.
Use a combo box control and a web service to automatically type in and add new items to a list, thereby updating the underlying data store of the secondary data source that the combo box is bound to.
This article shows an example of using the Changed event of the row of a repeating table to programmatically autonumber a field in the repeating table using VB.NET code.
Extract and use the document.xml part of a docx file to create an XSLT stylesheet to convert the XML of InfoPath forms into docx files.
Learn how to programmatically count the amount of sections in a repeating section control on an InfoPath form whenever a section is inserted or deleted.
Learn how to use the XML Schema Defintion Tool to generate a class for an InfoPath form.
Learn how to use the Deserialize method of the XmlSerializer class to convert the XML of an InfoPath form into a C# or Visual Basic object.
Learn how to write code to render HTML in a Rich Text Box.
This article shows how you can use Visual Basic .NET code in an event handler on the row of a repeating table to automatically number the rows of the repeating table and then retrieve the number of the row in a repeating table in which the value of a field has been changed.
Use the XPathNodeIterator class with C# or VB.NET code to loop through the rows and items in a repeating table.
Learn how to use the InnerXml property of an XML node to get and set the XHTML code of a Rich Text field on an InfoPath form template.
Learn how you can create a .NET web service that accepts data from the rows of a repeating table on an InfoPath form.
Use the XmlWriter object that is returned by the AppendChild method of the XPathNavigator object to add a row to a repeating table.
Bind the drop-down list box to a repeating node in either the Main or a secondary data source, and then loop through rows of data in another data source to populate the data source that is bound to the drop-down list box.
Use C# code to add DIV elements to apply line-breaks between lines of text in a rich text box field on an InfoPath form.
Learn how to use the WindowsBase DLL and the System.IO.Packaging namespace to export the contents of a Rich Text Box field on an InfoPath form to a Word 2007 document.
Learn how you can use a hidden field and conditional formatting to programmatically hide the first row of a repeating table in InfoPath.
Use the Word 12 (= Word 2007) object model and the 2007 Microsoft Office Add-in: Microsoft Save as PDF to programmatically export an InfoPath 2007 form to PDF.
Use a Console Application and classes in the System.Xml and System.IO namespaces to programmatically generate the XML for the InfoPath form.
Learn how to use C# or Visual Basic code to programmatically delete all of the rows of a repeating table in InfoPath.
Learn how to use C# or Visual Basic code to programmatically delete the first row of a repeating table in InfoPath.
Learn how to add events to rows of a repeating table instead of its fields.
Learn how you can use the Changed event of a repeating node and the DeleteSelf() method to programmatically prevent a user from adding more rows to a repeating table in InfoPath when the repeating table already contains a certain amount of rows.
Learn how to copy items from a secondary data source to a list in the Main data source of a form and then move items between two lists which are bound to two repeating groups in the Main data source of the form template.
Use the Copy XPath functionality to find out what the XPath expression of the field is and the Value property of the XPathNavigator object to retrieve the value of the field.
Programmatically retrieve the value of another field in the same row of a repeating table in InfoPath 2007
Use the Site property of the XmlEventArgs object in the Changed event of a field in a repeating table that is bound to a SharePoint list to retrieve the value of another field in the same row of the repeating table.
Use C# or Visual Basic code to loop through all of the items in the secondary data source a multi-select list box is bound to, and add each item to the DOM node that represents the multi-select list box.
This article shows a simple example of how to use the Open XML Format SDK 2.0 and C# code to convert and add the data from a rich text field and a repeating table to a Word 2007 document (DOCX file).
This article shows you how to use a Microsoft .NET Web Service to retrieve data from a MySQL database and display the data in an InfoPath form.
Learn how you can add default rows to a repeating table in InfoPath, so that when you open the form, the repeating table already contains a certain amount of rows with data.
This article shows you how to use a Microsoft .NET Web Service to submit data from an InfoPath form to a MySQL database.
Frequently Asked Questions (FAQ) about InfoPath 2007 and Forms Server 2007.
Learn how to use InfoPath data types, data validation rules, and rules to check the value of a field in InfoPath.
This article explains how to use rules or code to fill form fields when an InfoPath form is opened or loaded.
This article explains the difference between the Main and secondary data sources and shows you how to programmatically retrieve a reference to the Main data source or to a secondary data source.
This article explains the basics of repeating tables and repeating sections in InfoPath.
Add code to the form to programmatically export the current view of the form to PDF or use the Save As PDF or XPS add-in for Microsoft Office 2007 to export a view.