问题描述
所以,我这个工作最后一周了。至少,我想我做到了!http://stackoverflow.com/questions/548091/datagridview-update
So I had this working last week. At least, I thought I did!http://stackoverflow.com/questions/548091/datagridview-update
然后,我开始工作今天再度项目,并正在逐渐
Then I start working on the project again today and am getting
更新要求当传递的DataRow集合与已修改行有效的UpdateCommand。
"Update requires a valid UpdateCommand when passed DataRow collection with modified rows."
在
scDB.SSIS_Configurations_StagingDataTable table = (scDB.SSIS_Configurations_StagingDataTable)stagingGrid.DataSource;
myStagingTableAdapter.Update(table);
的StagingTableAdapter有一个附加的查询这需要'过滤'作为参数。这是用来填充gridview的。在向导创建查询我看到'更新生成。我看到大部分的帖子,出现此错误需要用命令生成器生成一个更新语句。我该怎么办?
The StagingTableAdapter has an additional query which takes 'filter' as a parameter. That was used to fill the gridview. In the wizard for creating that query I see 'update was generated'. I see that most posts with this error require that an update statement be generated with a command builder. What do I do?
推荐答案
该错误是相当字面:这种适配器需要一个有效的SQL Update语句。数据集设计师和CommandBuilders会为你生成这些,但并没有什么错手工制作一个位SQL任。
The error is quite literal: The Adapter needs a valid SQL Update statement. Dataset designers and CommandBuilders will generate these for you, but there is nothing wrong with hand-crafting a bit of SQL either.
不管怎样,你必须验证器(Debugger)的更新语句仍配置和它实际上是什么。这可能是更多的是SQL不是C#的问题。
Anyway, you'll have to verify (debugger) that the Update statement is still configured and what it actually is. It could be more of a SQL than a C# problem.
编辑:命令Builder工具将只处理直,单表,Select语句。使用JOIN或任何幻想,你是你自己的。
the Command Builder tools will only handle straight, single table, Select statements. Use a Join or anything fancy and you're on your own.
这篇关于更新要求当传递的DataRow集合与已修改行有效的UpdateCommand的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!