Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Please help ... web service for PPC

Status
Not open for further replies.

NMickey

Programmer
Nov 7, 2004
15
US
Hi all,

I want copy a dataset from web service and insert that dataset into my local table database in Pocket PPC in VB.NET. Any one can give the directions, I appreciate it.
Here I have so far:

<WebMethod()> Public Function GetCustomers() As DataSet
'Modify this Connection string to use your SQL Server and log on.
Dim con As New SqlConnection("Server=witster;uid=sa;pwd=Password1;database=northwind")
Dim daCust As New SqlDataAdapter("Select * From Customers", con)
Dim ds As New DataSet()
daCust.Fill(ds, "Cust")
Return ds
End Function

In PPC:
Dim ds As New localhost.Service1()
DataGrid1.DataSource = ds.Table(0)
'I want ds can inset into SQL Server CE local
'database table. Which means that I want to
'insert data from web service into my SQL Server
'CE local table in PPC.

Please help me...I am kind of stuck.

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top