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
im a new on this.......THXCode:Dim DS As DataSet = MiServ.BuscarProducto(TextBox1.Text) With DS.Tables("Productos") TextBox2.Text = .Rows(0).Item(1) TextBox3.Text = .Rows(0).Item(2)




Reply With Quote