I am working on an iPhone app to interface with my company SQL Server database. I will create stored procedures with queries that I need. Depending on the call, results can be individual elements (strings, dates, etc.), or a list of them.
I need some sample code which:
1) Creates the Sql Server webservice
- I will be creating several stored procedures which it will call. Some may expect parameters, others may not.
2) IPhone Objective C sample code to call the sql service webservice. It will need to pass multiple parameters, and then be able to translate the results into arrays - which will be displayed in table format.
I'm not sure how security would work with the calls, but the app can have the user enter a username and password for the sql server database, so this would have to be passed as well.
Please provide sample code for both parts - Creating the SQL Server Webservices - with comments on where to substitute server name, database name, etc... And, sample Objective C code for the Iphone on how to call that Webservice, passing parameters and security info, and then how to receive and translate those results into an array.