Click here to Skip to main content
15,851,319 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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 :
<add name="HttpSoap12"/>
<add name="HttpSoap"/>
<add name="HttpGet"/>
<add name="HttpPost"/>
Updated 10-Aug-18 5:44am

1 solution

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

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
Share this answer

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900