Referencing a stored procedure in my SQL database to fill a text box

DTaylor730 — Mon, 09 Jun 2008 23:03:46 GMT

This seems like I should know this but I am stuck. I have VSTA and a InfoPath form with a textbox that needs to be loaded on startup. The database has a stored procedure to take the logged-in user name as a parameter and return multiple lines of the "tblOffice" including things like Office name, Address, Phone and Fax. The users login tells the stored procedure which office to return.

Can I run a stored procedure on the connected database and if so how do I code it and where is the data returned?

Data Connections

Referencing a stored procedure in my SQL database to fill a text box