Infopath form service uses WSS Web Service technology to write complex forms to the Sharepoint list database through vsta code

Various Forms in enterprises are the most appropriate application of infopath, but some people complain that infopath is not flexible enough. They admit that using infopath to design forms can efficiently design the most beautiful forms, however, it is a headache to combine the designed form with the database and the list. An infopath form that includes complex "repeated tables" is a file in the list library. How can we collect and summarize each row of data records in the form separately? Next we will give you the best answer to this question.

Application Scenario: "customer management ":

: [Customer database: new form page]

For example, there are separate fields and duplicate tables. Repeat the table contact information and write it to the contact information table ].

We use two databases, one infopath form library, to store forms, to provide a data entry interface (Operator Interface), and one list library to store records in the form, to provide functions such as statistics and analysis (querying databases ). Then, use vsta to write code in the "Submit" form of infopath. This Code provides two functions: 1. submit the form to the form library. 2. Submit the contact information of each row in the form to another list Library (for convenience, the Customer simply needs to repeat the information stored in each row of records ). This structure is similar to the infopath + SQL method, but SQL is troublesome. I changed it to the List library. Because the list library has a ready-made webserivce available.

Customer database [Form database ]:

[Contact information] list (storing repeated table records of [contact information] In the customer database ):

This article is the result of my hard work. Please mark the source for reprinting. Piracy is necessary.

[Related articles :]

Infopath2007 form templates with managed code are published to the SharePoint form library (viewed in a browser)

[Reference :]

[Infopath Application Scenario: Inventory Management] Using WSS Web Service technology in infopath form service, complex forms are written to the Sharepoint list database using vsta code (1)

[Download source code and form csdn :]

Http://download.csdn.net/source/1794546