Question

I have this situation where I need to modify the insert command after is generated by the sqlcommandbuilder, and I need to do this to get the scope_identity after the insert. Part of the code is :

adapterClients = new SqlDataAdapter (cmdClients, connString);
SqlCommandBuilder cmdBuilder = new SqlCommandBuilder (adapterClients);
adapterClients.Fill (dataSet, "Clients");
adapterClients.InsertCommand.CommandText += "; select ClientID = SCOPE_IDENTITY()";
adapterClients.InsertCommand.UpdatedRowSource = UpdateRowSource.FirstReturnedRecord;

I get a null exception on adapterClients.InsertCommand.

Answer 1

自动生成的“指挥”将成为建筑者而不是适应者的一部分。因此,你想利用下面的文字来检索“指挥”:

cmdBuilder.GetInsertCommand()

因此,根据你在努力做些什么,你可以使用以下方法:(1) 规定所生成的指令给适应者,然后(2) 修改所生成的指令,以包括重新掌握范围——身份。

adapterClients.InsertCommand = cmdBuilder.GetInsertCommand();
adapterClients.InsertCommand.CommandText += "; select ClientID = SCOPE_IDENTITY()";

友情链接