how to call a asp.net webservice in android using phonegap

Question

I have a asp.net web service accessing value from database using a datatable and my javascript goes like this in eclipse where it is running in android simulator using phonegap but this code seems not to be working .pls help me out.

<script type="text/javascript">
     function GetAge() {
         jQuery.support.cors = true;
          $.mobile.allowCrossDomainPages = true;
           $.ajax({
          data: datas, 
             type: "POST",
            async: false,
            dataType: "json",
             contentType: "application/json; charset=utf-8",   
             url: "http://localhost:50113/Service1.asmx/mydbCon?wsdl",
             success: function (msg) {
                $('#divToBeWorkedOn').html(msg.text); 
             },
             error: function (e) {
                 $('#divToBeWorkedOn').html("unavailable");
             }
         });
     } 
  </script>

and my service1.asmx goes like this

[WebMethod]
    [ScriptMethod(ResponseFormat = ResponseFormat.Json)]
    public DataTable mydbCon()
    {
        SqlConnection SqlCon = new SqlConnection("");
        SqlCon.Open();
        SqlCommand SqlComm = new SqlCommand();
        SqlComm.Connection = SqlCon;
        SqlComm.CommandType = CommandType.Text;
        SqlComm.CommandText = "select password from tbl_login where username='aby';";
        DataTable EmployeeDt = new DataTable("tbl_login");
        SqlDataAdapter SqlDa = new SqlDataAdapter(SqlComm);
        SqlDa.Fill(EmployeeDt);
        return EmployeeDt;
    }

is mydbCon the method name in the service1.asmx? can you show the content of service1.asmx? — JP Hellemons
– JP Hellemons, Commented Aug 23, 2012 at 9:34
stackoverflow.com/a/2979938/169714 and why do you use ?wsdl? — JP Hellemons
– JP Hellemons, Commented Aug 23, 2012 at 9:45
because you just return a datatable instead of json, please use json.codeplex.com — JP Hellemons
– JP Hellemons, Commented Aug 23, 2012 at 9:47

JP Hellemons · Accepted Answer · 2012-08-23 10:02:42Z

3

Add Json.Net to your solution with the package manager console or by the dialog

and then:

[WebMethod]
[ScriptMethod(ResponseFormat = ResponseFormat.Json)]
public string mydbCon()
{
    SqlConnection SqlCon = new SqlConnection("");
    SqlCon.Open();
    SqlCommand SqlComm = new SqlCommand();
    SqlComm.Connection = SqlCon;
    SqlComm.CommandType = CommandType.Text;
    SqlComm.CommandText = "select password from tbl_login where username='aby';";
    DataTable EmployeeDt = new DataTable("tbl_login");
    SqlDataAdapter SqlDa = new SqlDataAdapter(SqlComm);
    SqlDa.Fill(EmployeeDt);
    return JsonConvert.SerializeObject(EmployeeDt, Formatting.Indented);
}

Here is the link of Json.Net on the nuget gallery: http://nuget.org/packages/Newtonsoft.Json

answered Aug 23, 2012 at 10:02

JP Hellemons

6,04212 gold badges68 silver badges136 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Dennis Over a year ago

hey thanks for the code but i cant insdtall json.net in visual studio express 2010 since I dont have the option library package manager .Let me ask my admin to install VS ultimatum and try this out any way thanks a lot

JP Hellemons Over a year ago

or download the dll, put it in your bin folder and reference it

JP Hellemons Over a year ago

or open your solution in visual web developer express stackoverflow.com/questions/4566908/… do you have nuget installed? visualstudiogallery.msdn.microsoft.com/…

Collectives™ on Stack Overflow

how to call a asp.net webservice in android using phonegap

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related