InfoPath Dev

The problem with my situation is, I want to filter the data connection based on the value in a textbox field on the infopath form. Let me explain what i did, I added a texbox a dropdown box and a button on the infopath form. Now the texbox fetches the value from a webservice for the userprofile. What i want is to populate the dropdownlist with ...

Is this webservice free or do I have to pay for it.

Just in case you need it in future Google with the keyword convert C# to VB and you will get a conversion tool

I have a textbox which displays the current User. I got that part running. But now I want to query a different database which has the User field associated with it. I want to query the SQL database such that it returns the results in the dataset. And finally I want to populate the result in the dropdownlist or repeating table. Preferably ...