InfoPath Prefill Using SQL Database

Question

I am creating an InfoPath form and want to retrieve data from an SQL database. I'm not looking for end users to fill in empty text fields, but I just want to fill the fields with data from an SQL database.

I searched some InfoPath / Microsoft blogs and sites to find out how to do this, but many of the things that I keep coming across show how to create fields that the end user can fill in, rather than fields that are pre-filled.

I already linked the database that I want to use in InfoPath and the "myfields" are already populated with the table that I use, so half the battle was won! :)

How can i do this?

Answer 1

, ...

-, , InfoPath, SQL () ... : http://social.technet.microsoft.com/Forums/en/sharepoint2010customization/thread/cb15a237-28cc-4d6b-8225-83181a7497ff

-, SQL, , InfoPath. , : http://vspug.com/ssa/2006/01/03/populating-infopath-fields-with-sql-data-using-managed-code/

, ...