how recive a DataSet from a webmethod function??
hello guys.....im trying to recive a dataset form a webservice method...so i can show the results in a windows form...here is the code.
Code:
<WebMethod()> _
Public Function BuscarProducto(ByVal codigo As Integer) As DataSet
Dim Conn As String = "Data Source=.\SQLEXPRESS;AttachDbFilename='C:\Users\Master\Documents\Visual Studio 2005\Projects\Prueba 2\DB_prueba3.mdf';Integrated Security=True;User Instance=True"
Dim Adapt As SqlDataAdapter
Dim DS As New DataSet
Dim strSelect As String
strSelect = "Select nom_pro, precio_pro FROM Productos WHERE Productos.id_pro = '" & codigo & "'"
Adapt = New SqlDataAdapter(strSelect, Conn)
Adapt.Fill(DS, "Productos")
Return DS
End Function
and here is the windows form button search by codigo
Code:
Dim DS As DataSet = MiServ.BuscarProducto(TextBox1.Text)
With DS.Tables("Productos")
TextBox2.Text = .Rows(0).Item(1)
TextBox3.Text = .Rows(0).Item(2)
im a new on this.......THX