I have a problem with a webservice that I created and I tried several options and I could not solve it.
I have a list of Methods available as shown below
WhenIselecttheVAPSmethod,theformforfillinginthefieldsappearscorrectlyandifIfillinandsenditworkscorrectly.
TheurlthatmustbebuilttobeinvokedbyGETmusthavethefollowingformatasperthedocumentation.
ButwhenIrunthisurlIgetthefollowingmessage
Allothermethodsarefunctional,themethodnotfoundproblemoccursonlywiththeonethatisanewimplementation,Ibelievethereissomethingintheprojectthathasnotbeenupdated.
Hasanyonegonethroughthisandwouldhaveasolution?
IhavealreadyrestartedMachine,ISS,VisualStudio,changedinputparameters,returntypeandnoneofthatworked.
<WebMethod()>PublicFunctionVAPS(CodTransacaoAsString,EmailAsString,Cod_ProdAsInteger)AsBooleanDimcnAsNewMySqlConnectionDimsqlAsStringTrysql="SELECT * FROM TBL_CONCLUDED WHERE COD_PROD=@CodProd AND COD_TRANS=@CodTrans AND email=@email"
Dim cmd = New MySqlCommand(sql, cn)
cmd.Parameters.AddWithValue("@CodProd", Cod_Prod)
cmd.Parameters.AddWithValue("@CodTrans", CodTransacao)
cmd.Parameters.AddWithValue("@email", Email)
cn.ConnectionString = ConfigurationManager.AppSettings("StrConn")
Dim DA As New MySqlDataAdapter(cmd)
Dim dt As New Data.DataTable
cn.Open()
DA.Fill(dt)
MsgBox(dt.Rows.Count)
If dt.Rows.Count > 0 Then
Return True
Else
Return False
End If
Catch ex As Exception
'MsgBox(ex.ToString)
Return False
End Try
cn.Close()
End Function