Click here to Skip to main content
15,796,299 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 :
<webservices>
<protocols>
<add name="HttpSoap12"/>
<add name="HttpSoap"/>
<add name="HttpGet"/>
<add name="HttpPost"/>
Posted
Updated 10-Aug-18 5:44am
v3

1 solution

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

But you call it with ExecuteNonQuery
C#
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
 
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