I am trying to update a foxpro table but the da.update(ds,"sample") fails with an error about not being valid. Can someone tell me what I am doing wrong. I am new to this programming environment.I know the dataset gets fill with the foxpro table data and the dataset changes to the new information but the update to the actual foxpro table fails.
Dim da As OleDbDataAdapter = New OleDbDataAdapter(sqlStr, conn)
Dim cb As New OleDb.OleDbCommandBuilder(da)
Dim ds As DataSet = New DataSet
da.Fill(ds, "sample")
ds.Tables("sample").Rows(1).Item(0) = "frank"
ds.Tables("sample").Rows(1).Item(1) = "Scorzelli"
da.Update(ds, "sample")
Dim da As OleDbDataAdapter = New OleDbDataAdapter(sqlStr, conn)
Dim cb As New OleDb.OleDbCommandBuilder(da)
Dim ds As DataSet = New DataSet
da.Fill(ds, "sample")
ds.Tables("sample").Rows(1).Item(0) = "frank"
ds.Tables("sample").Rows(1).Item(1) = "Scorzelli"
da.Update(ds, "sample")