How to replace the dataAdapter with tableAdapter?   

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!

date: Thu, 3 Jul 2008 11:40:41 -0700 (PDT)   author:   snow