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?