HTML/Javascript Connection Webservice C#

Question

I’m trying to make a connection to the bank using web service.

I even set up an example where I created the functions sum and multiply in my Webservice, but I’m having difficulty connecting my (HTML/Javascript) in my Webservice (C#).

I found several examples on the Internet, but none of them could resolve my doubts, for this reason I decided to ask here to see if someone could help me make this communication of Webservice with my HTML.

I need my HTML and Javascript to be separate from a web application because I want to use it (after understanding how communication works) phonegap to make requests to the database and return the values to the user.

I do not know if I could be very clear, but my idea is to have an app compiled in phonegap and access a webservice to request data that comes from the bank and load them in the app.

Answer 1

Regardless of the back-end language used to communicate with JS/HTML you must use a REST service, that is your application must return a JSON to any request made through JS.

Let’s imagine that your webservice is configured to receive SQL via query string (beware of the data that is released by your webservice for security reasons), so we have something like this:

http://webservice.meusite.com?query=SELECT%20*%20FROM%20user
(http://webservice.meusite.com?query=SELECT * FROM user)

by accessing this url your service should return something like:

{
    users:[
        {
            nome: "João",
            email: "[email protected]"
        },
        {
            nome: "maria",
            email: "[email protected]"
        },
        {
            /*...*/
        },
    ]
}

With jQuery you will do on a page http://webservice.meusite.com.br/teste.html:

$.ajax({
    url: "http://webservice.meusite.com?query=SELECT%20*%20FROM%20user",
    success : function(data){
        for(var i in data.users)
            console.log(data.users[i].nome);
    }
});

See the console output.

If you will use the request $.ajaxon a different domain you should use JSONP