Web Service Dataset (inserting Into CE)

Howdy,

Am having an issue using a dataset returned from a web service method. The webservice grabs data from a desktop SQL server database and returns it as a dataset.

I can call the web service fine and load the dataset into a datagrid (testing purposes). etc

However am having an issue with inserting the dataset data into the Windows CE Database.






Web Service Method


<WebMethod(Description:="Query a database. Returns a dataset.")> _
Public Function GetData(ByVal connectionString As String, ByVal selectcommand As String) As DataSet
Dim ds As DataSet = New DataSet()
Dim connection As SqlClient.SqlConnection = New SqlClient.SqlConnection()
Dim Command As SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand()
Dim DataAdapter As SqlClient.SqlDataAdapter = New System.Data.SqlClient.SqlDataAdapter()

connection.ConnectionString = connectionString
connection.Open()

Command.Connection = connection
Command.CommandText = selectcommand

DataAdapter.SelectCommand = Command
DataAdapter.Fill(ds)

Return ds
End Function





Insert Code


Dim ds as new dataset




ds = x.GetData("Data Source=Stephen01;Initial Catalog=BoxDB; uid=ste;pwd=1234;", "Select * from Swipes")

Try
For Each dr As DataRow In ds.Tables(0).Rows
db.Update("INSERT INTO Swipes (CardNo,Jobcode,ClockedAt,ClockType) VALUES(" & dr.Item(0) & "," & dr.Item(1) & "," & dr.Item(2) & ",'" & dr.Item(3) & "')")
Next

db.Close()
Catch ex As Exception
MsgBox(ex.ToString)
End Try(All Values are int's except Dr.item(3) which is a datetime field)


The when i click this button i get the error.

"Data Conversion Failed. [OLE DB status value (if known) = 2]"

I am guessing this is an issue to do with the date but to be perfectly honest i have no idea. Wish CE errors were more indepth!

Thanks

OutOfNicotineException