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
....