Update infopath form in SQL 2005

[esebastian]

Hello All,
I have a windows form built in c# that opens an infopath form and then
saves the xml to the database. THere is also an option to load the form
from the database and this work however if i load a form and then try
to save it back to the database i get an error saying the xml is
missing a ">" tag. If i output the xml it looks like it's well formed
so I have no idea what's going on.. anyone have a clue?
Thanks,
Erin

 

[esebastian]

There is a special way of saving and loading an infoPath form into Sql
.. S.Y.M Wong A Ton has published a couple of great articles about it
that really helped me out. The thing is that you have to preserve the
encoding on the xml document that infopath gives to you and i wasn't
doing that.
Thanks,
Erin

1) how to retrieve infopath form from SQL
http://enterprise-solutions.swits.n...sql-server-display-formcontrol&c=infopath2007

2) how to insert infopath form into SQl
http://aspalliance.com/1106_Saving_InfoPath_Forms_to_SQL_Server_2005_as_XML#Page5

 

[S.Y.M. Wong-A-Ton]

I'm glad my articles helped you. Sorry I did not answer your posts. Since
I've never encountered the errors you got, it was difficult for me to say
what was really causing them.

And thank you for listing the solutions to your problems. I'm sure people
will benefit from them in the future.

Regarding your question: I do not know how you can go about saving the XSN.
The problem is that you have to publish the form before you save the XML to
SQL Server. And the path to the template is saved along with the XML, so the
XSN must physically exist somewhere. If you have SharePoint, you could look
into how SharePoint does it. SharePoint uses SQL Server to store its data,
including forms. I'm not sure, though where the XSNs are located. My guess
would be, also in the database. Perhaps that might give you some clues?

I'll keep mulling over it, and if I get a brilliant idea - I tend to get
those often - I'll let you know or write about it.