TableAdapter 不更新 DataTable 中的内存值

发布于 2024-12-08 14:21:30 字数 767 浏览 0 评论 0原文

我有一个带有设计者构建的 .Update() 命令的 TableAdapter。 TableAdapter 还有一个命令，该命令将仅更新其中一条记录中的一个字段。该命令是.AddBankName。

但是 .AddBankName 似乎导致 .Update() 引发并发冲突。仅当 .AddBankName 实际上更改数据库中的 BankName 字段时才会发生这种情况。

因此，我认为发生的情况是 TableAdapter 中的 AddBankName 查询没有更新 TableAdapter 维护的数据库表的内存记录。

如何使 AddBankName 进行正确的更新。或者 - 我自己该怎么做？

这是我的代码的摘录。 UpdateDB 可以多次调用...

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

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

原文

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

分享到QQ

分享到微博