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