Saving InfoPath Forms to SQL Server 2005 as XML
page 1 of 7
Published: 10 Jan 2007
The new XML data type within SQL Server 2005 opens new possibilities for persisting XML data of InfoPath forms. This article discusses and demonstrates how to save entire InfoPath forms to SQL Server 2005 as typed or untyped XML data.
by S.Y.M. Wong-A-Ton
Average Rating: 
Views (Total / Last 10 Days): 40150/ 73


Microsoft SQL Server 2005 introduced a new data type, the XML data type. Now you can associate an XML schema with XML table columns to force them to adhere to constraints defined within the specified schema. Such XML table columns are ideal to save InfoPath forms in, since InfoPath forms are based on XML schemas and have XML data as output.

In this article we will set up a database table that has an XML column associated with the XML schema of an InfoPath form. We will then use an ASP.NET page to submit and save InfoPath forms to the database table. We will also discuss common challenges you may encounter when trying to set up such a solution.

This article assumes that you have experience developing InfoPath forms, working with SQL Server and Internet Information Server, and that you are familiar with C# and ASP.NET.

View Entire Article

User Comments

No comments posted yet.

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2024  |  Page Processed at 2024-07-23 2:28:59 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search