Parameterized Query in Distributed Application (winform)
I've created the following distributed application:
Solution
EDSQLWSVC EDEmployerWinClient Project3
Web Service winform app asp.net web app
My web services are fine....and I can get data in, out etc. My problem is this:
I want to use the data adaptors in the web services for the windows client application. Only problem is...when i want to run a parameterized query in the client application...I get errors flagging the SQL Statement and the Parameterization. Big ones. SO...How do I parameterize the query? I've done it in the Data Adaptor's SQL Statement in the web service, and on the windows form, I've tried:
Private Sub GetRecs_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles GetRecs.Click
Dim ws As New EDEmployerWinClient.EDEmployerService.EmpService
ws.Credentials = System.Net.CredentialCache.DefaultCredentials
EmpRecData.SelectCommand.Parameters("Param1").Value = Textbox1.Text
EmpRecsDa1.Clear()
EmpRecsDa1.Fill(EmpRecsData)
EmpRecsData.Merge(ws.GetRecs())
End Sub
EDEmployerService is the web reference, and EmpService is the Web Service
All I want it to do is to Select only the records based on the Parameter. In my SQL Statement, I have "SELECT Tbl_One.* FROM Tbl_One WHERE Email = @Param1"
This is my first time trying to parameterize a SQL Statement through web services..so I'm a bit lost. Any ideas where someone's done something similar?