Saving InfoPath Forms to SQL Server 2005 as XML
page 7 of 7
by S.Y.M. Wong-A-Ton
Feedback
Average Rating: 
Views (Total / Last 10 Days): 51635/ 132

Conclusion

In this article you saw how to take advantage of the new XML data type and XML schema collection database object within SQL Server 2005 to save InfoPath forms as strongly typed XML to a database table. With XML schema collections you can define multiple XML schemas on one XML table column and, thus, also save InfoPath forms with different XML schemas to one XML table column.

Due to limitations of XML schema collections in SQL Server, you will not always be able to use typed XML table columns to save your InfoPath forms in, so you may have to resort to using untyped XML table columns.

Finally, you saw how to use an ASP.NET page to submit your InfoPath forms to SQL Server and save them as XML.

 


View Entire Article

User Comments

No comments posted yet.






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


©Copyright 1998-2020 ASPAlliance.com  |  Page Processed at 2020-08-03 10:58:49 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search