InfoPath Dev

yes.  I have read this link before. Now the problem becoms how I can invoke the stored procedure and save the returned result into an xml file. Then the rest part is set. By the way, I am wondering if there is a simpler way to set up a parameteriized query directly for the dropdown list control.Thanks in advance for you advice! --- ...

Thanks for your advice. I have created the stored procedure. Then how can I populate the dropdown list with the returned dataset?

Hello all,           I have a a dropdown list control bound to the main data source in a SQL server. I would like to make the wild card query to the table by Supplier Name say Abc* and then pick only one record from the result set. In addition, the other fields in the form will be updated based on the ...