how to pass a value in this webservice?
Hi,
I made a webservice for fetching data from a database. It works good.
Now i would like to add a parameter to the sql command. The user should enter a value (pcnr) before the data is fetched. I tried to add a texbox but it doesn't work.
How can i do that?
Thanks
Bob
My code:
.....
<WebMethod()> _
Public Function pcinfo() As DataSet
Dim oConnection As OleDbConnection
Dim pcnr As Integer
Dim d As OleDbDataAdapter
oConnection = New OleDbConnection()
Dim sql As String
Dim ds As New DataSet
Dim tb As New TextBox
pcnr= Convert.ToInt16(tb.Text)
sql = "SELECT * from pc where pcnr=" & pcnr & ";"
Dim sConnectionString As String
sConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = c:\mytable.mdb"
d = New OleDbDataAdapter(sql, sConnectionString)
d.Fill(ds)
Return ds
End Function
....
|