Skip to content

22 Responses

Leave a Comment
  1. matt m / Apr 13 2012

    Great posts (both parts), they are exactly what I was looking for. My question is this, you transmit the password as part of the URI which is visible to anybody who sees the request. How would one pass this information contained within the request but not as part of the URI?

    • Guruparan Giritharan / Apr 14 2012

      you can use a encoding mechanism to encode the password.
      when you create the service you give the uri only to the clients so others wont know it even the application user will not know it.

  2. moh / May 5 2012

    how to deploy it on iis ?

    • moh / May 5 2012

      i mean part1 of course

      • Guruparan Giritharan / May 5 2012

        I think its like deploying a website just publish it and put the files iis server folder and publish like a website

  3. rajasekhar / Sep 12 2012

    nice post..
    you get the values from the DB.. its work fine .. now i want to POST the values… into the Sql server via WCF service using JSON … for example i have two text fields with values and a button..
    if i click on the button the two values in the textfields should insert into the SQL server database using the WCF service ….
    thank u

    • Guruparan Giritharan / Sep 13 2012

      You can use the same way to get the values
      Here the Username and password are sent to the server via a query string,
      You can use these values in an insert query and store it in the database

  4. Guna / Oct 12 2012

    First of all, I would like to said thank you so much for this wonderful Tutorial.Its very Helpful for my project.I have create INSERT,DELETE,UPDATE but i have problem when i wanna return List data to android.Can you show me the guideline regarding this will be very helpful for me.Thanks again.

  5. Guruparan Giritharan / Oct 14 2012

    Can you explain me the problem??

  6. Guna / Oct 23 2012

    Hi bro,
    Thank u for your respond, above problem i have solved & now facing problem when i try to send large data of parameter to WCF service & i have try list & array but still i getting error message saying.Hope you can guide me in this as you are expert in topic.thanks in advance bro.

    This is the WCF web service Error Message:

    Operation ‘insertRecord’ in contract ‘IService1′ has a query variable named ‘list’ of type ‘System.Collections.Generic.List`1[System.String]‘, but type ‘System.Collections.Generic.List`1[System.String]‘ is not convertible by ‘QueryStringConverter’. Variables for UriTemplate query values must have types that can be converted by ‘QueryStringConverter’.

    • Guruparan Giritharan / Nov 10 2012

      Hi ,
      Sorry for the late reply,
      The problem is you can send only one parameter at a time and sending an array is not possible,
      You can have a method and call it several times.

  7. sahil kaundal / Mar 3 2013

    Nice “login with sql server” for my first android application. Thanks

  8. bharath / Jul 8 2013

    how to run this program in single pc..using emulator please guide

    • Guruparan Giritharan / Jul 10 2013

      The given sample runs in a single pc and emulator

  9. bharath / Jul 15 2013

    thank u sir for ur iam facing the problem that is how to retrieve the data from sql-server and displaying in listview..please provide any website-link..or tell me the modifications please…

  10. Viresh N Y / Jul 18 2013

    Thank you Very much for this post.
    this post helped me a lot.

  11. Smrati / Aug 5 2013

    Hello Guruparan!
    Thank you very much for this post. I want to have your ideas on a similar question. I want to display an image from sql server to Android via json and wcf .
    Any help would be highly appreciated.
    Thanks and Regards

    • Guruparan Giritharan / Aug 6 2013

      I think its better if you can put the image in the IIS and send the URL as a string in WCF.
      then you can download the image to android app using the URL :)

  12. Smrati / Aug 6 2013

    Thanks for ur reply but storing in IIS is not a good idea ; However , could you tell me how can I parse this JSON : notif_detailsResult”:[{"image":[255,216,255,224,0,16,74,....

    My image is stored in varbinary form and I'm using Blob object for inserting an image.
    I'm getting it from my web service :
    [WebInvoke(Method = "GET",
    BodyStyle = WebMessageBodyStyle.Wrapped,
    ResponseFormat = WebMessageFormat.Json,
    RequestFormat = WebMessageFormat.Json,
    UriTemplate = "notif?notif_id={notif_id}")]
    List notif_details(int notif_id);

    Implementation :
    public List notif_details(int notif_id)
    SteelcaseMigrationEntities entities = new SteelcaseMigrationEntities();

    return entities.notif_id(notif_id).ToList();

  13. Ahmed Alla Alden / Sep 29 2013


    i publish these example to iis on my pc, and successfull when i used url


    but in the android that is not work


  14. Philipe Labliuk / Oct 7 2013


    I got this error in main.xml:

    Incorrect line ending: found carriage return (/r) without corresponding newline (/n)

    What should I do?

  15. beni / Oct 29 2013

    how can i get the data from sql server using json and fill the data in expapandable listview or can u help my its urgent please !!!

Leave a Reply