I am trying to download wirelessly or cradled, data from 3 Access 2003 tables into my SQLCE 3.5 datatables. I already have a successful method + web method that uploads data from my sqlce datatables into the Access 2003 tables. I just need feedback to know if I'm headed in the right direction.
Web method:
Public Function UpdateSqlCeData(ByVal downloadSet As DataSet) As Boolean
' Connect to Access DB here, execute command and populate data set with returned data.
Me.Server.ScriptTimeout = 600000
Dim strSql2 As SqlCeCommand
Dim oleDbDataset As System.Data.DataSet = New DataSet
Dim sqlParam As New SqlCeParameter
Dim fhAccDt, fhCeDt As New DataTable
strSql2 = Nothing
sqlParam = Nothing
'Connection string to connect to access DB
Dim FHLiveDB As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\testpre\testservertest.mdb")
Dim Pbrd As New OleDb.OleDbDataAdapter("SELECT * FROM tblProductBrand", FHLiveDB)
FHLiveDB.Open()
Pbrd.Fill(oleDbDataset)
With strSql2
.CommandTimeout = 600000
.CommandText = "INSERT INTO Product_Brand ([BrandID],[Brand_Name]) VALUES (@Brand_ID,@Brand_Name)"
sqlParam = .Parameters.Add("@Brand_ID", SqlDbType.NVarChar, 50, "Brand_ID&
View Complete Post