With Google, I did a very very long search on how to use Adobe LiveCycle Designer to design Interactive/Dynamic Forms, and publish them to the IIS Server and used ASP.NET to populate such forms with field values from back-end Database such as SQL Server.
The solution mentioned in this post above may work, but I am not comfortable with using such approach, it is very complex.
We are designing and implementing Electronic Forms that must detect the user currently logged in to the Windows Intranet (under IIS), and should perform a Look-up to the Back-End Database to extract the User Related Data and Populate the Form Fields to start the Form Processing.
I finally found that the product "Adobe LiveCycle® Designer add-in for Microsoft Visual Studio .NET" from
www.ensemble.com seems to be the Answer.
So I download the add-in, but I did not find enough documentation to tell me how to use it. I also noticed that I may need to install Adobe LiveCycle Forms Server to make this work. At the time being, Adobe LiveCycle Forms Server is not on our budget yet. We will assume at this point in time, that the users will have the required Adobe Acrobat version on the Client PC.
Also, I tried to use the Add-In from Visual Studio Prof 2005, and when I try to Add New Item to an exiting Project or Website, I cannot find the template "Adobe Designer Form". By chance, I was able to add this Item only when I try to add to a Solution (where you have to have 2 projects open at the same time). Could you please clarify this part ?
Do you think this add-in satisfy our requirements ?
Do you have any recommendations on how to implement such requirement ?
It seems to me that the recommended way it write a program in ASP.NET to detect the Current Windows User ID, and perform a Query to the back-end Database and generate the required XML Schema and Data Files, and connect them to the Adobe Form and Render the form back to the Client. Is this possible ? How ?
Your feedback will be highly appreciated.