Is there a way we can pass a parameter to the UDCX data connection? I believe no. So, what could be the workaround?
I have a requirement where I need to pass some value in query and get the record from database and need to show up on infopath form.
So, to get that I have to pass parameter to the sql query. I believe below are the possible implementations.
1. Write ADO.NET logic to get the data from database and bind it to form fields.
2. Add a custom web service and write the queries logic in it and use it.
Are there any simple and better ways to do this? I just need to pass an integer to sql server and get the record matched to that number.
Please let me know the ways.
ASP.NET and SharePoint developer
View Complete Post