looking for an Update Query in VB.NET that will work with a MySQL database

hi experts, This newbie would be grateful for any help here.

What I am looking for is a DatagridView Update Query in VB.NET that will work with a MySQL database. Failing that, code for a "Save Changes" button, but it's frustrating that the Visual part of VB isn't doing the job.

The datagridview on my VB.NET Form, when run,
will add new rows to the MySQL database, but
will NOT update changes there.

I have tried to run an ultimately simple version - one table with 2 fields - and still no luck.

Here's what  I've done:

created a MySQL database named {tomsdb1}
created a table  `mytable` with two fields:
(1)   `ID` (key, auto_increment)
(2)   `fld1` (integer)

Using VS 2008, Visual Basic.
created a database connection
created {tomsdb1dataset}
dragged the dataset over to form1 to create a DatagridView/TableAdapterManager

the code for SaveItem_Click is:
        Me.Validate()
        Me.MytableBindingSource.EndEdit()
        Me.TableAdapterManager.UpdateAll(Me.Tomsdb1DataSet)


My command text for the UpdateCommand of the
mytableTableAdapter is:
UPDATE `mytable` SET `fld1` = @fld1 WHERE `Id` = @original_Id;


When I run the form (F5), the dataset shows up fine, and is scrollable., so I know the FILL function and the SELECT query work.

when I add a new row and click the Save icon, that works too, so I know the INSERT query works

However if I make a change to any cell and try to save it,
I get  
>>>> "Parameter '@fld1' must be defined" <<<<

which leads me to believe the Update query needs to be fixed.
No matter how many online examples of this I go through, just can't seem to get it to run right.

I have recreated the exact same table with an MS ACCESS database, and it works fine; couldn't help noticing that with the MS ACCESS connection, Visual Studio goes ahead and creates the INSERT, UPDATE and DELETE queries. With the MySQL connection there is only the INSERT query and you have to write the UPDATE and DELETE yourself.

I've tried two other versions of the UPDATE query:

(1) UPDATE `mytable` SET `fld1` = @fld1 WHERE `Id` = @oldId;
where changing the second parameter to @oldId also gives me "Parameter '@fld1' must be defined"

(2) UPDATE `mytable` SET `fld1` = '@fld1' WHERE `Id` = '@original_Id';
where adding quotes around the parameters gives me a CONCURRENCY VIOLATION

Also tried without the terminating semi-colon, which made no difference.
Am now officially completely stumped.