Help with forms that look like PDF and populate form DB

I am looking for a software that will allow me to create forms for a Web application.
Some of the forms data comes from a MS SQL database and should populate the form, the rest user should be able to type in the form and save it, then open it again and see all the information as it is was when they last saved it.

Does Adobe has any solutions that can do this ?  Any other provider ?
LVL 1
AleksAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Big MontySenior Web Developer / CEO of ExchangeTree.org Commented:
sharepoint comes to mind, depending on your infrastructure, it may be overkill.

adobe does offer form building functionality, if that's what you're familiar with, it's probably the best solution.

did you not want a classic asp solution?
0
AleksAuthor Commented:
what would classic asp solution be?
0
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
The best way is to simply save the data back to the database.

If you are not great with html, you can use a forms builder like http://bootsnipp.com/forms or http://www.phpform.org/.   phpform will output code for php, just ignore it and replace with asp code to accept a form.

If you are not sure about how to accept form data, there are two parts, accepting the input (<%request.form("somefield")%>) and writing do the database.
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

AleksAuthor Commented:
Don't get me wrong. I can create ASP pages that will gather the data from each form and save it in the database, that is all fine, the problem is at the end, the data needs to be presented in the exact way the PDF form from government looks like and generate a 2D bar code as well.
If I have all this information in my database already how can I export it to a PDF file and populate it with all this data ?  so that it can be emailed, printed 2D bar code created, etc.
0
Big MontySenior Web Developer / CEO of ExchangeTree.org Commented:
what would classic asp solution be?

to write the code yourself. I haven't come across any 3rd party classic asp form builders...

it's pretty straightforward, if you already have a connection to your database, you're half way there!

I guess before proceeding any further, what do you rate your skill set in classic asp? if you feel comfortable enough to tackle it on your own, I would suggest going that route. all to often form builders generate a lot of unnecessary code, creating your own you're able to keep it as clean as possible.
0
Big MontySenior Web Developer / CEO of ExchangeTree.org Commented:
ok that's good, sounds like you have most of it nailed down.

to create a pdf file, you'll need a 3rd party component, such as aspPDF
0
Big MontySenior Web Developer / CEO of ExchangeTree.org Commented:
I would first create your form, make sure it's saving/retrieving the data as it should, then once that's working, work on generating a pdf file. There's lots of questions on here that deal with pdf generation, or if you have a specific issue, just ask and I'm sure someone will be able to help you out.
0
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
You can populate the a pdf dynamically using xml.   You can use adobe acrobat to create the form and fields.  You can generate static xml from that and use that to create your dynamic xml.    The other options is using  a pdf generator like  http://www.asppdf.com/ or http://www.websupergoo.com/abcpdf-1.htm.

If you want to do this on the fly without one of those tools, I generate the bar code with js/jquery.  There are a lot of options

https://github.com/lindell/JsBarcode
http://www.barcoderesource.com/htmlBarcode.shtml
http://www.jqueryscript.net/other/Simple-jQuery-Based-Barcode-Generator-Barcode.html

Check out http://www.telerik.com/kendo-ui#a-complete-framework-for-modern-web-and-mobile-app-development.  I think sencha has this too.  Kendo has some open source options but I think the barcode is not open source.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AleksAuthor Commented:
Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.