How To Append Dataset To Sqlce??

I'm having a bit of a problem figuring out how to pass a dataset to sqlce to be appended to a table.

I'm using the CSVDataAdapter.dll to import from a csv file. I'm able to load the data into a dataset but from there I'm having my problem. Since the recordset is not from my table that I want to write, how can I pass the recordset for appending?






Code Snippet

Dim ds = New DataSet()
da = New CSVDataAdapter(apppath + "DBmyfile.csv", True)

'Fills the recordset with CSV file information
da.Fill(ds, "Newfile")

'display in grid
Me.DataGrid1.DataSource = ds.Tables("Newfile")

Could I use - USING?





Code Snippet

Using cmd As New SqlCeCommand("Newfile", conn)
cmd.CommandType = CommandType.TableDirect

'code to manipulate the resultset
Using ds As SqlCeResultSet = cmd.ExecuteResultSet(ResultSetOptions.Updatable)
End Using