From: snow on
Hello,

I have a VS 2003.NET application that connects to a Access database. I
want to make its code work in VS 2005. Here is the code for VS
2003 .NET:

da1.UpdateCommand.CommandText = "update TABLE1 set FIELD1 = "
&
value2 & " where FIELD1 = " & value1
return_val = da1.UpdateCommand.ExecuteNonQuery()

If return_val = 0 Then
da1.InsertCommand.CommandText = "insert into TABLE1(FIELD1)
values (" & value2 & ")"
da1.InsertCommand.ExecuteNonQuery()
End If

How could I change dataAdapter (da1) to a tableAdaper to implement
this function.

Thanks for the help!