Question

DataAdapter.update()出错求助！ c#

public DataTable select(string name)
{
string oleDBComStr = "Select TOP 1 * From TrimForms where [name]='" + name + "';";
return select(oleDBComStr);
}
private DataTable select(string oleDBComStr)
{
string oleDBConStr = "provider=microsoft.ace.oledb.12.0;data source=" + DBAddress;
OleDbConnection oleDBCon = new OleDbConnection(oleDBConStr);
OleDbDataAdapter thisAdapter = new OleDbDataAdapter(oleDBComStr, oleDBConStr);
OleDbCommandBuilder oleDBCB = new OleDbCommandBuilder(thisAdapter);
oleDBCB.QuotePrefix = "[";
oleDBCB.QuoteSuffix = "]";
dt = new DataTable();
thisAdapter.Fill(dt);
return dt;
}
public void Save()
{
thisAdapter.Update(dt);
}

未处理 System.InvalidOperationException
Message="对于不返回任何键列信息的 SelectCommand，不支持 UpdateCommand 的动态 SQL 生成。"

求助呀！
还有那个dt上也看到有key呀

数据表库关系图

Answer 1

你的select语句有问题，DataAdapter构造函数根据你的oleDBComStr生成的SelectCommand返回值没有主主键，手动改一下吧。

Answer 2

是外键！！