Search code examples
androidsqlsql-serverweb-servicessoap

Using an app to execute a web service and stored procedure

I am in the process of creating an Android application which I want to use to execute a web service on my SQL server which in turn runs a stored procedure.

Having never completed a project like this before, I would like to know what the best way to go about this is?

I.e.

  1. Displaying the SQL results
  2. Reading from the web service
  3. Adding password protection

I've developed apps before, but never SQL - related.

From doing some research I noted the need for a web service and created one, it's the process of running my app to read from it which I would like guidance with.

EDIT

To be more specific on the display.

Currently the stored procedure is displayed through crystal reports, however I have no need for 'drill - downs' or any functionality other than to actually view.

Something similar without the functionality would be fine.

Solution

  • I would recommend KSOAP with a SOAP webservice for proof of concept/tech demo http://seesharpgears.blogspot.com/2010/11/basic-ksoap-android-tutorial.html

    or use the built-in JSON parser with a restful/json webservice How to call a json webservice through android