TableAdapter not updating in-memory values in DataTable

Asked Oct 04 '11 at 10:55

Active Oct 17 '11 at 09:09

Viewed 446 times

I have a TableAdapter with a designer-built .Update() command. The TableAdapter also has a command which will update just one of the fields in one of the records. This command is .AddBankName.

However .AddBankName appears to be causing .Update() to throw a Concurrency violation. This is only happening if .AddBankName is actually changing the BankName field in the DB.

So what I presume is happening is that the AddBankName query in the TableAdapter is not updating the in memory record of the database table which the TableAdapter maintains.

How can I make AddBankName do the correct update. Or - how do I do it myself?

This is an excerpt of my code. UpdateDB can be called multiple times...

Sub UpdateDB()
    'This Update will fail if AddBankName has previously changed BankName
    LETTERINFORMATIONTableAdapter.Update(tblTECHLETTERINFORMATION)

    LETTERINFORMATIONTableAdapter.AddBankName(cmbBANKNAME.Text, _ 
       txtCLIENTNUMBER.Text)
End Sub

edited Oct 17 '11 at 09:09

asked Oct 04 '11 at 10:55

El Ronnoco

11,753
5
38
65

What does the SQL you are using inside AddBankName to update the database look like? – lee-m Oct 04 '11 at 21:32
It's very basic such as `UPDATE LETTERINFORMATION SET BANKNAME=? WHERE ID=?` – El Ronnoco Oct 07 '11 at 08:22

TableAdapter not updating in-memory values in DataTable

0 Answers0