ASP.NET, SQL Server, LiveCycle

[Former Community Member]

Hi,



We have created PDF forms using LiveCycle. We have an ASP.NET application written in C#, and a SQL Server 2000 back-end database. We would like to display the PDF forms using ASP.NET, let users enter data in the forms, and then store the data in SQL Server.



Is there any documentation, instructions, or tutorials that describe how to do this?



Richard

[Former Community Member]

I would also like any information regarding this, although my version of MSSql is 2005.

[Former Community Member]

Hello,



Yes, I agree with the first 2 responders and would like info on this. I'm working with SQL Server 2005 and I'm also a CTP for SQL Server 2008, so any info would be useful. Thanks.

[Former Community Member]

To preload the form:<br /> Response.ContentType = "application/vnd.adobe.xdp+xml" <br /> responseString.Append("<?xml version='1.0' encoding='UTF-8'?>") <br /><br /> responseString.Append("<?xfa generator='AdobeDesigner_V7.0' APIVersion='2.2.4333.0'?>") <br /> responseString.Append("<xdp:xdp xmlns:xdp='http://ns.adobe.com/xdp/'>") <br /> responseString.Append("<xfa:datasets xmlns:xfa='http://www.xfa.org/schema/xfa-data/1.0/'>") <br /> responseString.Append("<xfa:data>") <br /><br /> responseString.Append("<form1>") <br /> responseString.Append("<txtFirstName>Homer</txtFirstName>") <br /> responseString.Append("<txtLastName>Simpson</txtLastName>") <br /> responseString.Append("</form1>") <br /><br /> responseString.Append("</xfa:data>") <br /> responseString.Append("</xfa:datasets>") <br /> responseString.Append("<pdf href='http://localhost/PDFFiller/TestForm.pdf' xmlns='http://ns.adobe.com/xdp/pdf/' />") <br /> responseString.Append("</xdp:xdp>") <br /><br /> Response.Write(responseString) <br /> Response.Flush() <br /> Response.End() <br />-------------------------------------------------------------<br />To read the submited data:<br /><%@ LANGUAGE=VBScript %> <br /><% textField1 = "form1[0].#subform[0].TextField1[0]"<br />do what you like with it, save it in the database.<br /><br />ulf.a@dtp-tjanst.se