TableAdapter Update

[RobZ via DotNetMonster.com]

Hi all,
I am using a tableadapter to read data from a table - no problem,

I have configured the Tableadapter to add an InsertQuery.

My problem is when I first Call the InsertQuery and then re-load the data (
into a list ) the new row does not appear, however if I re-call the
InsertQuery again (but this time with different data) the first inserted
Row now appears, this continues, each Time the InsertQuery gets called it
adds the PREVIOUS Data, (Even if I shut the app down & restart)

Somehow the row IS being added, I just can't seem to read the new Row until
another insert has happened.

I read the data with tableAdapter.GetRows().Select()

I have tried to use the update method but I can't get it to work.

any Ideas?

 

[RobZ via DotNetMonster.com]

Sorry, I must be getting Old,
Table WAS being updated, If you don't display the last record from a
recordset, it shows the above behaviour
Mind for Sale, (only slightly used)