Click here to Skip to main content
13,793,288 members
Rate this:
 
Please Sign up or sign in to vote.
See more:
I have created a WCF services to connect my android app with my SQL database on online site.when I try to get data from my database using android app I got no error and no data I do not know if there is an error in my code.

What I have tried:

editing web.config by adding this :
<webservices>
<protocols>
<add name="HttpSoap12"/>
<add name="HttpSoap"/>
<add name="HttpGet"/>
<add name="HttpPost"/>
Posted 9-Aug-18 23:49pm
Updated 10-Aug-18 5:44am
v3

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

I'm not 100% sure about this but you have saveStaff defined as a query
Dim saveStaff As String = "select Spec from Password where Num = @AndroidNum AND Pass = @AndroidPass"

But you call it with ExecuteNonQuery
querySaveStaff.ExecuteNonQuery()

I'm not sure the net effect of this. It could be ignoring the query because it's a query and you're saying ExecuteNonQuery, or it could be running the query and just ignoring and not returning the results.

HTH, Mike
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Cookies | Terms of Service
Web02 | 2.8.181207.3 | Last Updated 10 Aug 2018
Copyright © CodeProject, 1999-2018
All Rights Reserved.
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100