SQL Database Integration

Re: Link on ASP page to open Form with data from db

Shyam — Tue, 04 Oct 2005 22:34:51 GMT

Dave,

Here are the two possible scenarios.

1) You are storing the InfoPath XML as is (along with shreading it to DB). Say in a Sharepoint Document library or file system. In that case your ASP page you will point the hyper link column to point to the appropriate file in sharepoint document library. This would be relatively staright forward.

2) In the other scenario of where you don't have the xml, then you have to cook the xml(with infopath PI etc) and throw it to browser as an attachemnt, and InfoPath form would get opened. While cooking the xml you can either put all the row data in the xml and load the infopath, or just put the row_id and make infopath get the data when it loads-up. So the link on your asp page will be something like "CookXml.asp?row_id=1234", and this page can do the work of preparing the xml and throwing to browser. This too is not hard in C#, but i am not sure about ASP.

hope this helps :)

thanks,
Shyam

Shyam
InfoPath Dev
India

Re: Link on ASP page to open Form with data from db

Patrick Halstead — Tue, 04 Oct 2005 06:26:14 GMT

You'll have to add code to get the XML data from the database and send it to IE. Shyam may have more details...

Patrick Halstead [InfoPath MVP]
InfoPathDev

Link on ASP page to open Form with data from db

drobins — Mon, 03 Oct 2005 15:26:19 GMT

Here is my situation. I have a form that inserts information into a database (created form from data connection).

My HR department wants to be able to view some of the info from the web. This is not a problem as I can do a simple ASP (not .NET) to display some of the information.

What i want to know is, can I supply a link for each of the records listed to then have that record open up in the form

Dave