Re: No-code or sandboxed solution code to dynamically query SQL db

Anson Hidajat — Wed, 18 Apr 2012 17:05:42 GMT

You should check out the QueryDB web service in DBXL. Without any code, you can use a data connection to the web service to query SQL databases and return data back to your InfoPath form as a secondary schema.

Here is a link for more info and to download a trial: http://www.qdabra.com/en/products/DBXL.aspx

No-code or sandboxed solution code to dynamically query SQL db

cryptics — Mon, 16 Apr 2012 17:14:43 GMT

Hi all, I'm working in a no-code (or limited code) environment and I need to dynamically query a SQL database based on the selected value of a drop down control. I'm using InfoPath 2010, publishing to SharePoint 2010, and accessing SQL Server. I can do this in code by updating the commandText with C#, but the AdoQueryConnection adoconnection = (AdoQueryConnection)DataConnections["Data_Connection"] and adoconnection.ExecuteQuery() are not allowed in a SharePoint sandboxed solution. I tried tweaking manifest.xsf with no luck. I know there are a lot of restrictions here, but I'm hoping someone knows a way. Thanks for your help!

SQL Database Integration

Re: No-code or sandboxed solution code to dynamically query SQL db

No-code or sandboxed solution code to dynamically query SQL db