JSON success!

<feeling smug/>

It's a simple thing I know, but here's a screenshot from my Android phone. I have written a web service that wraps the Project Sputnik Assets Business Layer and sends JSON data. The screen shot shows the data in my SQL database on my phone. I just need to put an Android UI together now that can consume the service and render it in a user friendly way!

 

Mike's Knowledgebase

I found this post REALLY helpful and worth a couple of hours working through the tutorials. It takes you through the process of setting up a WCF web service with a JSON payload to perform CRUD operations against SQL Server, and ultimately consume the service(s) in iOS.

http://mikesknowledgebase.com/pages/Services/WebServices.htm

RESTful web services

I've written SOAP WCF web services and I have heard the terms JSON (pronounced Jason) and RESTful services but I certainly have never written one or fully understand what they are. Wikipedia is always a good place to start, but a Google search of "rest web service example C#" came up with a very interesting first hit. I've spent some time today reading this article and looking at the code behind it.

REST Web Service using C# A walkthrough

Now I understand why Steve said I should use REST web services if I want my app to be usable on Android.