HOME       >>       Programming

Microsoft Infopath Sql Query How do I query a large SQL database from an Infopath Form?


Hi I was wondering if anyone knows how to query a large SQL database from an Infopath Form?I am able to connect to the SQL database from Infopath but it retrieves all the tables from SQL instead of only connecting to SQL and retrieving the required information in the tables.I see there is an option for a click function within a button but the code needs to be in C# , and I am only a beginner with Delphi.Does anyone have some sample code that I could insert into this click function to connect to my SQL database and retrieve the information from within multiple tables then display them back in the form?I am using Microsoft Office Infopath 2007, could this be done only using Infopath or would I need to use Visual Studio?Thanks in advance.


Xisto.com offers Free Web Hosting to its Members for their participation in this Community. We moderate all content posted here but we cannot warrant full correctness of all content. While using this site, you agree to have read and accepted our terms of use, cookie and privacy policy. Copyright 2001-2019 by Xisto Corporation. All Rights Reserved.