Dynamic forms

[Elmer Miller]

I would like to be launch InfoPath from an ASP.NET application and have it
load a new form pre-populated with data from SQL. I'm having problems. I can
easily open a blank form from a hyperlink. Or I can use the data
capabilities of InfoPath to load data from SQL when a form opens, but I need
a way to pass a parameter to the form so that it knows what data to load. It
would be nice if I could somehow dynamically generate the xml for the form
from ASP and then redirect to it. Do I need to create a physically file for
this to work?

 

[Elmer Miller]

I found another (I think better) way to solve this. My solution involves
using SQLXML 3.0 to dynamically produce a correctly formatted XML document
for the form. I use an XPath template query to get the raw data, then use an
XSL style sheet to get it formatted correctly. This method has the benefit
of not requiring the form to update itself when it loads, thus eliminating a
roundtrip and enhancing performance. Also this method scales well and
eliminates bottlenecks of reading/writing a physical XML file.

A solution to this was posted on 2004.05.13:
http://groups.google.com/[email protected]

--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com



I would like to be launch InfoPath from an ASP.NET application and have it
load a new form pre-populated with data from SQL. I'm having problems. I can
easily open a blank form from a hyperlink. Or I can use the data
capabilities of InfoPath to load data from SQL when a form opens, but I need
a way to pass a parameter to the form so that it knows what data to load. It
would be nice if I could somehow dynamically generate the xml for the form
from ASP and then redirect to it. Do I need to create a physically file for
this to work?